guild_members

Relationships

erDiagram
    guild_members {
        int char_id
        mediumintunsigned guild_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    guilds {
        int id
        int leader
        varchar motd_setter
    }
    guild_members ||--o{ character_data : "One-to-One"
    guild_members ||--o{ guilds : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	char_id	character_data	id
One-to-One	guild_id	guilds	id

Schema

Column	Data Type	Description
char_id	int	Character Identifier
guild_id	mediumint	Guild Identifier
rank	tinyint	Rank
tribute_enable	tinyint	Tribute Enable: 0 = False, 1 = True
total_tribute	int	Total Tribute
last_tribute	int	Last Tribute
banker	tinyint	Banked: 0 = False, 1 = True
public_note	text	Public Note
alt	tinyint	Alt: 0 = False, 1 = True
online	tinyint