Products

77 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProductID INTEGER 2000000000,10 null
Alphabetical list of products.ProductID Implied ConstraintR
Current Product List.ProductID Implied ConstraintR
Invoices.ProductID Implied ConstraintR
Order Details.ProductID R
Order Details Extended.ProductID Implied ConstraintR
Categories.CategoryID R
ProductName TEXT 2000000000,10 null
SupplierID INTEGER 2000000000,10 null
Suppliers.SupplierID R
CategoryID INTEGER 2000000000,10 null
Categories.CategoryID Implied ConstraintR
QuantityPerUnit TEXT 2000000000,10 null
UnitPrice NUMERIC 2000000000,10 0
UnitsInStock INTEGER 2000000000,10 0
UnitsOnOrder INTEGER 2000000000,10 0
ReorderLevel INTEGER 2000000000,10 0
Discontinued TEXT 2000000000,10 '0'

Indexes

Constraint Name Type Sort Column(s)
Products_s_pk Primary key Asc ProductID

Relationships