플리

okky erd

테이블 (4)

Copy Of User (Product)

  • product_id — int — 기본 키 — NOT NULL
  • Field (user_id) — varchar(255) — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field2 (category) — varchar(255) — NOT NULL
  • Field (price) — int
  • Field (description) — text — NOT NULL
  • location — varchar(255) — NOT NULL
  • Field (state) — varchar(255) — NOT NULL
  • Field (upload_date) — date — NOT NULL
  • Field (views) — int — NOT NULL
  • Field (likes) — int — NOT NULL
  • Field (chats) — int — NOT NULL

Copy Of User2 (Like)

  • user_id — varchar(255) — 기본 키 — NOT NULL
  • Key (product_id) — int — 기본 키 — NOT NULL

Product_Image

  • product_id (image_id) — int — 기본 키 — NOT NULL
  • Field (product_id) — int — NOT NULL
  • location (image_url) — varchar(255) — NOT NULL

User

  • user_id — varchar(255) — 기본 키 — NOT NULL
  • location — varchar(255) — NOT NULL