| name | value |
|---|---|
| name | Categories |
| created | 9/13/1995 10:51:30 AM |
| modified | 8/16/2008 9:43:29 PM |
| row count | 8 |
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|---|---|---|---|---|---|---|---|
| CategoryID | long | 4 | yes | yes | Products.CategoryID | Number automatically assigned to a new category. | ||
| CategoryName | text | 15 | no | yes | Name of food category. | |||
| Description | memo | 0 | yes | |||||
| Picture | OLE object | 0 | yes | A picture representing the food category. |
| name | description | column | comment |
|---|---|---|---|
| CategoryName | non-clustered, unique index on Categories | CategoryName | |
| PrimaryKey | non-clustered, unique primary key on Categories | CategoryID |
| name |
|---|
| Products |
| name | columns | foreign columns | type | comment |
|---|---|---|---|---|
| CategoriesProducts | CategoryID | Products.CategoryID |
| name | object type | level |
|---|---|---|
| ~sq_cCategories~sq_cProduct List | view | 1 |
| ~sq_cProducts~sq_cCategoryID | view | 1 |
| ~sq_cSales Reports Dialog~sq_cSelectCategory | view | 1 |
| ~sq_fCategories | view | 1 |
| Alphabetical List of Products | view | 1 |
| Catalog | view | 1 |
| Products by Category | view | 1 |
| Sales by Category | view | 1 |
| ~sq_dSales by Category~sq_dSales by Category Subreport | view | 2 |
| CategoryID | CategoryName | Description | Picture |
|---|---|---|---|
| 1 | Beverages | Soft drinks, coffees, teas, beers, and ales | System.Byte[] |
| 2 | Condiments | Sweet and savory sauces, relishes, spreads, and seasonings | System.Byte[] |
| 3 | Confections | Desserts, candies, and sweet breads | System.Byte[] |
| 4 | Dairy Products | Cheeses | System.Byte[] |
| 5 | Grains/Cereals | Breads, crackers, pasta, and cereal | System.Byte[] |
| 6 | Meat/Poultry | Prepared meats | System.Byte[] |
| 7 | Produce | Dried fruit and bean curd | System.Byte[] |
| 8 | Seafood | Seaweed and fish | System.Byte[] |