id |
int(11) |
|
|
|
|
drugorder_id |
int(11) |
|
|
|
|
item_type |
enum('N', 'M', 'F') |
latin1_swedish_ci |
|
|
|
item_code |
varchar(100) |
latin1_swedish_ci |
|
|
|
item_name |
varchar(100) |
latin1_swedish_ci |
|
|
|
form |
varchar(50) |
latin1_swedish_ci |
|
|
|
frequency |
varchar(100) |
latin1_swedish_ci |
|
|
|
days |
int(11) |
|
|
|
|
qty |
float(12,2) |
|
|
|
|
duration |
int(11) |
|
|
|
|
start_date |
date |
|
|
|
|
end_date |
date |
|
|
|
|
pres_qty |
float(12,2) |
|
|
|
|
issue_unit |
varchar(50) |
latin1_swedish_ci |
|
|
|
route |
varchar(100) |
latin1_swedish_ci |
|
|
|
remarks |
varchar(100) |
latin1_swedish_ci |
|
|
|
created_date |
datetime |
|
|
|
|
created_by |
varchar(10) |
latin1_swedish_ci |
|
|
|
modified_date |
datetime |
|
|
|
|
modified_by |
varchar(10) |
latin1_swedish_ci |
|
|
|
time_advoice |
varchar(22) |
latin1_swedish_ci |
|
|
|
timeadviser |
varchar(20) |
latin1_swedish_ci |
|
|
|
locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|