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
The ID of the guild that the member is a part of. See guild.guildid.
The GUID of the player. See characters.guid.
The rank that the player has in the guild. See guild_rank.rid.
The note set by the player that can be read by everyone.
The note set by officers in the guild that can only be read by other officers of the guild.