| id |
int(100)
|
|
|
|
| category_name |
varchar(1000)
|
utf8_general_ci
|
|
|
| patient |
varchar(1000)
|
utf8_general_ci
|
|
|
| date |
varchar(1000)
|
utf8_general_ci
|
|
|
| amount |
varchar(1000)
|
utf8_general_ci
|
|
|
| doctor |
varchar(1000)
|
utf8_general_ci
|
|
|
| discount |
varchar(1000)
|
utf8_general_ci
|
|
|
| flat_discount |
varchar(1000)
|
utf8_general_ci
|
|
|
| gross_total |
varchar(1000)
|
utf8_general_ci
|
|
|
| user |
varchar(1000)
|
utf8_general_ci
|
|
|
| patient_name |
varchar(1000)
|
utf8_general_ci
|
|
|
| patient_phone |
varchar(1000)
|
utf8_general_ci
|
|
|
| patient_address |
varchar(1000)
|
utf8_general_ci
|
|
|
| patient_email |
varchar(1000)
|
utf8_general_ci
|
|
|
| patient_gender |
varchar(1000)
|
utf8_general_ci
|
|
|
| date_string |
varchar(1000)
|
utf8_general_ci
|
|
|
| remarks |
varchar(1000)
|
utf8_general_ci
|
|
|
| date_delivery |
varchar(1000)
|
utf8_general_ci
|
|
|
| doctor_phone |
varchar(1000)
|
utf8_general_ci
|
|
|
| age |
varchar(100)
|
utf8_general_ci
|
|
|
| birthdate |
varchar(100)
|
utf8_general_ci
|
|
|
| deposit_type |
varchar(1000)
|
utf8_general_ci
|
|
|
| doctor_name |
varchar(1000)
|
utf8_general_ci
|
|
|
| doctor_email |
varchar(1000)
|
utf8_general_ci
|
|
|
| time_delivery |
varchar(100)
|
utf8_general_ci
|
|
|
| hospital_id |
varchar(100)
|
utf8_general_ci
|
|
|
| amount_received |
varchar(100)
|
utf8_general_ci
|
|
|
| vat |
varchar(100)
|
utf8_general_ci
|
|
|
| percent_discount |
varchar(100)
|
utf8_general_ci
|
|
|
| vat_amount_percent |
varchar(100)
|
utf8_general_ci
|
|
|