하루싹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