NBE5-6-1-Team04 Public 1차 프로젝트 커피 ERD
테이블 (9)
cart
- cart_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → user.user_id — NOT NULL
cart_item
- cart_item_id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → product.product_id — NOT NULL
- cart_id — bigint — 외래 키 → cart.cart_id — NOT NULL
- product_count — int
delivery
- delivery_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → order.order_id — NOT NULL
- delivery_status — varchart(50)
- delivery_expected_date — timestamp
order
- order_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → user.user_id — NOT NULL
- order_count — int — NOT NULL
- total_price — int — NOT NULL
- created_at — timestamp — NOT NULL
- order_status — varchar(50)
- order_address — varchar(50)
order_item
- order_item_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → order.order_id — NOT NULL
- product_id — bigint — 외래 키 → product.product_id — NOT NULL
- order_count — int — NOT NULL
payment
- payment_id — bigint — 기본 키 — NOT NULL
- order_id — bigint — 외래 키 → order.order_id — NOT NULL
- payment_price — int
- create_at — timestamp
product
- product_id — bigint — 기본 키 — NOT NULL
- product_name — varchar(100) — NOT NULL — GIN IDX (TRIGRAM)
- price — int — NOT NULL
- description — varchar(100)
- stock — int — NOT NULL — GIN IDX
- created_at — timestamp — NOT NULL
product_image
- product_image_id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → product.product_id — NOT NULL
- type — varchar(50)
- image_name (name) — varchar(50)
user
- user_id — varchar(50) — 기본 키 — NOT NULL
- password — varchar(100)
- name — varchar(50)
- address — varchar(300)
- email — varchar(100) — NOT NULL
- role — varchar(50) — NOT NULL — GIN IDX
- created_at — timestamp — NOT NULL