| id |
int(11) |
|
|
|
|---|
|
| assessment_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| date |
date |
|
|
|
|---|
|
| mrno |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| patient_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| name |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| age |
int(5) |
|
|
|
|---|
|
| gender |
varchar(2) |
latin1_swedish_ci |
|
|
|---|
|
| bed_id |
int(11) |
|
|
|
|---|
|
| ward_id |
int(11) |
|
|
|
|---|
|
| room_id |
int(11) |
|
|
|
|---|
|
| assessment_date |
date |
|
|
|
|---|
|
| assessment_time |
varchar(10) |
latin1_swedish_ci |
|
|
|---|
|
| diagnosis |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| diagnosis_remark |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| doa |
date |
|
|
|
|---|
|
| height |
float(10,2) |
|
|
|
|---|
|
| weight |
float(10,2) |
|
|
|
|---|
|
| bmi |
float(10,2) |
|
|
|
|---|
|
| edema |
varchar(2) |
latin1_swedish_ci |
|
|
|---|
|
| food_allergy_status |
int(1) |
|
|
|
|---|
|
| food_allergy |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| special_likes_status |
int(1) |
|
|
|
|---|
|
| special_likes |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| special_dislikes_status |
int(1) |
|
|
|
|---|
|
| special_dislikes |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| religion_status |
int(1) |
|
|
|
|---|
|
| religion |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| nutrition_date |
date |
|
|
|
|---|
|
| diet_type |
int(11) |
|
|
|
|---|
|
| sub_diet_type |
int(11) |
|
|
|
|---|
|
| calorie |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| dietician |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| created_date |
timestamp |
|
|
|
|---|
|
| created_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| modified_date |
datetime |
|
|
|
|---|
|
| modified_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
