| id | int(11) |
|
|
|
| dpno | varchar(20) |
|
|
|
| mrno | varchar(20) |
|
|
|
| ipno | varchar(20) |
|
|
|
| patient_name | varchar(100) |
|
|
|
| age | int(11) |
|
|
|
| sex | varchar(20) |
|
|
|
| ward | varchar(20) |
|
|
|
| room | varchar(20) |
|
|
|
| bed_no | varchar(20) |
|
|
|
| ward_transfer_date | date |
|
|
|
| whom_to_info | varchar(255) |
|
|
|
| cdr_id | varchar(20) |
|
|
|
| cdr_name | varchar(45) |
|
|
|
| transfer_remark | varchar(255) |
|
|
|
| tdr_id | varchar(20) |
|
|
|
| tdr_name | varchar(45) |
|
|
|
| treatment_at_time_of_death_p | varchar(45) |
|
|
|
| remark | varchar(255) |
|
|
|
| death_posting_reason | varchar(255) |
|
|
|
| other_reason_one | varchar(255) |
|
|
|
| other_reason_two | varchar(255) |
|
|
|
| cause_of_injury | varchar(100) |
|
|
|
| cause_of_death_underlying | varchar(100) |
|
|
|
| dp_certificate_issue_to | varchar(100) |
|
|
|
| dp_certificate_issue_date | date |
|
|
|
| body_recieved_by | varchar(100) |
|
|
|
| body_recieved_date | date |
|
|
|
| dead_body_destination | varchar(100) |
|
|
|
| date_police_intimated | date |
|
|
|
| policeman_name | varchar(100) |
|
|
|
| policeid_no | varchar(20) |
|
|
|
| body_send_to | varchar(20) |
|
|
|
| police_instructions | varchar(100) |
|
|
|
| weather_pragnant | varchar(10) |
|
|
|
| weather_delivered | varchar(10) |
|
|
|
| police_case | varchar(10) |
|
|
|
| acc_date | date |
|
|
|
| plc_of_acc | varchar(100) |
|
|
|
| nat_of_injury | varchar(100) |
|
|
|
| cause | varchar(100) |
|
|
|
| acc_pol_station | varchar(100) |
|
|
|
| doc_on_duty | varchar(100) |
|
|
|
| date_of_inform | date |
|
|
|
| expiry_date | datetime |
|
|
|
| created | datetime |
|
|
|
| created_by | varchar(20) |
|
|
|
| modified | datetime |
|
|
|
| modified_by | varchar(20) |
|
|
|
| locationname | varchar(20) |
|
|
|
