OP20251030
Tables (5)
Untitled (Customer)
- Key (id) — int — Primary key — NOT NULL
- Field (FirstName) — nchar(30)
- Field2 (Country) — nchar(30)
- Field — nchar(30)
Untitled (_Order)
- Key (id) — int — Primary key — NOT NULL
- Field (orderdate) — datetime2
- Field (TotalAmount) — int
- Key (CustomerId) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Product)
- Key (id) — int — Primary key — NOT NULL
- Field (ProductName) — nchar(30)
- Field (UnitPrice) — int
Untitled (OrderItem)
- Key (id) — int — Primary key — NOT NULL
- Field (Quantity) — int
- Key (id2) — int — Foreign key → Untitled.Key — NOT NULL
- Key (id3) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Supplier)
- Key (id) — int — Primary key — NOT NULL
- Field (T) — char(13)
- Field