Guild member tc2

Back to characters database list of tables.

The `guild_member` table

This table holds information on the members of all guilds, their ranks in the guild, and any notes made by them or by guild officers.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guildid	int(10)	unsigned		NO			Guild Identificator
guid	int(10)	unsigned	Unique	NO
rank	tinyint(3)	unsigned		NO	0
pnote	varchar(31)	signed		NO	"
offnote	varchar(31)	signed		NO	"
BankResetTimeMoney	int(10)	unsigned		NO	0
BankRemMoney	int(10)	unsigned		NO	0
BankResetTimeTab0	int(10)	unsigned		NO	0
BankRemSlotsTab0	int(10)	unsigned		NO	0
BankResetTimeTab1	int(10)	unsigned		NO	0
BankRemSlotsTab1	int(10)	unsigned		NO	0
BankResetTimeTab2	int(10)	unsigned		NO	0
BankRemSlotsTab2	int(10)	unsigned		NO	0
BankResetTimeTab3	int(10)	unsigned		NO	0
BankRemSlotsTab3	int(10)	unsigned		NO	0
BankResetTimeTab4	int(10)	unsigned		NO	0
BankRemSlotsTab4	int(10)	unsigned		NO	0
BankResetTimeTab5	int(10)	unsigned		NO	0
BankRemSlotsTab5	int(10)	unsigned		NO	0

Description of the fields

guildid

The ID of the guild that the member is a part of. See guild.guildid

guid

The GUID of the player. See characters.guid

rank

The rank that the player has in the guild. See guild_rank.rid

pnote

The note set by the player that can be read by everyone.

offnote

The note set by officers in the guild that can only be read by other officers of the guild.

BankResetTimeMoney

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

BankRemMoney

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

BankResetTimeTab0-5

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

BankRemSlotsTab0-5

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.