orderprossing 2024

Tables (3)

Untitled (Customer)

  • Key (id) — int — Primary key — NOT NULL
  • Field (LastName) — nchar(30)
  • Field (FirstName) — nchar(30)
  • Field (country) — nchar(30)
  • Field (city) — nchar(30)

Untitled (_order)

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

Untitled

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