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