| id |
int(100)
|
|
|
|
| category |
varchar(100)
|
utf8_general_ci
|
|
|
| patient |
varchar(100)
|
utf8_general_ci
|
|
|
| doctor |
varchar(100)
|
utf8_general_ci
|
|
|
| date |
varchar(100)
|
utf8_general_ci
|
|
|
| category_name |
varchar(1000)
|
utf8_general_ci
|
|
|
| report |
longtext
|
utf8_general_ci
|
|
|
| status |
varchar(100)
|
utf8_general_ci
|
|
|
| user |
varchar(100)
|
utf8_general_ci
|
|
|
| patient_name |
varchar(100)
|
utf8_general_ci
|
|
|
| patient_phone |
varchar(100)
|
utf8_general_ci
|
|
|
| patient_address |
varchar(100)
|
utf8_general_ci
|
|
|
| doctor_name |
varchar(100)
|
utf8_general_ci
|
|
|
| date_string |
varchar(100)
|
utf8_general_ci
|
|
|
| hospital_id |
varchar(100)
|
utf8_general_ci
|
|
|
| invoice_id |
varchar(1000)
|
utf8_general_ci
|
|
|
| category_id |
varchar(1000)
|
utf8_general_ci
|
|
|
| test_status |
varchar(500)
|
utf8_general_ci
|
|
|
| test_status_date |
varchar(500)
|
utf8_general_ci
|
|
|
| delivery_status |
varchar(500)
|
utf8_general_ci
|
|
|
| delivery_status_date |
varchar(500)
|
utf8_general_ci
|
|
|
| receiver_name |
varchar(500)
|
utf8_general_ci
|
|
|
| updated_on |
varchar(500)
|
utf8_general_ci
|
|
|
| reported_by |
varchar(500)
|
utf8_general_ci
|
|
|
| done_by |
varchar(500)
|
utf8_general_ci
|
|
|
| signed_by |
varchar(100)
|
utf8_general_ci
|
|
|
| alloted_bed_id |
varchar(100)
|
utf8_general_ci
|
|
|
| bed_diagnostic_id |
varchar(100)
|
utf8_general_ci
|
|
|