210330
Tables (6)
Product Branch (product_branch)
- Product Id (product_id) — INT(11) — Foreign key → product.Product Id — NOT NULL
- Branch Id (branch_id) — INT(11) — Foreign key → branch.Branch Id — NOT NULL
Product Warehouse (Untitled)
- Product Id (product_id) — INT(11) — Foreign key → product.Product Id — NOT NULL
- Warehouse Id (warehouse_id) — INT(11) — Foreign key → warehouse.Warehouse Id — NOT NULL
branch (지점)
- Branch Id (branch_id) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(50)
- Phone (phone) — VARCHAR(20)
- Location (location) — VARCHAR(50)
category (상품 분류)
- Category Id (category_id) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(50)
product (상품)
- Product Id (product_id) — INT(11) — Primary key — NOT NULL
- Price (price) — INT
- Stock (stock) — INT
- Name (name) — VARCHAR(50)
- Category Id (category_id) — INT(11) — Foreign key → category.Category Id — NOT NULL
warehouse (물류 창고)
- Warehouse Id (warehouse_id) — INT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(50)
- Phone (phone) — VARCHAR(20)
- Location (location) — VARCHAR(50)