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