2025.10.30

Tables (5)

Untitled (customer)

  • Key (id) — int — Primary key — NOT NULL
  • Field (lastname) — nchar(30)
  • Field (firstname) — nchar(30)
  • Field (country) — nchar(30)

Untitled (product)

  • Key (id) — int — Primary key — NOT NULL
  • Field (prpductname) — char(30)
  • Field (uniprice) — int

Untitled (orderitem)

  • Key (id) — int — Primary key — NOT NULL
  • Field2 (quantity) — int
  • Key (productid) — int — Foreign key → Untitled2.Key — NOT NULL
  • Key (orderid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (supplier)

  • Key (id) — int — Primary key — NOT NULL

Untitled2 (_order)

  • Key (id) — int — Primary key — NOT NULL
  • Field (orderdate) — datetime2
  • Field (totalamount) — int
  • Key (customerid) — int — Foreign key → Untitled.Key — NOT NULL