어떡하죠_coupang_ERD

테이블 (3)

가게 (STORE)

  • store_id — INT — 기본 키 — NOT NULL
  • store_name — VARCHAR(50)
  • store_phone — VARCHAR(20)
  • store_address — VARCHAR(80)
  • store_CEO_name — VARCHAR(10)
  • store_introduction — VARCHAR(500)
  • store_rocket — BOOL
  • store_delivery_time — VARCHAR(20)

리뷰 (REVIEW)

  • review_id — INT — 기본 키 — NOT NULL
  • review_contents — VARCHAR(500)
  • review_rating — DOUBLE
  • store_id (stord_id) — INT
  • product_id — INT
  • review_img — txt
  • review_created — datetime
  • review_status — BOOL

제품 (PRODUCT)

  • product_id — INT — 기본 키 — NOT NULL
  • product_name — VARCHAR(50)
  • product_price — INT
  • product_introduction — VARCHAR(500)
  • product_remain — INT
  • product_catagory — VARCHAR(20)