다른 버전 만수무강 erd

테이블 (14)

medication

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • med_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • active_flag — ENUM — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

medication_cycle

  • id — BIGINT — 기본 키 — NOT NULL
  • medication_id — BIGINT — 외래 키 → medication.id — NOT NULL
  • frequency — ENUM — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

medication_record

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • scheduled_time — DATETIME — NOT NULL
  • is_taken — BOOLEAN — NOT NULL
  • medication_id — BIGINT — 외래 키 → medication.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL

medication_time

  • schedule_id — BIGINT — 외래 키 → medication_cycle.id — NOT NULL
  • time — TIME — NOT NULL
  • complete — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

mission

  • id — BIGINT — 기본 키 — NOT NULL
  • context — text — NOT NULL
  • point — BIGINT — NOT NULL

notification

  • id — BIGINT — 기본 키 — NOT NULL
  • notification_type — ENUM — NOT NULL
  • title — TEXT — NOT NULL
  • message — TEXT — NOT NULL
  • scheduled_time — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • is_sent — BOOLEAN — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL

past_workout

  • id — VARCHAR(255) — 기본 키 — NOT NULL
  • workout_name — ENUM — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL

point_list

  • id — BIGINT — 기본 키 — NOT NULL
  • point — INT — NOT NULL
  • title — TEXT — NOT NULL
  • context — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • mission_id — BIGINT — 외래 키 → mission.id — NOT NULL

step_counts

  • id — BIGINT — 기본 키 — NOT NULL
  • date — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • step_count — BIGINT — NOT NULL

user

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(15) — NOT NULL
  • birth_date — DATE — NOT NULL
  • height — FLOAT
  • weight — FLOAT
  • workout_frequency — INT — NOT NULL
  • consent_privacy_policy — BOOLEAN — NOT NULL
  • consent_terms_service — BOOLEAN — NOT NULL
  • consent_date — DATETIME — NOT NULL
  • emergency_contact_phone — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • device_token — TEXT

workout_details

  • id — BIGINT — 기본 키 — NOT NULL
  • step — INT — NOT NULL
  • description — TEXT
  • workout_id — BIGINT — 외래 키 → workout_list.id — NOT NULL

workout_list

  • id — BIGINT — 기본 키 — NOT NULL
  • workout_name — VARCHAR(255)
  • video_link — TEXT — NOT NULL
  • description — TEXT
  • video_name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • category_id — BIGINT — 외래 키 → workout_type.id — NOT NULL

workout_record

  • id — BIGINT — 기본 키 — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • date — DATE — NOT NULL
  • completed_exercises_count — BIGINT
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • id2 — BIGINT — 외래 키 → workout_list.id — NOT NULL

workout_type

  • id — BIGINT — 기본 키 — NOT NULL
  • workout_type — ENUM — NOT NULL