Column |
Internal relation An internal relation is not necessary when a corresponding FOREIGN KEY relation exists. |
---|
id
|
|
assessment_no
|
|
date
|
|
mrno
|
|
patient_no
|
|
name
|
|
age
|
|
gender
|
|
bed_id
|
|
ward_id
|
|
room_id
|
|
assessment_date
|
|
assessment_time
|
|
diagnosis
|
|
diagnosis_remark
|
|
doa
|
|
height
|
|
weight
|
|
bmi
|
|
edema
|
|
food_allergy_status
|
|
food_allergy
|
|
special_likes_status
|
|
special_likes
|
|
special_dislikes_status
|
|
special_dislikes
|
|
religion_status
|
|
religion
|
|
nutrition_date
|
|
diet_type
|
|
sub_diet_type
|
|
calorie
|
|
dietician
|
|
created_date
|
|
created_by
|
|
modified_date
|
|
modified_by
|
|
locationname
|
|