Store
테이블 (3)
상품 (product)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- name (Field) — CHARACTER VARYING(255)
- quantity (Field2) — BIGINT
- price (Field3) — BIGINT
주문 (order)
- id (key) — BIGINT — 기본 키 — NOT NULL
- orderer (Field) — CHARACTER VARYING(50)
- ordererAddress (Field2) — CHARACTER VARYING(255)
- orderDate (Field3) — TIMESTAMP(6)
- totalPrice (Field4) — BIGINT
- version (Field5) — BIGINT
주문 상품 (order_product)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- orderId (key2) — BIGINT — 외래 키 → 주문.id — NOT NULL
- productId (key3) — BIGINT — 외래 키 → 상품.id — NOT NULL
- productName (Field) — CHARACTER VARYING(255)
- quantity (Field2) — BIGINT
- price (Field3) — BIGINT