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