| id |
int(11) |
|
|
|
|---|
|
| ipno |
varchar(12) |
latin1_swedish_ci |
|
|
|---|
|
| mrno |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| posting_date |
datetime |
|
|
|
|---|
|
| name |
varchar(100) |
latin1_swedish_ci |
|
|
|---|
|
| gender |
varchar(5) |
latin1_swedish_ci |
|
|
|---|
|
| age |
int(11) |
|
|
|
|---|
|
| ward |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| room |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| bed |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| doctor_code |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| doc_name |
varchar(100) |
latin1_swedish_ci |
|
|
|---|
|
| voucher_no |
varchar(12) |
latin1_swedish_ci |
|
|
|---|
|
| charge |
int(11) |
|
|
|
|---|
|
| shift |
char(2) |
latin1_swedish_ci |
|
|
|---|
|
| orgi_cost |
float(10,2) |
|
|
|
|---|
|
| package_id |
int(11) |
|
|
|
|---|
|
| p_pack_qty |
float(10,2) |
|
|
|
|---|
|
| p_pack_amt |
float(10,2) |
|
|
|
|---|
|
| p_advance |
float(10,2) |
|
|
|
|---|
|
| remark |
text |
latin1_swedish_ci |
|
|
|---|
|
| visit_type |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| created |
datetime |
|
|
|
|---|
|
| created_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| modified |
datetime |
|
|
|
|---|
|
| modified_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| finance_status |
int(1) |
|
|
|
|---|
|
| procedure_payment |
varchar(25) |
latin1_swedish_ci |
|
|
|---|
|
| icu_charge |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
