id |
int(11) |
|
|
|
|
mrno |
varchar(20) |
latin1_swedish_ci |
|
|
|
ipno |
varchar(50) |
latin1_swedish_ci |
|
|
|
admission_date |
date |
|
|
|
|
nurse_id |
int(15) |
|
|
|
|
nurse_note_no |
int(10) |
|
|
|
|
facility |
varchar(50) |
latin1_swedish_ci |
|
|
|
provider |
varchar(50) |
latin1_swedish_ci |
|
|
|
pcp |
varchar(50) |
latin1_swedish_ci |
|
|
|
admit_status |
varchar(50) |
latin1_swedish_ci |
|
|
|
code_status |
varchar(50) |
latin1_swedish_ci |
|
|
|
visit_status |
varchar(50) |
latin1_swedish_ci |
|
|
|
residence |
varchar(50) |
latin1_swedish_ci |
|
|
|
days_this_stay |
int(10) |
|
|
|
|
estimated_discharge_date |
date |
|
|
|
|
days_in_icu |
int(10) |
|
|
|
|
days_on_antibiotics |
int(10) |
|
|
|
|
days_on_ventilator |
int(10) |
|
|
|
|
cvd_10_yr |
varchar(50) |
latin1_swedish_ci |
|
|
|
stroke_10_yr |
varchar(50) |
latin1_swedish_ci |
|
|
|
note |
text |
latin1_swedish_ci |
|
|
|
created |
datetime |
|
|
|
|
modified |
datetime |
|
|
|
|
created_by |
varchar(11) |
latin1_swedish_ci |
|
|
|
modified_by |
varchar(11) |
latin1_swedish_ci |
|
|
|
eyes_open |
varchar(100) |
latin1_swedish_ci |
|
|
|
eyes_open_score |
varchar(100) |
latin1_swedish_ci |
|
|
|
verbal_response |
varchar(100) |
latin1_swedish_ci |
|
|
|
verbal_response_score |
varchar(100) |
latin1_swedish_ci |
|
|
|
motor_response |
varchar(100) |
latin1_swedish_ci |
|
|
|
motor_response_score |
varchar(100) |
latin1_swedish_ci |
|
|
|
pupil_size |
varchar(100) |
latin1_swedish_ci |
|
|
|
pupil_response |
varchar(100) |
latin1_swedish_ci |
|
|
|
r_pupil_size |
varchar(100) |
latin1_swedish_ci |
|
|
|
r_pupil_response |
varchar(100) |
latin1_swedish_ci |
|
|
|
locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|