account

Relationships

erDiagram
    account {
        int id
        varchar name
    }
    account_flags {
        intunsigned p_accid
    }
    account_ip {
        int accid
        varchar ip
    }
    account_rewards {
        intunsigned account_id
        intunsigned reward_id
    }
    bug_reports {
        intunsigned account_id
        varchar zone
        intunsigned character_id
        varchar character_name
    }
    sharedbank {
        intunsigned acctid
        mediumintunsigned augslot1
        mediumintunsigned augslot2
        mediumintunsigned augslot3
        mediumintunsigned augslot4
        mediumintunsigned augslot5
        mediumint augslot6
        intunsigned itemid
    }
    account ||--o{ account_flags : "Has-Many"
    account ||--o{ account_ip : "Has-Many"
    account ||--o{ account_rewards : "Has-Many"
    account ||--o{ bug_reports : "Has-Many"
    account ||--o{ sharedbank : "Has-Many"

erDiagram
    account {
        int id
        varchar name
    }
    eventlog {
        varchar accountid
        varchar accountname
        varchar charname
    }
    gm_ips {
        int account_id
        varchar ip_address
    }
    hackers {
        varchar account
        varchar name
        varchar zone
    }
    petitions {
        varchar accountname
        varchar charname
        varchar lastgm
        varchar zone
    }
    account ||--o{ eventlog : "Has-Many"
    account ||--o{ gm_ips : "One-to-One"
    account ||--o{ eventlog : "Has-Many"
    account ||--o{ hackers : "Has-Many"
    account ||--o{ petitions : "Has-Many"

Relationship Type	Local Key	Relates to Table	Foreign Key
Has-Many	id	account_flags	p_accid
Has-Many	id	account_ip	accid
Has-Many	id	account_rewards	account_id
Has-Many	id	bug_reports	account_id
Has-Many	id	sharedbank	acctid
Has-Many	id	eventlog	accountid
One-to-One	id	gm_ips	account_id
Has-Many	name	eventlog	accountname
Has-Many	name	hackers	account
Has-Many	name	petitions	accountname

Schema

Column	Data Type	Description
id	int	Unique Account Identifier
name	varchar	Name
charname	varchar	Character name last logged in on this account.
sharedplat	int	Platinum in Shared Bank.
password	varchar	Private loginserver password.
status	int	Status
ls_id	varchar	Loginserver ID
lsaccount_id	int	Loginserver Account Identifier
gmspeed	tinyint	GM Speed: 0 = Disabled, 1 = Enabled
invulnerable	tinyint	Invulnerable: 0 = False, 1 = True
flymode	tinyint	Fly Mode
ignore_tells	tinyint	Ignore Tells: 0 = False, 1 = True
revoked	tinyint	OOC Revoked: 0 = False, 1 = True
karma	int	Karma
minilogin_ip	varchar	Minilogin IP Address
hideme	tinyint	Hide Me: 0 = Disabled, 1 = Enabled
rulesflag	tinyint	Rules Flag
suspendeduntil	datetime	Time Suspension of the Account ends
time_creation	int	Time Creation UNIX Timestamp
ban_reason	text	Ban Reason
suspend_reason	text	Suspension Reason
crc_eqgame	text	CRC for EQGame.exe
crc_skillcaps	text	CRC for SkillCaps file
crc_basedata	text	CRC for BaseData file