charid
|
int(10)
|
|
|
|
identifier
|
varchar(200)
|
|
|
0
|
name
|
varchar(50)
|
|
|
|
firstname
|
varchar(50)
|
|
|
|
lastname
|
varchar(50)
|
|
|
|
dob
|
varchar(50)
|
|
|
|
gender
|
varchar(50)
|
|
|
|
cash
|
int(10)
|
|
|
0
|
bank
|
int(10)
|
|
|
0
|
phonenumber
|
varchar(20)
|
|
|
|
groups
|
longtext
|
|
|
[]
|
metadata
|
longtext
|
|
|
[]
|
inventory
|
longtext
|
|
|
[]
|