|
patient_id
|
int(11) unsigned
|
|
|
|
|
pp_code
|
int(11)
|
|
|
|
|
ibp
|
varchar(225)
|
|
|
|
|
mcle
|
date
|
|
|
|
|
prefix
|
varchar(20)
|
|
|
|
|
fname
|
longtext
|
|
|
|
|
lname
|
longtext
|
|
|
|
|
mname
|
longtext
|
|
|
|
|
suffix
|
varchar(20)
|
|
|
|
|
address
|
longtext
|
|
|
|
|
phone
|
longtext
|
|
|
|
|
sex
|
varchar(225)
|
|
|
|
|
birth_date
|
date
|
|
|
|
|
blood_group
|
longtext
|
|
|
|
|
contact_person
|
text
|
|
|
|
|
ts
|
timestamp
|
|
|
CURRENT_TIMESTAMP
|
|
stat
|
int(11)
|
|
|
0
|
|
lawyer_type
|
varchar(20)
|
|
|
|