|
identifier
|
varchar(60)
|
|
|
|
|
ssn
|
varchar(11)
|
|
|
|
|
accounts
|
longtext
|
|
|
|
|
group
|
varchar(50)
|
|
|
user
|
|
inventory
|
longtext
|
|
|
|
|
job
|
varchar(20)
|
|
|
unemployed
|
|
job_grade
|
int(11)
|
|
|
0
|
|
loadout
|
longtext
|
|
|
|
|
metadata
|
longtext
|
|
|
|
|
position
|
longtext
|
|
|
|
|
firstname
|
varchar(16)
|
|
|
|
|
lastname
|
varchar(16)
|
|
|
|
|
dateofbirth
|
varchar(10)
|
|
|
|
|
sex
|
varchar(1)
|
|
|
|
|
height
|
int(11)
|
|
|
|
|
skin
|
longtext
|
|
|
|
|
status
|
longtext
|
|
|
|
|
is_dead
|
tinyint(1)
|
|
|
0
|
|
id
|
int(11)
|
|
|
|
|
disabled
|
tinyint(1)
|
|
|
0
|
|
last_property
|
varchar(255)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
last_seen
|
timestamp
|
|
|
|
|
pincode
|
int(11)
|
|
|
|
|
iban
|
varchar(255)
|
|
|
|
|
phone_number
|
varchar(10)
|
|
|
|
|
scale
|
int(11)
|
|
|
1
|