ongi

Tables (5)

emergency_notification (긴급 알림)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • activation (Field) — BOOL
  • alert_count (Field2) — BIGINT
  • id (Key2) — BIGINT — Foreign key → user.id — NOT NULL

meal_schedule (식사 일정)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • meal_title (Field) — VARCHAR(15)
  • meal_time (Field2) — DATETIME
  • meal_status (Field3) — BOOL
  • id (Key2) — BIGINT — Foreign key → user.id — NOT NULL

medication_schdule (약 일정)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • medication_title (Field) — VARCHAR(15)
  • medication_time (Field2) — DATETIME
  • medication_status (Field3) — BOOL
  • id (Key2) — BIGINT — Foreign key → user.id — NOT NULL

user (사용자)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • role (보호자 관계) — ENUM
  • name (노인 이름) — VARCHAR(15)
  • phone_number (보호자 번호) — VARCHAR(11)
  • age (Field5) — INT
  • alert_maximum (Field6) — INT
  • Field

voice_file (음성 파일)