guild_member Table¶
Guild roster with rank and public/officer notes.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
guild_id |
int(6) unsigned | MUL | NO | 0 | |
guid |
int(11) unsigned | PRI | NO | 0 | |
rank |
tinyint(2) unsigned | NO | 0 | ||
player_note |
varchar(255) | NO | '' | ||
officer_note |
varchar(255) | NO | '' |
Field Breakdown¶
guild_id- Guild reference.guid- Primary Key. Member character (characters.guid).rank- Rank id within the guild (guild_rank.id).player_note- Public note visible to all members.officer_note- Officer-only note.