어떡하죠_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)