TheGoods

테이블 (15)

Product (상품)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • category_id (Key2) — bigint(20) — 외래 키 → category.id — NOT NULL
  • seller_id (Key3) — bigint(20) — 외래 키 → seller.id — NOT NULL
  • name (Field) — varchar(100)
  • content (Field3) — text
  • order_count (Field10) — int
  • stock (Field9) — int
  • pirce (Field2) — int
  • delivery_fee (Field11) — int
  • status (Field8) — varchar(15)
  • views (Field6) — int
  • rating (Field7) — float
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

Review (리뷰)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • member_id (Key3) — bigint(20) — 외래 키 → member.id — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — text
  • ratings (Field5) — float
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

cart(장바구니) (Untitled)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • member_id (Key3) — bigint(20) — 외래 키 → member.id — NOT NULL
  • count (Field3) — int
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

category (카테고리)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • name (Field) — varchar(50)
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

dibs (Untitled3)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • member_id (Key3) — bigint(20) — 외래 키 → member.id — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

inqury (Untitled4)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL

member (멤버)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL

option (Untitled2)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • content (Field) — text
  • price (Field2) — int
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

order (주문)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • member_id (Key3) — bigint(20) — 외래 키 → member.id — NOT NULL
  • order_detail (Field4) — int
  • delivery_location (Field3) — text
  • status (Field5) — int
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

product_image (상품 이미지)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • image_url (Field) — text
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

review_image (리뷰 이미지)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • review_id (Key2) — bigint(20) — 외래 키 → Review.id — NOT NULL
  • image_url (Field) — text
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

search (Untitled6)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

seller (판매자)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL

tag (태그)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • name (Field) — varchar(20)
  • search_count (Field4) — int
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

terms (Untitled5)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint(20) — 외래 키 → Product.id — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — text
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime