ERD2024_01

Tables (5)

Untitled (Customer)

  • Key (id) — int — Primary key — NOT NULL
  • Field (Name) — NameType
  • Field (Country) — NameType

Untitled (Supplier)

  • Key (id) — int — Primary key — NOT NULL
  • Field (CompanyName) — nvarchar(30)
  • Field (zipcode) — char5)
  • Field (Country) — nvarchar(30)
  • Field (city) — nvarchar(30)

Untitled (Product)

  • Key (id) — int — Primary key — NOT NULL
  • Field (ProductName) — nvarchar(30)
  • Key (SupplierId) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (OrderItem)

  • Key (OrderId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (ProductId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (unitePrice) — float
  • Field (quantify) — int

Untitled (_Order)

  • Key (id) — int — Primary key — NOT NULL
  • Field (TotalAmount) — int
  • Key (CustomerId) — NameType — Foreign key → Untitled.Key — NOT NULL