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