Order Details

2155 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OrderID INTEGER 2000000000,10 null
Orders.OrderID R
ProductID INTEGER 2000000000,10 null
Products.ProductID R
UnitPrice NUMERIC 2000000000,10 0
Quantity INTEGER 2000000000,10 1
Discount REAL 2000000000,10 0

Indexes

Constraint Name Type Sort Column(s)
Order Details_s_pk Primary key Asc/Asc OrderID + ProductID
sqlite_autoindex_Order Details_1 Must be unique Asc/Asc OrderID + ProductID

Relationships