Kidney Care
Tables (12)
Untitled2 (voiding_detail)
- Key (voiding_detail_id) — INT — Primary key — NOT NULL
- voiding_diary_id (voiding_id) — INT — Foreign key → voiding_diary.voiding_diary_id — NOT NULL
- Field (voiding_time) — VARCHAR(255)
- Field (voiding_volume) — FLOAT
- Field (water_intake) — FLOAT
- Field (urgency_level) — INT
blood
- blood_pressure_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE
- time_of_day — INT
- systolic — FLOAT
- diastolic — FLOAT
doctor
- Key (doctor_id) — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- Field (patient_id) — INT
- Field (assignment_date) — DATE
- Field (status) — VARCHAR(20)
feedback
- feedback_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- doctor_id — INT
- date — DATE
- content — TEXT
goal
- goal_id — INT — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE
- score — FLOAT
- Field
meal
- meal_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE
meal_detail
- Key (meal_detail_id) — INT — Primary key — NOT NULL
- meal_id — INT — Foreign key → meal.meal_id — NOT NULL
- Field (meal_name) — VARCHAR(50)
- Field (time_of_day) — INT
- Field (photo_url) — VARCHAR(255)
score (goal_detail)
- user_id (goal_detail_id) — INT — Primary key — NOT NULL
- goal_id — INT — Foreign key → goal.goal_id — NOT NULL
- date (goal_description) — VARCHAR(255)
- score (archievement_status) — BOOLEAN
- Key — Foreign key → goal.Key — NOT NULL
urine
- urine_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE
- bil — FLOAT
- glu — FLOAT
- ket — FLOAT
- no2 — FLOAT
- ph — FLOAT
- prot — FLOAT
- rbc — FLOAT
- sg — FLOAT
- uro — FLOAT
- wbc — FLOAT
user
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- email — VARCHAR(255)
- password — VARCHAR(255)
- birthday — DATE
- phone_number — VARCHAR(20)
- gender — VARCHAR(1)
- doctor (user_type) — VARCHAR(10)
voiding_diary (voiding)
- voiding_diary_id (voiding_id) — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE
- morning_weight — FLOAT
- evening_weight — FLOAT
weight
- weight_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- date — DATE
- weight — FLOAT