account¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
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 |
expansion | tinyint | Expansion |
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 |