실습과제#3

테이블 (3)

my_plant

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → user.id — NOT NULL
  • plant_name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • adopt_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

plant_log

  • id — INT — 기본 키 — NOT NULL
  • my_plant_id — INT — 외래 키 → my_plant.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • watered — BOOLEAN — NOT NULL
  • log_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

user

  • id — INT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL