aa
Tables (5)
Customer
- id — int — Primary key — NOT NULL
- FirstName — nvarchar(30)
- LastName — nvarchar(30)
- phone — varchar(20)
- city — nvarchar(30)
- country — nvarchar(30)
Orderitem
- id — int — Primary key — NOT NULL
- unitPrice — decimal
- quantity — int
- orderid — iint — NOT NULL
- productid — int — NOT NULL
Product
- id — int — Primary key — NOT NULL
- productName — nvarchar(30)
- unitPrice — decimal
- supplierid — id — NOT NULL
Supplier
- id — id — Primary key — NOT NULL
- CompanyName — nvarchar(30)
- city — nvarchar(30)
- country — nvarchar(30)
- contactname — nvarchar(30)
_Order
- id — int — Primary key — NOT NULL
- orderdate — datetime2
- totalamount — decimal
- customerid — int — NOT NULL