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