대략?
테이블 (8)
Category (Untitled5)
- category_id (Key) — INT — 기본 키 — NOT NULL
- category_name (Field) — VARCHAR(50)
Inventory (Untitled6)
- inventory_id (Key2) — INT — 기본 키 — NOT NULL
- quantity (Field) — INT
- warehouse_id (Key) — INT — 외래 키 → Warehouse.warehouse_id — NOT NULL
- product_id (Key3) — INT — 외래 키 → Product.product_id — NOT NULL
- movement_id (Key22) — INT — 외래 키 → Warehouse.movement_id — NOT NULL
Member (Untitled)
- member_id (Key) — INT — 기본 키 — NOT NULL
- name — VARCHAR(50)
- email — VARCHAR(100)
- phone — VARCHAR(20)
OrderDatail (Untitled3)
- order_detail_id (Key) — INT — 기본 키 — NOT NULL
- order_id (Key2) — INT — 외래 키 → OrderTable.order_id — NOT NULL
- product_id (Key3) — INT — 외래 키 → Product.product_id — NOT NULL
- quantity (Field) — INT
- price (Field2) — DECIMAL(10,2)
OrderTable (Untitled2)
- order_id (Key) — INT — 기본 키 — NOT NULL
- order_date (Field) — DATE
- total_amount — DECIMAL(10,2)
- status (Field2) — VARCHAR(20)
- member_id (Key2) — INT — 외래 키 → Member.member_id — NOT NULL
Product (Untitled4)
- product_id (Key) — INT — 기본 키 — NOT NULL
- product_name (Field) — VARCHAR(100)
- price (Field2) — DECIMAL(10,2)
- size (Field3) — VARCHAR(20)
- color (Field4) — VARCHAR(20)
- category_id (Key3) — INT — 외래 키 → Category.category_id — NOT NULL
StockMovement (Untitled8)
- movement_id (Key) — INT — 기본 키 — NOT NULL
- quantity (Field) — INT
- movement|_date (Field2) — DATETIME
Warehouse (Untitled7)
- warehouse_id (Key) — INT — 기본 키 — NOT NULL
- movement_id (Key2) — INT — 외래 키 → StockMovement.movement_id — NOT NULL
- location (Field) — VARCHAR(100)
- capacity (Field2) — INT