目录

guild_member

<-Back-to:Characters

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 UNSIGNED NO Guild Identificator
guid INT UNSIGNED Unique NO
rank TINYINT UNSIGNED NO
pnote VARCHAR(31) SIGNED NO
offnote VARCHAR(31) SIGNED NO

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.