Grids&Circles
Tables (3)
Order (주문)
- id (아이디) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(100)
- address (배송지주소) — VARCHAR(100)
- postcode (우편번호) — INT
- createdat (주문등록날짜) — datetime
- updatedat (상품수정날짜) — datetime
- orderstatus (주문 처리 상태) — enum
OrderItem (주문 상품)
- id (아이디) — BIGINT — Primary key — NOT NULL
- product_id (상품정보) — BIGINT — Foreign key → Product.id — NOT NULL
- order_id (주문정보) — BIGINT — Foreign key → Order.id — NOT NULL
- category (카테고리) — enum
- price (가격) — INT
- quantity (수량) — INT
Product (상품)
- id (아이디) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(30)
- category (카테고리) — enum
- price (가격) — INT
- description (설명) — VARCHAR(100)
- imageurl (이미지) — VARCHAR(300)
- createdat (상품등록날짜) — datetime
- updatedat (상품수정날짜) — datetime