| rec_id |
int(11)
|
|
|
|
| uid |
int(11)
|
|
|
|
| facility_id |
int(10)
|
|
|
|
| user_level |
int(10)
|
|
|
|
| perrole |
varchar(30)
|
latin1_swedish_ci
|
|
|
| full_name |
varchar(50)
|
latin1_swedish_ci
|
|
|
| email |
varchar(50)
|
latin1_swedish_ci
|
|
|
| phone |
varchar(100)
|
latin1_swedish_ci
|
|
|
| name |
varchar(200)
|
latin1_swedish_ci
|
|
|
| password |
varchar(200)
|
latin1_swedish_ci
|
|
|
| address |
varchar(150)
|
latin1_swedish_ci
|
|
|
| city |
varchar(50)
|
latin1_swedish_ci
|
|
|
| status |
int(11)
|
|
|
|
| created |
timestamp
|
|
|
|
| gender |
varchar(155)
|
latin1_swedish_ci
|
|
|
| dob |
varchar(150)
|
latin1_swedish_ci
|
|
|
| nationality |
varchar(150)
|
latin1_swedish_ci
|
|
|
| organization |
varchar(150)
|
latin1_swedish_ci
|
|
|
| profession |
varchar(150)
|
latin1_swedish_ci
|
|
|
| payment_recived |
tinyint(1)
|
|
|
|
| validity |
timestamp(6)
|
|
|
|
| ammount |
int(10)
|
|
|
|