目录

guild_member 表


<-返回:Characters 数据库

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.

表结构

FieldTypeAttributesKeyNullDefaultextraComment
guildidINTUNSIGNED NO Guild Identificator
guidINTUNSIGNEDUniqueNO
rankTINYINTUNSIGNED NO
pnoteVARCHAR(31)SIGNED NO
offnoteVARCHAR(31)SIGNED NO

字段说明


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.