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