하루싹2

테이블 (9)

DiaryFlowerRecommend

  • recommend_flower_id — BIGINT
  • diary_id — BIGINT — NOT NULL
  • flower_id — BIGINT — NOT NULL

DiaryRoutineRecommend

  • recommend_routine_id — BIGINT
  • diary_id — BIGINT — NOT NULL
  • routine_id — BIGINT — NOT NULL

EmotionDiary

  • diary_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

Flower

  • flower_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • meaning — VARCHAR(255)
  • image_url — TEXT

HarvestRecord

  • harvest_id — BIGINT
  • planted_flower_id — BIGINT — NOT NULL
  • diary_id — BIGINT — NOT NULL
  • harvested_at — TIMESTAMP
  • notes — TEXT

PlantedFlower

  • planted_flower_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • diary_id — BIGINT — NOT NULL
  • flower_id — BIGINT — NOT NULL
  • status — ENUM('growing', 'harvested')
  • planted_at — TIMESTAMP

Routine

  • routine_id — BIGINT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category — VARCHAR(50)

RoutineExecution

  • execution_id — BIGINT
  • planted_flower_id — BIGINT — NOT NULL
  • routine_id — BIGINT — NOT NULL
  • executed_at — TIMESTAMP

User

  • user_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP