푸르댕댕

테이블 (6)

Account (Untitled)

  • user_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • username (Field) — NOT NULL
  • email (Field2) — NOT NULL
  • password (Field3) — NOT NULL
  • created_at (Field4) — NOT NULL

Board (Untitled5)

  • article_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Key2) — NOT NULL — 외래 키 → Account.user_id — NOT NULL
  • title (Field) — NOT NULL
  • content (Field2) — NOT NULL
  • created_at (Field3) — NOT NULL

Plant (Untitled2)

  • plant_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • plant_name (Key2) — NOT NULL — 기본 키 — NOT NULL
  • en_name (Field2) — NOT NULL
  • rank (Field3) — NOT NULL
  • image_url (Field4) — NOT NULL

PlantInfo (Untitled3)

  • info_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • species (Field2) — NOT NULL
  • feature (Field) — NOT NULL
  • plant_id (Key2) — NOT NULL — 외래 키 → Plant.plant_id — NOT NULL
  • plant_name (Key22) — NOT NULL — 외래 키 → Plant.plant_name — NOT NULL

PlantLikeRepo (Untitled4)

  • user_id (Key) — NOT NULL — 외래 키 → Account.user_id — NOT NULL
  • plant_id (Key2) — NOT NULL — 외래 키 → Plant.plant_id — NOT NULL
  • plant_name (Key22) — NOT NULL — 외래 키 → Plant.plant_name — NOT NULL
  • created_at (Field) — NOT NULL

Review (Untitled6)

  • article_id (Key) — NOT NULL — 외래 키 → Board.article_id — NOT NULL
  • user_id (Key2) — NOT NULL — 외래 키 → Board.user_id — NOT NULL
  • title (Field) — NOT NULL
  • content (Field2) — NOT NULL
  • created_at (Field3) — NOT NULL