id |
int(11) |
|
|
|
|
credit_no |
varchar(20) |
latin1_swedish_ci |
|
|
|
bill_date |
date |
|
|
|
|
ipno |
varchar(45) |
latin1_swedish_ci |
|
|
|
name |
varchar(45) |
latin1_swedish_ci |
|
|
|
age |
int(11) |
|
|
|
|
bill_no |
varchar(20) |
latin1_swedish_ci |
|
|
|
ward_code |
varchar(20) |
latin1_swedish_ci |
|
|
|
room_code |
varchar(20) |
latin1_swedish_ci |
|
|
|
bed_no |
varchar(20) |
latin1_swedish_ci |
|
|
|
sex |
varchar(20) |
latin1_swedish_ci |
|
|
|
narration |
varchar(100) |
latin1_swedish_ci |
|
|
|
narration_desc |
text |
latin1_swedish_ci |
|
|
|
ac_balance |
double(17,2) |
|
|
|
|
payment_type |
varchar(20) |
latin1_swedish_ci |
|
|
|
voucher_amount |
double(17,2) |
|
|
|
|
created |
datetime |
|
|
|
|
created_by |
varchar(20) |
latin1_swedish_ci |
|
|
|
modified |
datetime |
|
|
|
|
modified_by |
varchar(20) |
latin1_swedish_ci |
|
|
|
locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|