guild Table¶
Guild headers: name, leader, creation date, tabard emblem, public info and MOTD.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
guild_id |
int(6) unsigned | PRI | NO | 0 | |
name |
varchar(255) | NO | '' | ||
leader_guid |
int(6) unsigned | NO | 0 | ||
emblem_style |
int(5) | NO | 0 | ||
emblem_color |
int(5) | NO | 0 | ||
border_style |
int(5) | NO | 0 | ||
border_color |
int(5) | NO | 0 | ||
background_color |
int(5) | NO | 0 | ||
info |
text | NO | |||
motd |
varchar(255) | NO | '' | ||
create_date |
bigint(20) | NO | 0 |
Field Breakdown¶
guild_id- Primary Key. Guild identifier.name- Guild name (unique per realm).leader_guid- Guild master character guid (characters.guid).emblem_style- Guild tabard emblem style.emblem_color- Guild tabard emblem colour.border_style- Guild tabard border style.border_color- Guild tabard border colour.background_color- Guild tabard background colour.info- Public guild information text.motd- Message of the day shown to members at login.create_date- Date the guild was founded.