재고관리
테이블 (6)
member
- user_no — VARCHAR(255) — 기본 키 — NOT NULL
- name — VARCHAR(30) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
order_item
- order_item_no — VARCHAR(255) — 기본 키 — NOT NULL
- quantity — BIGINT — NOT NULL
- unit_price — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- order_no — VARCHAR(255) — 외래 키 → orders.order_no — NOT NULL
- product_no — VARCHAR(255) — 외래 키 → product.product_no — NOT NULL
orders
- order_no — VARCHAR(255) — 기본 키 — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- user_no — VARCHAR(255) — 외래 키 → member.user_no — NOT NULL
product
- product_no — VARCHAR(255) — 기본 키 — NOT NULL
- name — VARCHAR(200) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
product_stock
- product_stock_no — VARCHAR(255) — 기본 키 — NOT NULL
- total_quantity — BIGINT — NOT NULL
- available_quantity — BIGINT — NOT NULL
- reserved_quantity — BIGINT — NOT NULL
- sold_quantity — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- product_no — VARCHAR(255) — 외래 키 → product.product_no — NOT NULL
stock_reservation
- stock_reserve_no — VARCHAR(255) — 기본 키 — NOT NULL
- status — VARCHAR(50) — NOT NULL
- reserved_quantity — BIGINT — NOT NULL
- reserved_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- confirmed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- order_no — VARCHAR(255) — 외래 키 → orders.order_no — NOT NULL
- product_no — VARCHAR(255) — 외래 키 → product.product_no — NOT NULL