Planery_수정
테이블 (10)
diaries
- diary_id — VARCHAR(10) — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- date — DATE
- title — TEXT
- content — TEXT
- is_public — BOOLEAN
- image_url — TEXT
- created_at — DATETIME
diary_comments
- comment_id — VARCHAR(10) — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- diary_id — VARCHAR(10) — 외래 키 → diaries.diary_id — NOT NULL
- content — TEXT
- created_at — DATETIME
emotion
- emotion_id — VARCHAR(10) — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- date — DATE
- emotion_icon — VARCHAR(10)
- memo — TEXT
follows
- follow_id — VARCHAR(10) — 기본 키 — NOT NULL
- follower_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- followee_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- created_at — DATETIME
guestbook
- entry_id — VARCHAR(10) — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- content — TEXT
- created_at — DATETIME
heatmap
- date — DATE — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- heatmap_id — VARCHAR(10) — NOT NULL
- grass_color — VARCHAR(20)
- updated_at — DATETIME
member
- member_id — VARCHAR(36) — 기본 키 — NOT NULL
- password — VARCHAR(255)
- email — VARCHAR(100)
- nickname — VARCHAR(50)
- created_at — DATETIME
- profile_img — TEXT
- theme — VARCHAR(20)
routine
- routine_id — VARCHAR(10) — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- title — VARCHAR(100)
- repeat_days — VARCHAR(50)
- category — VARCHAR(50)
- order_index — INT — NOT NULL
- created_at — DATETIME
routine_logs
- log_id — VARCHAR(10) — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- routine_id — VARCHAR(10) — 외래 키 → routine.routine_id — NOT NULL
- date — DATE
- completed — BOOLEAN
task
- task_id — VARCHAR(10) — 기본 키 — NOT NULL
- member_id — VARCHAR(36) — 외래 키 → member.member_id — NOT NULL
- title — VARCHAR(100)
- description — TEXT
- date — DATE
- time — TIME
- color — VARCHAR(20)
- icon — VARCHAR(50)
- is_completed — BOOLEAN
- created_at — DATETIME