SPA
Tables (3)
LOCATION
- product_number — VARCHAR2(20) — Primary key — NOT NULL
- floor_location — VARCHAR2(10)
- stock_location — VARCHAR2(10)
- product_number (product_number2) — VARCHAR2(20) — Foreign key → PRODUCT.product_number — NOT NULL
OTHERSHOP
- shop_name — VARCHAR2(20)
- product_color — VARCHAR2(20)
- product_size — NUMBER(3)
- quantity — NUMBER(5) DEFAULT 0
- product_number — VARCHAR2(20) — Foreign key → PRODUCT.product_number — NOT NULL
PRODUCT
- product_number — VARCHAR2(20) — Primary key — NOT NULL
- product_name — VARCHAR2(50)
- product_size — NUMBER(3)
- color — VARCHAR2(20)
- quantity — NUMBER(5) DEFAULT 0