Order system
Tables (4)
User (사용자)
- id (사용자 id) — BIGINT — Primary key — NOT NULL
- name (이름) — varchar(255)
- role (역할) — varchar(255) — NOT NULL
order (주문)
- id (주문 id) — BIGINT — Primary key — NOT NULL
- user_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL
- order_price (주문가격) — BIGINT — NOT NULL
product (상품)
- id (상품 id) — BIGINT — Primary key — NOT NULL
- seller_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL
- product_name (상품이름) — varchar(255) — NOT NULL
- inventory (재고) — varchar(255) — NOT NULL
- price (가격) — BIGINT — NOT NULL
product_order_list (상품주문 리스트)
- id (주문상품 id) — BIGINT — Primary key — NOT NULL
- product_id (상품번호) — BIGINT — Foreign key → product.id — NOT NULL
- order_id (주문번호) — BIGINT — Foreign key → order.user_id — NOT NULL
- quantity (수량) — BIGINT — NOT NULL