| Categories | CategoryID | long NULL | Number automatically assigned to a new category.
|
| Categories | CategoryName | text(15) NOT NULL | Name of food category.
|
| Categories | Description | memo NULL | |
| Categories | Picture | OLE object NULL | A picture representing the food category.
|
| Customers | CustomerID | text(5) NULL | Unique five-character code based on customer name.
|
| Customers | CompanyName | text(40) NOT NULL | |
| Customers | ContactName | text(30) NULL | |
| Customers | ContactTitle | text(30) NULL | |
| Customers | Address | text(60) NULL | Street or post-office box.
|
| Customers | City | text(15) NULL | |
| Customers | Region | text(15) NULL | State or province.
|
| Customers | PostalCode | text(10) NULL | |
| Customers | Country | text(15) NULL | |
| Customers | Phone | text(24) NULL | Phone number includes country code or area code.
|
| Customers | Fax | text(24) NULL | Phone number includes country code or area code.
|
| DBA_ULCustomer | cust_id | long NOT NULL | |
| DBA_ULCustomer | cust_name | text(30) NULL | |
| DBA_ULCustomer | last_modified | datetime NULL | |
| Employees | EmployeeID | long NULL | Number automatically assigned to new employee.
|
| Employees | LastName | text(20) NOT NULL | |
| Employees | FirstName | text(10) NOT NULL | |
| Employees | Title | text(30) NULL | Employee's title.
|
| Employees | TitleOfCourtesy | text(25) NULL | Title used in salutations.
|
| Employees | BirthDate | datetime NULL | |
| Employees | HireDate | datetime NULL | |
| Employees | Address | text(60) NULL | Street or post-office box.
|
| Employees | City | text(15) NULL | |
| Employees | Region | text(15) NULL | State or province.
|
| Employees | PostalCode | text(10) NULL | |
| Employees | Country | text(15) NULL | |
| Employees | HomePhone | text(24) NULL | Phone number includes country code or area code.
|
| Employees | Extension | text(4) NULL | Internal telephone extension number.
|
| Employees | Photo | OLE object NULL | Picture of employee.
|
| Employees | Notes | memo NULL | General information about employee's background.
|
| Employees | ReportsTo | long NULL | Employee's supervisor.
|
| Friends | Name | text(50) NULL | |
| Friends | Link | text(50) NULL | |
| Order Details | OrderID | long NULL | Same as Order ID in Orders table.
|
| Order Details | ProductID | long NOT NULL | Same as Product ID in Products table.
|
| Order Details | UnitPrice | currency NOT NULL
= 0 | |
| Order Details | Quantity | int NOT NULL
= 1 | |
| Order Details | Discount | single NOT NULL
= 0 | |
| Orders | OrderID | long NULL | Unique order number.
|
| Orders | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| Orders | EmployeeID | long NULL | Same entry as in Employees table.
|
| Orders | OrderDate | datetime NULL | |
| Orders | RequiredDate | datetime NULL | |
| Orders | ShippedDate | datetime NULL | |
| Orders | ShipVia | long NULL | Same as Shipper ID in Shippers table.
|
| Orders | Freight | currency NULL
= 0 | |
| Orders | ShipName | text(40) NULL | Name of person or company to receive the shipment.
|
| Orders | ShipAddress | text(60) NULL | Street address only -- no post-office box allowed.
|
| Orders | ShipCity | text(15) NULL | |
| Orders | ShipRegion | text(15) NULL | State or province.
|
| Orders | ShipPostalCode | text(10) NULL | |
| Orders | ShipCountry | text(15) NULL | |
| Products | ProductID | long NULL | Number automatically assigned to new product.
|
| Products | ProductName | text(40) NOT NULL | |
| Products | SupplierID | long NULL | Same entry as in Suppliers table.
|
| Products | CategoryID | long NULL | Same entry as in Categories table.
|
| Products | QuantityPerUnit | text(20) NULL | (e.g., 24-count case, 1-liter bottle).
|
| Products | UnitPrice | currency NULL
= 0 | |
| Products | UnitsInStock | int NULL
= 0 | |
| Products | UnitsOnOrder | int NULL
= 0 | |
| Products | ReorderLevel | int NULL
= 0 | Minimum units to maintain in stock.
|
| Products | Discontinued | boolean NULL
= =No | Yes means item is no longer available.
|
| Shippers | ShipperID | long NULL | Number automatically assigned to new shipper.
|
| Shippers | CompanyName | text(40) NOT NULL | Name of shipping company.
|
| Shippers | Phone | text(24) NULL | Phone number includes country code or area code.
|
| Suppliers | SupplierID | long NULL | Number automatically assigned to new supplier.
|
| Suppliers | CompanyName | text(40) NOT NULL | |
| Suppliers | ContactName | text(30) NULL | |
| Suppliers | ContactTitle | text(30) NULL | |
| Suppliers | Address | text(60) NULL | Street or post-office box.
|
| Suppliers | City | text(15) NULL | |
| Suppliers | Region | text(15) NULL | State or province.
|
| Suppliers | PostalCode | text(10) NULL | |
| Suppliers | Country | text(15) NULL | |
| Suppliers | Phone | text(24) NULL | Phone number includes country code or area code.
|
| Suppliers | Fax | text(24) NULL | Phone number includes country code or area code.
|
| Suppliers | HomePage | memo NULL | Supplier's home page on World Wide Web.
|
| tblProperties | lngPropertyID | long NULL | |
| tblProperties | lngPropertTypeID | long NULL
= 0 | |
| tblProperties | strPropertyNumber | text(50) NULL | |
| tblProperties | strAddressStreet | text(50) NULL | |
| tblProperties | strAddressTownVillage | text(50) NULL | |
| tblProperties | strAddressPostalCode | text(10) NULL | |
| tblProperties | strAddressCounty | text(50) NULL | |
| tblProperties | memProperyPhotoLink | memo NULL | path to the image
|
| tblProperties | blnFreeHold | boolean NULL | |
| tblProperties | blnLeaseHold | boolean NULL | |
| tblProperties | curPropertyAskingPrice | currency NULL
= 0 | market price
|
| tblProperties | memPropertyNotes | memo NULL | |
| tblPropertyFeatures | lngFeatureID | long NULL | |
| tblPropertyFeatures | strFeatureName | text(25) NULL | |
| ~sq_cCategories~sq_cProduct List | ProductID | long NULL | Number automatically assigned to new product.
|
| ~sq_cCategories~sq_cProduct List | ProductName | text(40) NOT NULL | |
| ~sq_cCategories~sq_cProduct List | SupplierID | long NULL | Same entry as in Suppliers table.
|
| ~sq_cCategories~sq_cProduct List | CategoryID | long NULL | Same entry as in Categories table.
|
| ~sq_cCategories~sq_cProduct List | QuantityPerUnit | text(20) NULL | (e.g., 24-count case, 1-liter bottle).
|
| ~sq_cCategories~sq_cProduct List | UnitPrice | currency NULL
= 0 | |
| ~sq_cCategories~sq_cProduct List | UnitsInStock | int NULL
= 0 | |
| ~sq_cCategories~sq_cProduct List | UnitsOnOrder | int NULL
= 0 | |
| ~sq_cCategories~sq_cProduct List | ReorderLevel | int NULL
= 0 | Minimum units to maintain in stock.
|
| ~sq_cCategories~sq_cProduct List | Discontinued | boolean NULL
= =No | Yes means item is no longer available.
|
| ~sq_cCustomer Labels Dialog~sq_cSelectCountry | Country | text(15) NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | OrderID | long NULL | Unique order number.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | EmployeeID | long NULL | Same entry as in Employees table.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | OrderDate | datetime NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | RequiredDate | datetime NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShippedDate | datetime NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShipVia | long NULL | Same as Shipper ID in Shippers table.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | Freight | currency NULL
= 0 | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShipName | text(40) NULL | Name of person or company to receive the shipment.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShipAddress | text(60) NULL | Street address only -- no post-office box allowed.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShipCity | text(15) NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShipRegion | text(15) NULL | State or province.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShipPostalCode | text(10) NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform1 | ShipCountry | text(15) NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform2 | OrderID | long NULL | Same as Order ID in Orders table.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform2 | ProductID | long NOT NULL | Same as Product ID in Products table.
|
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform2 | ProductName | text(40) NOT NULL | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform2 | UnitPrice | currency NOT NULL
= 0 | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform2 | Quantity | int NOT NULL
= 1 | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform2 | Discount | single NOT NULL
= 0 | |
| ~sq_cCustomer Orders~sq_cCustomer Orders Subform2 | ExtendedPrice | currency NULL | |
| ~sq_cCustomers~sq_cCountry | Country | text(15) NULL | |
| ~sq_cEmployees (page break)~sq_cReportsTo | EmployeeID | long NULL | Number automatically assigned to new employee.
|
| ~sq_cEmployees (page break)~sq_cReportsTo | ReportsTo | text(0) NULL | |
| ~sq_cEmployees~sq_cReportsTo | EmployeeID | long NULL | Number automatically assigned to new employee.
|
| ~sq_cEmployees~sq_cReportsTo | ReportsTo | text(0) NULL | |
| ~sq_cOrders~sq_cCustomerID | CustomerID | text(5) NULL | Unique five-character code based on customer name.
|
| ~sq_cOrders~sq_cCustomerID | CompanyName | text(40) NOT NULL | |
| ~sq_cOrders~sq_cEmployeeID | EmployeeID | long NULL | Number automatically assigned to new employee.
|
| ~sq_cOrders~sq_cEmployeeID | Salesperson | text(0) NULL | |
| ~sq_cOrders~sq_cOrders Subform | OrderID | long NULL | Same as Order ID in Orders table.
|
| ~sq_cOrders~sq_cOrders Subform | ProductID | long NOT NULL | Same as Product ID in Products table.
|
| ~sq_cOrders~sq_cOrders Subform | ProductName | text(40) NOT NULL | |
| ~sq_cOrders~sq_cOrders Subform | UnitPrice | currency NOT NULL
= 0 | |
| ~sq_cOrders~sq_cOrders Subform | Quantity | int NOT NULL
= 1 | |
| ~sq_cOrders~sq_cOrders Subform | Discount | single NOT NULL
= 0 | |
| ~sq_cOrders~sq_cOrders Subform | ExtendedPrice | currency NULL | |
| ~sq_cProducts~sq_cCategoryID | CategoryID | long NULL | Number automatically assigned to a new category.
|
| ~sq_cProducts~sq_cCategoryID | CategoryName | text(15) NOT NULL | Name of food category.
|
| ~sq_cProducts~sq_cSupplierID | SupplierID | long NULL | Number automatically assigned to new supplier.
|
| ~sq_cProducts~sq_cSupplierID | CompanyName | text(40) NOT NULL | |
| ~sq_cQuarterly Orders~sq_cQuarterly Orders Subform | ProductName | text(40) NOT NULL | |
| ~sq_cQuarterly Orders~sq_cQuarterly Orders Subform | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| ~sq_cQuarterly Orders~sq_cQuarterly Orders Subform | OrderYear | int NULL | |
| ~sq_cQuarterly Orders~sq_cQuarterly Orders Subform | Qtr 1 | currency NULL | |
| ~sq_cQuarterly Orders~sq_cQuarterly Orders Subform | Qtr 2 | currency NULL | |
| ~sq_cQuarterly Orders~sq_cQuarterly Orders Subform | Qtr 3 | currency NULL | |
| ~sq_cQuarterly Orders~sq_cQuarterly Orders Subform | Qtr 4 | currency NULL | |
| ~sq_cSales Reports Dialog~sq_cSelectCategory | CategoryName | text(15) NOT NULL | Name of food category.
|
| ~sq_dSales by Category~sq_dSales by Category Subreport | CategoryID | long NULL | Number automatically assigned to a new category.
|
| ~sq_dSales by Category~sq_dSales by Category Subreport | CategoryName | text(15) NOT NULL | Name of food category.
|
| ~sq_dSales by Category~sq_dSales by Category Subreport | ProductName | text(40) NOT NULL | |
| ~sq_dSales by Category~sq_dSales by Category Subreport | ProductSales | currency NULL | |
| ~sq_fCategories | CategoryID | long NULL | Number automatically assigned to a new category.
|
| ~sq_fCategories | CategoryName | text(15) NOT NULL | Name of food category.
|
| ~sq_fCategories | Description | memo NULL | |
| ~sq_fCategories | Picture | OLE object NULL | A picture representing the food category.
|
| ~sq_fCustomer Orders | CustomerID | text(5) NULL | Unique five-character code based on customer name.
|
| ~sq_fCustomer Orders | CompanyName | text(40) NOT NULL | |
| ~sq_fCustomer Orders | ContactName | text(30) NULL | |
| ~sq_fCustomer Orders | ContactTitle | text(30) NULL | |
| ~sq_fCustomer Orders | Address | text(60) NULL | Street or post-office box.
|
| ~sq_fCustomer Orders | City | text(15) NULL | |
| ~sq_fCustomer Orders | Region | text(15) NULL | State or province.
|
| ~sq_fCustomer Orders | PostalCode | text(10) NULL | |
| ~sq_fCustomer Orders | Country | text(15) NULL | |
| ~sq_fCustomer Orders | Phone | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fCustomer Orders | Fax | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fCustomer Orders Subform1 | OrderID | long NULL | Unique order number.
|
| ~sq_fCustomer Orders Subform1 | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| ~sq_fCustomer Orders Subform1 | EmployeeID | long NULL | Same entry as in Employees table.
|
| ~sq_fCustomer Orders Subform1 | OrderDate | datetime NULL | |
| ~sq_fCustomer Orders Subform1 | RequiredDate | datetime NULL | |
| ~sq_fCustomer Orders Subform1 | ShippedDate | datetime NULL | |
| ~sq_fCustomer Orders Subform1 | ShipVia | long NULL | Same as Shipper ID in Shippers table.
|
| ~sq_fCustomer Orders Subform1 | Freight | currency NULL
= 0 | |
| ~sq_fCustomer Orders Subform1 | ShipName | text(40) NULL | Name of person or company to receive the shipment.
|
| ~sq_fCustomer Orders Subform1 | ShipAddress | text(60) NULL | Street address only -- no post-office box allowed.
|
| ~sq_fCustomer Orders Subform1 | ShipCity | text(15) NULL | |
| ~sq_fCustomer Orders Subform1 | ShipRegion | text(15) NULL | State or province.
|
| ~sq_fCustomer Orders Subform1 | ShipPostalCode | text(10) NULL | |
| ~sq_fCustomer Orders Subform1 | ShipCountry | text(15) NULL | |
| ~sq_fCustomer Phone List | CustomerID | text(5) NULL | Unique five-character code based on customer name.
|
| ~sq_fCustomer Phone List | CompanyName | text(40) NOT NULL | |
| ~sq_fCustomer Phone List | ContactName | text(30) NULL | |
| ~sq_fCustomer Phone List | ContactTitle | text(30) NULL | |
| ~sq_fCustomer Phone List | Address | text(60) NULL | Street or post-office box.
|
| ~sq_fCustomer Phone List | City | text(15) NULL | |
| ~sq_fCustomer Phone List | Region | text(15) NULL | State or province.
|
| ~sq_fCustomer Phone List | PostalCode | text(10) NULL | |
| ~sq_fCustomer Phone List | Country | text(15) NULL | |
| ~sq_fCustomer Phone List | Phone | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fCustomer Phone List | Fax | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fCustomers | CustomerID | text(5) NULL | Unique five-character code based on customer name.
|
| ~sq_fCustomers | CompanyName | text(40) NOT NULL | |
| ~sq_fCustomers | ContactName | text(30) NULL | |
| ~sq_fCustomers | ContactTitle | text(30) NULL | |
| ~sq_fCustomers | Address | text(60) NULL | Street or post-office box.
|
| ~sq_fCustomers | City | text(15) NULL | |
| ~sq_fCustomers | Region | text(15) NULL | State or province.
|
| ~sq_fCustomers | PostalCode | text(10) NULL | |
| ~sq_fCustomers | Country | text(15) NULL | |
| ~sq_fCustomers | Phone | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fCustomers | Fax | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fEmployees | EmployeeID | long NULL | Number automatically assigned to new employee.
|
| ~sq_fEmployees | LastName | text(20) NOT NULL | |
| ~sq_fEmployees | FirstName | text(10) NOT NULL | |
| ~sq_fEmployees | Title | text(30) NULL | Employee's title.
|
| ~sq_fEmployees | TitleOfCourtesy | text(25) NULL | Title used in salutations.
|
| ~sq_fEmployees | BirthDate | datetime NULL | |
| ~sq_fEmployees | HireDate | datetime NULL | |
| ~sq_fEmployees | Address | text(60) NULL | Street or post-office box.
|
| ~sq_fEmployees | City | text(15) NULL | |
| ~sq_fEmployees | Region | text(15) NULL | State or province.
|
| ~sq_fEmployees | PostalCode | text(10) NULL | |
| ~sq_fEmployees | Country | text(15) NULL | |
| ~sq_fEmployees | HomePhone | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fEmployees | Extension | text(4) NULL | Internal telephone extension number.
|
| ~sq_fEmployees | Photo | OLE object NULL | Picture of employee.
|
| ~sq_fEmployees | Notes | memo NULL | General information about employee's background.
|
| ~sq_fEmployees | ReportsTo | long NULL | Employee's supervisor.
|
| ~sq_fEmployees (page break) | EmployeeID | long NULL | Number automatically assigned to new employee.
|
| ~sq_fEmployees (page break) | LastName | text(20) NOT NULL | |
| ~sq_fEmployees (page break) | FirstName | text(10) NOT NULL | |
| ~sq_fEmployees (page break) | Title | text(30) NULL | Employee's title.
|
| ~sq_fEmployees (page break) | TitleOfCourtesy | text(25) NULL | Title used in salutations.
|
| ~sq_fEmployees (page break) | BirthDate | datetime NULL | |
| ~sq_fEmployees (page break) | HireDate | datetime NULL | |
| ~sq_fEmployees (page break) | Address | text(60) NULL | Street or post-office box.
|
| ~sq_fEmployees (page break) | City | text(15) NULL | |
| ~sq_fEmployees (page break) | Region | text(15) NULL | State or province.
|
| ~sq_fEmployees (page break) | PostalCode | text(10) NULL | |
| ~sq_fEmployees (page break) | Country | text(15) NULL | |
| ~sq_fEmployees (page break) | HomePhone | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fEmployees (page break) | Extension | text(4) NULL | Internal telephone extension number.
|
| ~sq_fEmployees (page break) | Photo | OLE object NULL | Picture of employee.
|
| ~sq_fEmployees (page break) | Notes | memo NULL | General information about employee's background.
|
| ~sq_fEmployees (page break) | ReportsTo | long NULL | Employee's supervisor.
|
| ~sq_fProducts | ProductID | long NULL | Number automatically assigned to new product.
|
| ~sq_fProducts | ProductName | text(40) NOT NULL | |
| ~sq_fProducts | SupplierID | long NULL | Same entry as in Suppliers table.
|
| ~sq_fProducts | CategoryID | long NULL | Same entry as in Categories table.
|
| ~sq_fProducts | QuantityPerUnit | text(20) NULL | (e.g., 24-count case, 1-liter bottle).
|
| ~sq_fProducts | UnitPrice | currency NULL
= 0 | |
| ~sq_fProducts | UnitsInStock | int NULL
= 0 | |
| ~sq_fProducts | UnitsOnOrder | int NULL
= 0 | |
| ~sq_fProducts | ReorderLevel | int NULL
= 0 | Minimum units to maintain in stock.
|
| ~sq_fProducts | Discontinued | boolean NULL
= =No | Yes means item is no longer available.
|
| ~sq_fSuppliers | SupplierID | long NULL | Number automatically assigned to new supplier.
|
| ~sq_fSuppliers | CompanyName | text(40) NOT NULL | |
| ~sq_fSuppliers | ContactName | text(30) NULL | |
| ~sq_fSuppliers | ContactTitle | text(30) NULL | |
| ~sq_fSuppliers | Address | text(60) NULL | Street or post-office box.
|
| ~sq_fSuppliers | City | text(15) NULL | |
| ~sq_fSuppliers | Region | text(15) NULL | State or province.
|
| ~sq_fSuppliers | PostalCode | text(10) NULL | |
| ~sq_fSuppliers | Country | text(15) NULL | |
| ~sq_fSuppliers | Phone | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fSuppliers | Fax | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_fSuppliers | HomePage | memo NULL | Supplier's home page on World Wide Web.
|
| ~sq_rCustomer Labels | CustomerID | text(5) NULL | Unique five-character code based on customer name.
|
| ~sq_rCustomer Labels | CompanyName | text(40) NOT NULL | |
| ~sq_rCustomer Labels | ContactName | text(30) NULL | |
| ~sq_rCustomer Labels | ContactTitle | text(30) NULL | |
| ~sq_rCustomer Labels | Address | text(60) NULL | Street or post-office box.
|
| ~sq_rCustomer Labels | City | text(15) NULL | |
| ~sq_rCustomer Labels | Region | text(15) NULL | State or province.
|
| ~sq_rCustomer Labels | PostalCode | text(10) NULL | |
| ~sq_rCustomer Labels | Country | text(15) NULL | |
| ~sq_rCustomer Labels | Phone | text(24) NULL | Phone number includes country code or area code.
|
| ~sq_rCustomer Labels | Fax | text(24) NULL | Phone number includes country code or area code.
|
| Alphabetical List of Products | ProductID | long NULL | Number automatically assigned to new product.
|
| Alphabetical List of Products | ProductName | text(40) NOT NULL | |
| Alphabetical List of Products | SupplierID | long NULL | Same entry as in Suppliers table.
|
| Alphabetical List of Products | CategoryID | long NULL | Same entry as in Categories table.
|
| Alphabetical List of Products | QuantityPerUnit | text(20) NULL | (e.g., 24-count case, 1-liter bottle).
|
| Alphabetical List of Products | UnitPrice | currency NULL
= 0 | |
| Alphabetical List of Products | UnitsInStock | int NULL
= 0 | |
| Alphabetical List of Products | UnitsOnOrder | int NULL
= 0 | |
| Alphabetical List of Products | ReorderLevel | int NULL
= 0 | Minimum units to maintain in stock.
|
| Alphabetical List of Products | Discontinued | boolean NULL
= =No | Yes means item is no longer available.
|
| Alphabetical List of Products | CategoryName | text(15) NOT NULL | Name of food category.
|
| Catalog | CategoryName | text(15) NOT NULL | Name of food category.
|
| Catalog | Description | memo NULL | |
| Catalog | Picture | OLE object NULL | A picture representing the food category.
|
| Catalog | ProductID | long NULL | Number automatically assigned to new product.
|
| Catalog | ProductName | text(40) NOT NULL | |
| Catalog | QuantityPerUnit | text(20) NULL | (e.g., 24-count case, 1-liter bottle).
|
| Catalog | UnitPrice | currency NULL
= 0 | |
| Category Sales for 1995 | CategoryName | text(15) NOT NULL | Name of food category.
|
| Category Sales for 1995 | CategorySales | currency NULL | |
| Current Product List | ProductID | long NULL | Number automatically assigned to new product.
|
| Current Product List | ProductName | text(40) NOT NULL | |
| Customers and Suppliers by City | City | text(255) NULL | |
| Customers and Suppliers by City | CompanyName | text(255) NULL | |
| Customers and Suppliers by City | ContactName | text(255) NULL | |
| Customers and Suppliers by City | Relationship | text(255) NULL | |
| Employee Sales by Country | Country | text(15) NULL | |
| Employee Sales by Country | LastName | text(20) NOT NULL | |
| Employee Sales by Country | FirstName | text(10) NOT NULL | |
| Employee Sales by Country | ShippedDate | datetime NULL | |
| Employee Sales by Country | OrderID | long NULL | Unique order number.
|
| Employee Sales by Country | SaleAmount | currency NULL | |
| Invoices | ShipName | text(40) NULL | Name of person or company to receive the shipment.
|
| Invoices | ShipAddress | text(60) NULL | Street address only -- no post-office box allowed.
|
| Invoices | ShipCity | text(15) NULL | |
| Invoices | ShipRegion | text(15) NULL | State or province.
|
| Invoices | ShipPostalCode | text(10) NULL | |
| Invoices | ShipCountry | text(15) NULL | |
| Invoices | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| Invoices | Customers.CompanyName | text(40) NOT NULL | |
| Invoices | Address | text(60) NULL | Street or post-office box.
|
| Invoices | City | text(15) NULL | |
| Invoices | Region | text(15) NULL | State or province.
|
| Invoices | PostalCode | text(10) NULL | |
| Invoices | Country | text(15) NULL | |
| Invoices | Salesperson | text(0) NULL | |
| Invoices | OrderID | long NULL | Unique order number.
|
| Invoices | OrderDate | datetime NULL | |
| Invoices | RequiredDate | datetime NULL | |
| Invoices | ShippedDate | datetime NULL | |
| Invoices | Shippers.CompanyName | text(40) NOT NULL | Name of shipping company.
|
| Invoices | ProductID | long NOT NULL | Same as Product ID in Products table.
|
| Invoices | ProductName | text(40) NOT NULL | |
| Invoices | UnitPrice | currency NOT NULL
= 0 | |
| Invoices | Quantity | int NOT NULL
= 1 | |
| Invoices | Discount | single NOT NULL
= 0 | |
| Invoices | ExtendedPrice | currency NULL | |
| Invoices | Freight | currency NULL
= 0 | |
| Invoices Filter | ShipName | text(40) NULL | Name of person or company to receive the shipment.
|
| Invoices Filter | ShipAddress | text(60) NULL | Street address only -- no post-office box allowed.
|
| Invoices Filter | ShipCity | text(15) NULL | |
| Invoices Filter | ShipRegion | text(15) NULL | State or province.
|
| Invoices Filter | ShipPostalCode | text(10) NULL | |
| Invoices Filter | ShipCountry | text(15) NULL | |
| Invoices Filter | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| Invoices Filter | Customers.CompanyName | text(40) NOT NULL | |
| Invoices Filter | Address | text(60) NULL | Street or post-office box.
|
| Invoices Filter | City | text(15) NULL | |
| Invoices Filter | Region | text(15) NULL | State or province.
|
| Invoices Filter | PostalCode | text(10) NULL | |
| Invoices Filter | Country | text(15) NULL | |
| Invoices Filter | Salesperson | text(0) NULL | |
| Invoices Filter | OrderID | long NULL | Unique order number.
|
| Invoices Filter | OrderDate | datetime NULL | |
| Invoices Filter | RequiredDate | datetime NULL | |
| Invoices Filter | ShippedDate | datetime NULL | |
| Invoices Filter | Shippers.CompanyName | text(40) NOT NULL | Name of shipping company.
|
| Invoices Filter | ProductID | long NOT NULL | Same as Product ID in Products table.
|
| Invoices Filter | ProductName | text(40) NOT NULL | |
| Invoices Filter | UnitPrice | currency NOT NULL
= 0 | |
| Invoices Filter | Quantity | int NOT NULL
= 1 | |
| Invoices Filter | Discount | single NOT NULL
= 0 | |
| Invoices Filter | ExtendedPrice | currency NULL | |
| Invoices Filter | Freight | currency NULL
= 0 | |
| Order Details Extended | OrderID | long NULL | Same as Order ID in Orders table.
|
| Order Details Extended | ProductID | long NOT NULL | Same as Product ID in Products table.
|
| Order Details Extended | ProductName | text(40) NOT NULL | |
| Order Details Extended | UnitPrice | currency NOT NULL
= 0 | |
| Order Details Extended | Quantity | int NOT NULL
= 1 | |
| Order Details Extended | Discount | single NOT NULL
= 0 | |
| Order Details Extended | ExtendedPrice | currency NULL | |
| Order Subtotals | OrderID | long NULL | Same as Order ID in Orders table.
|
| Order Subtotals | Subtotal | currency NULL | |
| Orders Qry | OrderID | long NULL | Unique order number.
|
| Orders Qry | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| Orders Qry | EmployeeID | long NULL | Same entry as in Employees table.
|
| Orders Qry | OrderDate | datetime NULL | |
| Orders Qry | RequiredDate | datetime NULL | |
| Orders Qry | ShippedDate | datetime NULL | |
| Orders Qry | ShipVia | long NULL | Same as Shipper ID in Shippers table.
|
| Orders Qry | Freight | currency NULL
= 0 | |
| Orders Qry | ShipName | text(40) NULL | Name of person or company to receive the shipment.
|
| Orders Qry | ShipAddress | text(60) NULL | Street address only -- no post-office box allowed.
|
| Orders Qry | ShipCity | text(15) NULL | |
| Orders Qry | ShipRegion | text(15) NULL | State or province.
|
| Orders Qry | ShipPostalCode | text(10) NULL | |
| Orders Qry | ShipCountry | text(15) NULL | |
| Orders Qry | CompanyName | text(40) NOT NULL | |
| Orders Qry | Address | text(60) NULL | Street or post-office box.
|
| Orders Qry | City | text(15) NULL | |
| Orders Qry | Region | text(15) NULL | State or province.
|
| Orders Qry | PostalCode | text(10) NULL | |
| Orders Qry | Country | text(15) NULL | |
| Product Sales for 1995 | CategoryName | text(15) NOT NULL | Name of food category.
|
| Product Sales for 1995 | ProductName | text(40) NOT NULL | |
| Product Sales for 1995 | ProductSales | currency NULL | |
| Products Above Average Price | ProductName | text(40) NOT NULL | |
| Products Above Average Price | UnitPrice | currency NULL
= 0 | |
| Products by Category | CategoryName | text(15) NOT NULL | Name of food category.
|
| Products by Category | ProductName | text(40) NOT NULL | |
| Products by Category | QuantityPerUnit | text(20) NULL | (e.g., 24-count case, 1-liter bottle).
|
| Products by Category | UnitsInStock | int NULL
= 0 | |
| Products by Category | Discontinued | boolean NULL
= =No | Yes means item is no longer available.
|
| Quarterly Orders | CustomerID | text(5) NULL | Unique five-character code based on customer name.
|
| Quarterly Orders | CompanyName | text(40) NOT NULL | |
| Quarterly Orders | City | text(15) NULL | |
| Quarterly Orders | Country | text(15) NULL | |
| Quarterly Orders by Product | ProductName | text(40) NOT NULL | |
| Quarterly Orders by Product | CustomerID | text(5) NULL | Same entry as in Customers table.
|
| Quarterly Orders by Product | OrderYear | int NULL | |
| Quarterly Orders by Product | Qtr 1 | currency NULL | |
| Quarterly Orders by Product | Qtr 2 | currency NULL | |
| Quarterly Orders by Product | Qtr 3 | currency NULL | |
| Quarterly Orders by Product | Qtr 4 | currency NULL | |
| query_MSysObjects | name | text(255) NULL | |
| query_MSysObjects | type | int NULL | |
| Sales by Category | CategoryID | long NULL | Number automatically assigned to a new category.
|
| Sales by Category | CategoryName | text(15) NOT NULL | Name of food category.
|
| Sales by Category | ProductName | text(40) NOT NULL | |
| Sales by Category | ProductSales | currency NULL | |
| Sales Totals by Amount | SaleAmount | currency NULL | |
| Sales Totals by Amount | OrderID | long NULL | Unique order number.
|
| Sales Totals by Amount | CompanyName | text(40) NOT NULL | |
| Sales Totals by Amount | ShippedDate | datetime NULL | |
| Summary of Sales by Quarter | ShippedDate | datetime NULL | |
| Summary of Sales by Quarter | OrderID | long NULL | Unique order number.
|
| Summary of Sales by Quarter | Subtotal | currency NULL | |
| Summary of Sales by Year | ShippedDate | datetime NULL | |
| Summary of Sales by Year | OrderID | long NULL | Unique order number.
|
| Summary of Sales by Year | Subtotal | currency NULL | |
| Ten Most Expensive Products | TenMostExpensiveProducts | text(40) NOT NULL | |
| Ten Most Expensive Products | UnitPrice | currency NULL
= 0 | |
| ULCustomerQuery | cust_id | long NOT NULL | |
| ULCustomerQuery | cust_name | text(30) NULL | |