데이터베이스응용

테이블 (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