코스트팡

테이블 (3)

Product

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • price (Field2) — bigint
  • stock (Field3) — bigint
  • state (Field4) — int
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

ProductImage

  • id (Key) — bigint — 기본 키 — NOT NULL
  • product_id (FK) — bigint — 외래 키 → Product.id — NOT NULL
  • img_url (Field) — varchar(250)
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp
  • Field4

Sale

  • id (Key) — bigint — 기본 키 — NOT NULL
  • product_id (FK) — bigint — 외래 키 → Product.id — NOT NULL
  • state (Field) — int
  • value (Field2) — bigint
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • Field5