|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'guild_member' table for MaNGOSThree
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.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| guildid | int(6) unsigned | NO | MUL | '0' | The ID of the guild that the member is a part of. [See guild.guildid] | |
| guid | int(11) unsigned | NO | PRI | '0' | The GUID of the player. [See character.guid] | |
| rank | tinyint(2) unsigned | NO | '0' | The rank that the player has in the guild. [See guild_rank.rid] | ||
| pnote | varchar(31) | NO | {Blank String} | The Player Note set by the player. | ||
| offnote | varchar(31) | NO | {Blank String} | The Officers Note set by officers in the guild. | ||
| BankResetTimeMoney | int(11) unsigned | NO | '0' | |||
| BankRemMoney | int(11) unsigned | NO | '0' | |||
| BankResetTimeTab0 | int(11) unsigned | NO | '0' | |||
| BankRemSlotsTab0 | int(11) unsigned | NO | '0' | |||
| BankResetTimeTab1 | int(11) unsigned | NO | '0' | |||
| BankRemSlotsTab1 | int(11) unsigned | NO | '0' | |||
| BankResetTimeTab2 | int(11) unsigned | NO | '0' | |||
| BankRemSlotsTab2 | int(11) unsigned | NO | '0' | |||
| BankResetTimeTab3 | int(11) unsigned | NO | '0' | |||
| BankRemSlotsTab3 | int(11) unsigned | NO | '0' | |||
| BankResetTimeTab4 | int(11) unsigned | NO | '0' | |||
| BankRemSlotsTab4 | int(11) unsigned | NO | '0' | |||
| BankResetTimeTab5 | int(11) unsigned | NO | '0' | |||
| BankRemSlotsTab5 | int(11) unsigned | NO | '0' |
Description of the fields
guildid int(6) unsigned
The ID of the guild that the member is a part of. [See guild.guildid]
guid int(11) unsigned
The GUID of the player. [See character.guid]
rank tinyint(2) unsigned
The rank that the player has in the guild. [See guild_rank.rid]
pnote varchar(31)
The Player Note set by the player, which can be read by everyone in the guild.
offnote varchar(31)
The Officers Note set by officers in the guild, which can only be read by other officers of the guild.
BankResetTimeMoney int(11) unsigned
BankRemMoney int(11) unsigned
BankResetTimeTab0 int(11) unsigned
BankRemSlotsTab0 int(11) unsigned
BankResetTimeTab1 int(11) unsigned
BankRemSlotsTab1 int(11) unsigned
BankResetTimeTab2 int(11) unsigned
BankRemSlotsTab2 int(11) unsigned
BankResetTimeTab3 int(11) unsigned
BankRemSlotsTab3 int(11) unsigned
BankResetTimeTab4 int(11) unsigned
BankRemSlotsTab4 int(11) unsigned
BankResetTimeTab5 int(11) unsigned
BankRemSlotsTab5 int(11) unsigned
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now