테스트DB_0228

테이블 (4)

medication_schedule

  • schedule_id — INT
  • relationship_id — INT — NOT NULL
  • medication_date — DATE — NOT NULL
  • meal_time — ENUM('식전', '식후') — NOT NULL
  • medication_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

medication_time

  • time_id — INT
  • schedule_id — INT — NOT NULL
  • time_slot — ENUM( '아침', '점심', '저녁', '취침 전' ) — NOT NULL
  • created_at — TIMESTAMP

user

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • role — ENUM('guardian', 'patient') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_relationship

  • relationship_id — INT
  • guardian_id — INT — NOT NULL
  • patient_id — INT — NOT NULL
  • relationship_type — ENUM( '자녀', '손자녀', '배우자', '어머니', '아버지', '조부모', '친구', '기타' ) — NOT NULL
  • created_at — TIMESTAMP