데이터베이스응용
테이블 (15)
CalendarEvent
- id — BIGINT — 기본 키
- user_id — BIGINT — 외래 키 → User.id
- type — ENUM('todo', 'supplement', 'system') — NOT NULL
- title — VARCHAR(255) — NOT NULL
- start_datetime — DATETIME — NOT NULL
- end_datetime — DATETIME
- repeat_cycle — ENUM('none', 'daily', 'weekly', 'monthly')
- linked_supplement_id — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
CustomSupplement
- id — BIGINT — 기본 키
- user_id — BIGINT — 외래 키 → User.id
- name — VARCHAR(255) — NOT NULL
- cycle — ENUM('none', 'daily', 'weekly', 'monthly', 'custom')
- time_of_day — TIME
- note — TEXT
- start_date — DATE
- end_date — DATE
DoctorsNote
- id — INT
- user_id — BIGINT — 외래 키 → User.id
- content — TEXT
- visit_date — DATE
- updated_at — DATETIME
- created_at (createed_at) — DATETIME
Notification
- id — BIGINT — 기본 키
- event_id — BIGINT — 외래 키 → CalendarEvent.id
- notify_time — DATETIME — NOT NULL
- is_sent — BOOLEAN
Nutrient
- id — BIGINT — 기본 키
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- recommended_period — ENUM('prep_basic', 'prep_focus', 'ovulation', 'pregnancy_all')
PartnerShare
- id — BIGINT — 기본 키
- user_id — BIGINT — 외래 키 → User.id
- partner_id — BIGINT — 외래 키 → User.id
- status — ENUM('requested', 'accepted', 'rejected')
PeriodInfo
- user_id — BIGINT — 외래 키 → User.id
- last_period — DATE
- period_start — DATE
- updated_at — DATETIME
PregnancyInfo
- user_id — BIGINT — 외래 키 → User.id
- pregnancy_start — DATE
- due_date — DATE
- ovulation_week_start — DATE
- created_at — DATETIME
- updated_at — DATETIME
Supplement
- id — BIGINT — 기본 키
- name — VARCHAR(255) — NOT NULL
- brand — VARCHAR(255)
- dosage_info — TEXT
- caution — TEXT
- default_cycle — ENUM('none', 'daily', 'weekly', 'monthly')
SupplementNutrient
- supplement_id — BIGINT — 외래 키 → Supplement.id
- nutrient_id — BIGINT — 외래 키 → Nutrient.id
Tip
- id — INT — 기본 키
- content — TEXT
User
- id — BIGINT — 기본 키
- email — VARCHAR(255)
- provider — ENUM('google', 'kakao', 'local') — NOT NULL
- social_id — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- is_pregnant — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- gender — ENUM('male','female')
UserProfile
- user_id — BIGINT — 외래 키 → User.id
- height — INT
- updated_at — DATETIME
- intial_weight (initial_weight) — FLOAT
- current_weight — FLOAT
UserSetting
- user_id — BIGINT — 외래 키 → User.id
- notification_enabled — BOOLEAN
- default_notify_time — TIME
- language — VARCHAR(20)
UserSupplement
- id — BIGINT — 기본 키
- cycle — ENUM('none', 'daily', 'weekly', 'monthly', 'custom')
- time_of_day — TIME
- start_date — DATE
- end_date — DATE
- user_id — BIGINT — 외래 키 → User.id
- supplement_id — BIGINT — 외래 키 → Supplement.id