id | int(11) |
|
|
|
nn_no | varchar(20) |
|
|
|
data_enter_time | time |
|
|
|
op_no | varchar(20) |
|
|
|
op_desc | varchar(50) |
|
|
|
ipno | varchar(20) |
|
|
|
name | varchar(45) |
|
|
|
first_shift_time | time |
|
|
|
nurse1 | varchar(20) |
|
|
|
nurse1_desc | varchar(50) |
|
|
|
nurse2 | varchar(20) |
|
|
|
nurse2_desc | varchar(50) |
|
|
|
nurse3 | varchar(20) |
|
|
|
nurse3_desc | varchar(50) |
|
|
|
nurse4 | varchar(20) |
|
|
|
nurse4_desc | varchar(50) |
|
|
|
nurse5 | varchar(20) |
|
|
|
nurse5_desc | varchar(50) |
|
|
|
nurse6 | varchar(20) |
|
|
|
nurse6_desc | varchar(50) |
|
|
|
second_shift_time | time |
|
|
|
nurse7 | varchar(20) |
|
|
|
nurse7_desc | varchar(50) |
|
|
|
nurse8 | varchar(20) |
|
|
|
nurse8_desc | varchar(50) |
|
|
|
nurse9 | varchar(20) |
|
|
|
nurse9_desc | varchar(50) |
|
|
|
nurse10 | varchar(20) |
|
|
|
nurse10_desc | varchar(50) |
|
|
|
nurse11 | varchar(20) |
|
|
|
nurse11_desc | varchar(50) |
|
|
|
nurse12 | varchar(20) |
|
|
|
nurse12_desc | varchar(50) |
|
|
|
inmt_cnt_chkd | varchar(20) |
|
|
|
nd_cnt_chkd | varchar(20) |
|
|
|
authorization | varchar(20) |
|
|
|
authorization_desc | varchar(50) |
|
|
|
witness | varchar(20) |
|
|
|
witness_desc | varchar(50) |
|
|
|
remark | text |
|
|
|
created_date | timestamp |
|
|
CURRENT_TIMESTAMP
|
created_by | varchar(20) |
|
|
|
modified_date | datetime |
|
|
|
modified_by | varchar(20) |
|
|
|
locationname | varchar(20) |
|
|
|