다른 버전 만수무강 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