pamajon
Tables (5)
BRAND (회사 분류)
- Key (brand_code) — NUMBER — Primary key — NOT NULL
- Field (brand_name) — VARCHAR2(255)
CATEGORY (상품 분류)
- Key (category_code) — NUMBER — Primary key — NOT NULL
- Field (category_name) — VARCHAR2(255)
PRODUCT (상품)
- Key (product_id) — NUMBER — Primary key — NOT NULL — SEQUENCE
- Key (category_code) — NUMBER — Foreign key → CATEGORY.Key — NOT NULL
- Key (brand_code) — NUMBER — Foreign key → BRAND.Key — NOT NULL
- Field (price) — NUMBER
- Field (product_name) — VARCHAR2(300)
STOCK (재고)
- Key (store_id) — NUMBER — Foreign key → STORE.Key — NOT NULL — SEQUENCE
- Key (product_id) — NUMBER — Foreign key → PRODUCT.Key — NOT NULL — SEQUENCE
- Key (category_code2) — NUMBER — Foreign key → PRODUCT.Key — NOT NULL
- Key (brand_code2) — NUMBER — Foreign key → PRODUCT.Key — NOT NULL
- Field (quantity) — NUMBER
STORE (점포)
- Key (store_id) — NUMBER — Primary key — NOT NULL — SEQUENCE
- Field (store_name) — VARCHAR2(255)
- Field2 (phone) — VARCHAR2(25)
- Field3 (address) — VARCHAR2(300)