|
id
|
int(100)
|
|
|
|
|
date
|
varchar(100)
|
|
|
|
|
patient
|
varchar(100)
|
|
|
|
|
doctor
|
varchar(100)
|
|
|
|
|
symptom
|
varchar(5000)
|
|
|
|
|
advice
|
varchar(5000)
|
|
|
|
|
state
|
varchar(100)
|
|
|
|
|
dd
|
varchar(100)
|
|
|
|
|
medicine
|
varchar(1000)
|
|
|
|
|
validity
|
varchar(100)
|
|
|
|
|
note
|
varchar(5000)
|
|
|
|
|
patientname
|
varchar(1000)
|
|
|
|
|
doctorname
|
varchar(1000)
|
|
|
|
|
signed_by
|
varchar(100)
|
|
|
|
|
hospital_id
|
varchar(100)
|
|
|
|