friends

Relationships

erDiagram
    friends {
        intunsigned charid
        varchar name
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    friends ||--o{ character_data : "One-to-One"
    friends ||--o{ character_data : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	charid	character_data	id
One-to-One	name	character_data	name

Schema

Column	Data Type	Description
charid	int	Character Identifier
type	tinyint	Type: 0 = Ignore, 1 = Friend
name	varchar	Friend Name