From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/guild_member.md | 271 +++++++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 262 insertions(+), 9 deletions(-) (limited to 'docs/guild_member.md') diff --git a/docs/guild_member.md b/docs/guild_member.md index 2455393..d1716f5 100644 --- a/docs/guild_member.md +++ b/docs/guild_member.md @@ -1,9 +1,262 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [guild_member](guild_member) - -Column | Type | Description ---- | --- | --- -Guildid | int(10) unsigned | -Guid | int(10) unsigned | -Rank | tinyint(3) unsigned | -Pnote | varchar(31) | -Offnote | varchar(31) | +# 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` -- cgit