AzerothCore
Posts (Latest 10 updated) :
Read all

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(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

field-no-description|6

BankRemMoney

field-no-description|7

BankResetTimeTab0-5

field-no-description|8

BankRemSlotsTab0-5

field-no-description|9