clothing

Tables (5)

clothing

  • type — INT — Primary key — NOT NULL
  • style — INT — Primary key — NOT NULL
  • price — INT — Primary key — NOT NULL

company_cloth

  • name — nvarchar(50) — Primary key — NOT NULL

customer

  • address — NVARCHAR(50) — Primary key — NOT NULL
  • gender — INT — Primary key — NOT NULL

delivery

  • price — int — Primary key — NOT NULL
  • company — nvarchar(50) — Primary key — NOT NULL

order

  • ordernumber — INT — Primary key — NOT NULL
  • Key — Foreign key → customer.gender — NOT NULL
  • address — NVARCHAR(50) — Foreign key → customer.address — NOT NULL
  • type — INT — Foreign key → clothing.type — NOT NULL
  • style — INT — Foreign key → clothing.style — NOT NULL
  • price — INT — Foreign key → clothing.price — NOT NULL
  • price (price2) — int — Foreign key → delivery.price — NOT NULL
  • company — nvarchar(50) — Foreign key → delivery.company — NOT NULL
  • name — nvarchar(50) — Foreign key → company_cloth.name — NOT NULL