Table characters.guild_member
Guild System

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
guildid int unsigned 10 0
guild.guildid Defined in XML R
guid int unsigned 10 0
characters.guid Defined in XML R
rank tinyint unsigned 3 0
guild_rank.rid Defined in XML R
pnote varchar 255
offnote varchar 255
BankResetTimeMoney int unsigned 10 0
BankRemMoney int unsigned 10 0
BankResetTimeTab0 int unsigned 10 0
BankRemSlotsTab0 int unsigned 10 0
BankResetTimeTab1 int unsigned 10 0
BankRemSlotsTab1 int unsigned 10 0
BankResetTimeTab2 int unsigned 10 0
BankRemSlotsTab2 int unsigned 10 0
BankResetTimeTab3 int unsigned 10 0
BankRemSlotsTab3 int unsigned 10 0
BankResetTimeTab4 int unsigned 10 0
BankRemSlotsTab4 int unsigned 10 0
BankResetTimeTab5 int unsigned 10 0
BankRemSlotsTab5 int unsigned 10 0

Table contained 0 rows at Fri Feb 11 23:13 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
guid Must be unique Asc guid_key
guildid Performance Asc guildid_key
guildid + rank Performance Asc/Asc guildid_rank_key

Close relationships  within of separation: