# Table: ProductModel

## Properties

Property | Value
--- | ---
Name | ProductModel
ID | 162099618
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 144 KB
Index Size (KB) | 216 KB
Rows | 128
Unused (KB) | 232 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space | PRIMARY
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:45 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Product model classification.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | ProductModelID | int |  |  |
2 | Name | Name |  |  |
3 | CatalogDescription | xml |  |  |
4 | Instructions | xml |  |  |
5 | rowguid | uniqueidentifier |  |  |
6 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
ProductModelID | 1 | 1 | 128 |  |  |  |

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_ProductModel_ProductModelID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
ProductModelID

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_ProductModel_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_ProductModel_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_ProductModel_ProductModelID | CLUSTERED |  |  |  |  |
AK_ProductModel_Name | NONCLUSTERED |  |  |  |  |
AK_ProductModel_rowguid | NONCLUSTERED |  |  |  |  |
PXML_ProductModel_CatalogDescription | XML |  |  |  |  |
PXML_ProductModel_Instructions | XML |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object
--- | --- | --- | --- | --- | --- | --- | --- | ---
FK_Product_ProductModel_ProductModelID | 1 |  |  |  | No action | No action |  | Production.Product
FK_ProductModelIllustration_ProductModel_ProductModelID | 1 |  |  |  | No action | No action |  | Production.ProductModelIllustration
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID | 1 |  |  |  | No action | No action |  | Production.ProductModelProductDescriptionCulture

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_ProductModel_ProductModelID | Aug 8 2010 5:22PM | 128 | 128 | 65 | 1 | 4 |  |  | 128

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.0078125 | 4 | ProductModelID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
3 | 1 | 1 | 1 | 1
5 | 1 | 1 | 1 | 1
7 | 1 | 1 | 1 | 1
9 | 1 | 1 | 1 | 1
11 | 1 | 1 | 1 | 1
13 | 1 | 1 | 1 | 1
15 | 1 | 1 | 1 | 1
17 | 1 | 1 | 1 | 1
19 | 1 | 1 | 1 | 1
21 | 1 | 1 | 1 | 1
23 | 1 | 1 | 1 | 1
25 | 1 | 1 | 1 | 1
27 | 1 | 1 | 1 | 1
29 | 1 | 1 | 1 | 1
31 | 1 | 1 | 1 | 1
33 | 1 | 1 | 1 | 1
35 | 1 | 1 | 1 | 1
37 | 1 | 1 | 1 | 1
39 | 1 | 1 | 1 | 1
41 | 1 | 1 | 1 | 1
43 | 1 | 1 | 1 | 1
45 | 1 | 1 | 1 | 1
47 | 1 | 1 | 1 | 1
49 | 1 | 1 | 1 | 1
51 | 1 | 1 | 1 | 1
53 | 1 | 1 | 1 | 1
55 | 1 | 1 | 1 | 1
57 | 1 | 1 | 1 | 1
59 | 1 | 1 | 1 | 1
61 | 1 | 1 | 1 | 1
63 | 1 | 1 | 1 | 1
65 | 1 | 1 | 1 | 1
67 | 1 | 1 | 1 | 1
69 | 1 | 1 | 1 | 1
71 | 1 | 1 | 1 | 1
73 | 1 | 1 | 1 | 1
75 | 1 | 1 | 1 | 1
77 | 1 | 1 | 1 | 1
79 | 1 | 1 | 1 | 1
81 | 1 | 1 | 1 | 1
83 | 1 | 1 | 1 | 1
85 | 1 | 1 | 1 | 1
87 | 1 | 1 | 1 | 1
89 | 1 | 1 | 1 | 1
91 | 1 | 1 | 1 | 1
93 | 1 | 1 | 1 | 1
95 | 1 | 1 | 1 | 1
97 | 1 | 1 | 1 | 1
99 | 1 | 1 | 1 | 1
101 | 1 | 1 | 1 | 1
103 | 1 | 1 | 1 | 1
105 | 1 | 1 | 1 | 1
107 | 1 | 1 | 1 | 1
109 | 1 | 1 | 1 | 1
111 | 1 | 1 | 1 | 1
113 | 1 | 1 | 1 | 1
115 | 1 | 1 | 1 | 1
117 | 1 | 1 | 1 | 1
119 | 1 | 1 | 1 | 1
121 | 1 | 1 | 1 | 1
123 | 1 | 1 | 1 | 1
125 | 1 | 1 | 1 | 1
127 | 1 | 1 | 1 | 1
128 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_ProductModel_Name | Aug 8 2010 5:23PM | 128 | 128 | 121 | 1 | 35.82813 |  |  | 128

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.0078125 | 31.82813 | Name
0.0078125 | 35.82813 | Name, ProductModelID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
All-Purpose Bike Stand | 0 | 1 | 0 | 1
Bike Wash | 0 | 1 | 0 | 1
Cable Lock | 0 | 1 | 0 | 1
Chain | 0 | 1 | 0 | 1
Classic Vest | 0 | 1 | 0 | 1
Cycling Cap | 0 | 1 | 0 | 1
Fender Set - Mountain | 0 | 1 | 0 | 1
Front Brakes | 0 | 1 | 0 | 1
Front Derailleur | 0 | 1 | 0 | 1
Full-Finger Gloves | 0 | 1 | 0 | 1
Half-Finger Gloves | 0 | 1 | 0 | 1
Headlights - Dual-Beam | 0 | 1 | 0 | 1
Headlights - Weatherproof | 0 | 1 | 0 | 1
Hitch Rack - 4-Bike | 0 | 1 | 0 | 1
HL Bottom Bracket | 0 | 1 | 0 | 1
HL Crankset | 0 | 1 | 0 | 1
HL Fork | 0 | 1 | 0 | 1
HL Headset | 0 | 1 | 0 | 1
HL Mountain Frame | 0 | 1 | 0 | 1
HL Mountain Front Wheel | 0 | 1 | 0 | 1
HL Mountain Handlebars | 0 | 1 | 0 | 1
HL Mountain Pedal | 0 | 1 | 0 | 1
HL Mountain Rear Wheel | 0 | 1 | 0 | 1
HL Mountain Seat/Saddle 1 | 0 | 1 | 0 | 1
HL Mountain Seat/Saddle 2 | 0 | 1 | 0 | 1
HL Mountain Tire | 0 | 1 | 0 | 1
HL Road Frame | 0 | 1 | 0 | 1
HL Road Front Wheel | 0 | 1 | 0 | 1
HL Road Handlebars | 0 | 1 | 0 | 1
HL Road Pedal | 0 | 1 | 0 | 1
HL Road Rear Wheel | 0 | 1 | 0 | 1
HL Road Seat/Saddle 1 | 0 | 1 | 0 | 1
HL Road Seat/Saddle 2 | 0 | 1 | 0 | 1
HL Road Tire | 0 | 1 | 0 | 1
HL Touring Frame | 0 | 1 | 0 | 1
HL Touring Handlebars | 0 | 1 | 0 | 1
HL Touring Seat/Saddle | 0 | 1 | 0 | 1
Hydration Pack | 0 | 1 | 0 | 1
LL Bottom Bracket | 0 | 1 | 0 | 1
LL Crankset | 0 | 1 | 0 | 1
LL Fork | 0 | 1 | 0 | 1
LL Headset | 0 | 1 | 0 | 1
LL Mountain Frame | 0 | 1 | 0 | 1
LL Mountain Front Wheel | 0 | 1 | 0 | 1
LL Mountain Handlebars | 0 | 1 | 0 | 1
LL Mountain Pedal | 0 | 1 | 0 | 1
LL Mountain Rear Wheel | 0 | 1 | 0 | 1
LL Mountain Seat/Saddle 1 | 0 | 1 | 0 | 1
LL Mountain Seat/Saddle 2 | 0 | 1 | 0 | 1
LL Mountain Tire | 0 | 1 | 0 | 1
LL Road Frame | 0 | 1 | 0 | 1
LL Road Front Wheel | 0 | 1 | 0 | 1
LL Road Handlebars | 0 | 1 | 0 | 1
LL Road Pedal | 0 | 1 | 0 | 1
LL Road Rear Wheel | 0 | 1 | 0 | 1
LL Road Seat/Saddle 1 | 0 | 1 | 0 | 1
LL Road Seat/Saddle 2 | 0 | 1 | 0 | 1
LL Road Tire | 0 | 1 | 0 | 1
LL Touring Frame | 0 | 1 | 0 | 1
LL Touring Handlebars | 0 | 1 | 0 | 1
LL Touring Seat/Saddle | 0 | 1 | 0 | 1
Long-Sleeve Logo Jersey | 0 | 1 | 0 | 1
Men's Bib-Shorts | 0 | 1 | 0 | 1
Men's Sports Shorts | 0 | 1 | 0 | 1
Minipump | 0 | 1 | 0 | 1
ML Bottom Bracket | 0 | 1 | 0 | 1
ML Crankset | 0 | 1 | 0 | 1
ML Fork | 0 | 1 | 0 | 1
ML Headset | 0 | 1 | 0 | 1
ML Mountain Frame | 0 | 1 | 0 | 1
ML Mountain Frame-W | 0 | 1 | 0 | 1
ML Mountain Front Wheel | 0 | 1 | 0 | 1
ML Mountain Handlebars | 0 | 1 | 0 | 1
ML Mountain Pedal | 0 | 1 | 0 | 1
ML Mountain Rear Wheel | 0 | 1 | 0 | 1
ML Mountain Seat/Saddle 1 | 0 | 1 | 0 | 1
ML Mountain Seat/Saddle 2 | 0 | 1 | 0 | 1
ML Mountain Tire | 0 | 1 | 0 | 1
ML Road Frame | 0 | 1 | 0 | 1
ML Road Frame-W | 0 | 1 | 0 | 1
ML Road Front Wheel | 0 | 1 | 0 | 1
ML Road Handlebars | 0 | 1 | 0 | 1
ML Road Pedal | 0 | 1 | 0 | 1
ML Road Rear Wheel | 0 | 1 | 0 | 1
ML Road Seat/Saddle 1 | 0 | 1 | 0 | 1
ML Road Seat/Saddle 2 | 0 | 1 | 0 | 1
ML Road Tire | 0 | 1 | 0 | 1
ML Touring Seat/Saddle | 0 | 1 | 0 | 1
Mountain Bike Socks | 0 | 1 | 0 | 1
Mountain Bottle Cage | 0 | 1 | 0 | 1
Mountain Pump | 0 | 1 | 0 | 1
Mountain Tire Tube | 0 | 1 | 0 | 1
Mountain-100 | 0 | 1 | 0 | 1
Mountain-300 | 1 | 1 | 1 | 1
Mountain-400 | 0 | 1 | 0 | 1
Mountain-400-W | 0 | 1 | 0 | 1
Mountain-500 | 0 | 1 | 0 | 1
Patch kit | 0 | 1 | 0 | 1
Racing Socks | 0 | 1 | 0 | 1
Rear Brakes | 0 | 1 | 0 | 1
Rear Derailleur | 0 | 1 | 0 | 1
Road Bottle Cage | 0 | 1 | 0 | 1
Road Tire Tube | 0 | 1 | 0 | 1
Road-150 | 0 | 1 | 0 | 1
Road-350-W | 2 | 1 | 2 | 1
Road-550-W | 2 | 1 | 2 | 1
Road-750 | 1 | 1 | 1 | 1
Short-Sleeve Classic Jersey | 0 | 1 | 0 | 1
Sport-100 | 0 | 1 | 0 | 1
Taillight | 0 | 1 | 0 | 1
Touring Front Wheel | 0 | 1 | 0 | 1
Touring Pedal | 0 | 1 | 0 | 1
Touring Rear Wheel | 0 | 1 | 0 | 1
Touring Tire | 0 | 1 | 0 | 1
Touring Tire Tube | 0 | 1 | 0 | 1
Touring-1000 | 0 | 1 | 0 | 1
Touring-3000 | 1 | 1 | 1 | 1
Touring-Panniers | 0 | 1 | 0 | 1
Water Bottle | 0 | 1 | 0 | 1
Women's Mountain Shorts | 0 | 1 | 0 | 1
Women's Tights | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_ProductModel_rowguid | Aug 8 2010 5:23PM | 128 | 128 | 118 | 1 | 20 |  |  | 128

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.0078125 | 16 | rowguid
0.0078125 | 20 | rowguid, ProductModelID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
0481d7e1-4970-4efa-a560-020f6579918d | 0 | 1 | 0 | 1
219e2f87-26a9-483b-b968-04578e943096 | 1 | 1 | 1 | 1
0d48c51d-7603-4010-9265-0491805bb010 | 0 | 1 | 0 | 1
f06999a1-3aa7-4e85-b8cb-049eb2c391fa | 0 | 1 | 0 | 1
e3cdc5dd-27c3-4891-9d5e-0d46d1b8457f | 1 | 1 | 1 | 1
d71bd21c-239e-4c2b-98a3-101962d6b2d3 | 0 | 1 | 0 | 1
45fe0d77-6645-473c-a116-1232baea8d43 | 0 | 1 | 0 | 1
cca597fb-195f-4ec5-bf5c-15b98d176f4c | 0 | 1 | 0 | 1
dfe49035-7720-4ff4-b28b-16250ee46259 | 0 | 1 | 0 | 1
20efe3f1-a2f8-4dde-b74b-18265f61f863 | 0 | 1 | 0 | 1
a4b205df-955a-494e-8428-1898aea76f24 | 0 | 1 | 0 | 1
29321d47-1e4c-4aac-887c-19634328c25e | 0 | 1 | 0 | 1
baa9405b-68ca-4c18-bc9c-1c4acf49bafc | 0 | 1 | 0 | 1
7b17ebf1-cb73-4934-9689-1dc26cf22d9c | 0 | 1 | 0 | 1
42e1c597-6dd9-4071-b1a5-1dc5cdcbdbca | 0 | 1 | 0 | 1
bd8ba6f8-7e16-4fa3-b3b3-2036dd4a2ae0 | 0 | 1 | 0 | 1
474fb654-3c96-4cb9-82df-2152eeffbdb0 | 0 | 1 | 0 | 1
218b016c-7454-4193-b518-21955c783d72 | 0 | 1 | 0 | 1
a08dd61a-6155-4051-9a11-223232ea51cd | 0 | 1 | 0 | 1
4d332ecc-48b3-4e04-b7e7-227f3ac2a7ec | 0 | 1 | 0 | 1
ce1b1064-6679-4212-8f56-2b2617ec56a5 | 0 | 1 | 0 | 1
47f7c450-d16a-4cea-be6e-2d6c8c8f81ee | 0 | 1 | 0 | 1
059a2000-7549-4b49-8e0c-2de6b2771ef4 | 0 | 1 | 0 | 1
be9cdc56-f4ab-40f1-b338-2e08e0627abd | 0 | 1 | 0 | 1
7706a8fd-9513-40bc-95e8-301b55b67db2 | 0 | 1 | 0 | 1
95946bd4-c6d9-4344-8066-317d8957ea21 | 0 | 1 | 0 | 1
9da82e49-80ad-4918-9a54-31f4b0c8eabb | 0 | 1 | 0 | 1
39afbba9-0f6c-44ee-b5e1-32fa93f897e6 | 0 | 1 | 0 | 1
a7e65199-84a8-437e-ad55-360c1df1d788 | 0 | 1 | 0 | 1
b83ab7ae-ba3f-40df-8296-361915a3a60c | 0 | 1 | 0 | 1
d968d774-778e-4399-a3c5-375176418229 | 0 | 1 | 0 | 1
ddc67a2f-024a-4446-9b54-3c679baba708 | 0 | 1 | 0 | 1
b98a3207-56fc-405c-a040-3c7a90cc7890 | 0 | 1 | 0 | 1
aa77697c-6d1c-48f1-845c-3cb089498715 | 0 | 1 | 0 | 1
90cef1a7-d817-403e-814c-40e305eeefef | 1 | 1 | 1 | 1
8bbeb399-5a87-4e40-9f52-462fb54f2183 | 0 | 1 | 0 | 1
cfeef30f-f059-4447-92a8-47001e69f3db | 0 | 1 | 0 | 1
00ce9171-8944-4d49-ba37-485c1d122f5c | 0 | 1 | 0 | 1
10e0c8fd-ca13-437b-8e22-51853ae160a7 | 1 | 1 | 1 | 1
e878fcaa-61cc-4014-988a-51f52643f7aa | 0 | 1 | 0 | 1
15702f98-bd92-4fe8-86bc-52f5fd049d3d | 0 | 1 | 0 | 1
d60ed2a5-c100-4c54-89a1-531404c4a20f | 0 | 1 | 0 | 1
37d261a7-00cf-4880-ac1a-533b6b4365b0 | 0 | 1 | 0 | 1
aca920b2-d0f9-49f3-b879-573202b08c2f | 0 | 1 | 0 | 1
6d2fcce4-ffce-4662-a3f8-5d18f0eedcd8 | 0 | 1 | 0 | 1
b35598f6-b413-4138-8081-5dc7d4c64b64 | 0 | 1 | 0 | 1
5f115aa4-0553-4478-84b3-5dcf3abe0d08 | 0 | 1 | 0 | 1
4a17c43a-1a55-41bb-bc97-612f47cedeb3 | 0 | 1 | 0 | 1
1fadb88f-af88-4e94-bb1e-6158c48e6b40 | 0 | 1 | 0 | 1
f9327e5d-f8b6-40c5-bfa9-63f886bdfc24 | 0 | 1 | 0 | 1
deeea9bc-3c8c-4e73-b6b0-64c81a5d99e3 | 0 | 1 | 0 | 1
36b1a76a-dff3-4a55-86f9-65eb1cb18d7b | 0 | 1 | 0 | 1
a75483fe-3c47-4aa4-93cf-664b51192987 | 0 | 1 | 0 | 1
29521f66-2926-471f-867b-668b0b9ec2b0 | 0 | 1 | 0 | 1
e7e17f11-a7fd-4c3c-b701-68f0ae26143e | 0 | 1 | 0 | 1
71d47afd-da3a-43f1-83ad-69c71f96ef33 | 0 | 1 | 0 | 1
8da73708-8dae-44ae-ac6c-6e37022c1ffe | 0 | 1 | 0 | 1
84138622-1ea6-489f-9c98-6e3924cfbac0 | 0 | 1 | 0 | 1
fca0665b-b956-489a-a5ec-6f0b4aa14d02 | 0 | 1 | 0 | 1
a96ff80d-d52a-432f-9701-731bef16efcc | 0 | 1 | 0 | 1
3bcc63d6-9340-4b93-b5f2-73fa90758bf5 | 0 | 1 | 0 | 1
980c8cd0-4903-41f2-9ffc-773c7fe4c254 | 1 | 1 | 1 | 1
bbe4918f-198d-43c7-9f4b-79bc2aa08f2b | 0 | 1 | 0 | 1
3770c5e3-8dc9-43c7-b735-7aff21645d96 | 0 | 1 | 0 | 1
3cdf61d6-6209-436f-b235-82e8f159208b | 0 | 1 | 0 | 1
394ed69c-2cc4-4a85-9080-8534112b66fe | 0 | 1 | 0 | 1
aa977b32-acd8-4c53-a560-88a02ac1954d | 0 | 1 | 0 | 1
0434f63a-a361-4d0b-a9fc-8ac2a866ce85 | 1 | 1 | 1 | 1
c88d1136-a8bb-46bb-94aa-8c1854f813cc | 0 | 1 | 0 | 1
5cefbb6e-3b7e-414f-ac1b-8f6df741fb21 | 0 | 1 | 0 | 1
68c6cb29-d94a-40c5-aaad-90aa6e7c5ea1 | 0 | 1 | 0 | 1
3b78edff-2aa9-4ac1-8c3d-94090b5f53a9 | 0 | 1 | 0 | 1
95450545-adf7-48f3-899e-964de8920dc6 | 0 | 1 | 0 | 1
3494e8ff-7daf-4860-abf6-97842048e272 | 0 | 1 | 0 | 1
816360e1-3dee-4568-bf2f-9828243d887b | 0 | 1 | 0 | 1
14b56f2a-d4aa-40a4-b9a2-984f165ed702 | 0 | 1 | 0 | 1
aa10d9e6-e33f-4da8-ace1-992fcd6bb171 | 0 | 1 | 0 | 1
e7b00dff-8136-4947-b503-994584cc89e7 | 0 | 1 | 0 | 1
782c991b-a660-4561-a3f4-9bbd74259747 | 0 | 1 | 0 | 1
c9fcc804-2cd7-4b8a-b186-9c409cc19df9 | 0 | 1 | 0 | 1
09caa74e-f47b-4fca-b206-9d3e46df9751 | 0 | 1 | 0 | 1
2489ddc5-1c89-4dec-af22-b0112ccec467 | 0 | 1 | 0 | 1
7c738101-c01e-45a2-a0e0-b28aeba1dc40 | 0 | 1 | 0 | 1
6ba9f3b6-e08b-4ac2-a725-b41114c2a283 | 0 | 1 | 0 | 1
d566eb0f-6945-43d8-bc40-bb3d2f4ef7ed | 1 | 1 | 1 | 1
02a562e2-4dfa-4778-bbac-bbddcecf99b0 | 0 | 1 | 0 | 1
63a2199f-f5b5-49bd-bcfc-bec1d1d16d8b | 1 | 1 | 1 | 1
fdd5407b-c2db-49d1-a86b-c13a2e3582a2 | 0 | 1 | 0 | 1
94ffb702-0cbc-4e3f-b840-c51f0d11c8f6 | 0 | 1 | 0 | 1
90f759c1-2073-4d9f-854b-c6b6f3bf9162 | 0 | 1 | 0 | 1
52e7f2c1-dbff-4518-927d-c7d46f9ed32e | 0 | 1 | 0 | 1
8cfbe7f2-eec3-4ba6-8187-c8a3614f1f0b | 0 | 1 | 0 | 1
90b1b93d-ebc8-44a2-ac08-cdd1d20ca39c | 0 | 1 | 0 | 1
2771d2d2-2e35-4c12-966e-ce9070df6d53 | 0 | 1 | 0 | 1
809668a3-d492-41fb-a196-cfe092a12aa2 | 0 | 1 | 0 | 1
8456bb94-b4dd-4a47-a76b-d0e54ab4285d | 0 | 1 | 0 | 1
66c63844-2a24-473c-96d5-d3b3fd57d834 | 0 | 1 | 0 | 1
2bf795f4-2666-4691-af14-d490c7334a8a | 0 | 1 | 0 | 1
feeb8440-446e-4df8-9482-d529c4fc5e8f | 0 | 1 | 0 | 1
6beccf2d-eacd-496b-995b-d692567565cd | 0 | 1 | 0 | 1
866dbad3-5999-4329-beac-d826d959d9a1 | 1 | 1 | 1 | 1
6eab8607-d927-40e1-af30-d8a2a953050c | 0 | 1 | 0 | 1
f5a6ec78-4451-45db-955f-db197de8b059 | 1 | 1 | 1 | 1
6da78798-3793-4b8e-829e-dba9d140b1d4 | 0 | 1 | 0 | 1
699c2ac5-5406-46d2-863d-dcfb23fc7943 | 0 | 1 | 0 | 1
35677b42-72ca-4d9e-a966-dd874b83ef45 | 0 | 1 | 0 | 1
0d3a6ad7-6891-4de9-b14f-e1a841eb220c | 0 | 1 | 0 | 1
1099a23a-c9ed-41b1-8cc1-e2c1c54a10c8 | 0 | 1 | 0 | 1
8123f7e2-a5f4-4047-b69d-e74313dfebce | 0 | 1 | 0 | 1
f85f84f2-9ce0-4ecc-9c29-e78021ffc877 | 0 | 1 | 0 | 1
dba643d4-4cf2-4507-b947-e817d8c5792b | 0 | 1 | 0 | 1
5b59f032-9b73-4d90-b252-eafd6a871ff1 | 0 | 1 | 0 | 1
438cbcfa-05ff-4a29-ad95-ecf41dcb83d5 | 0 | 1 | 0 | 1
e196d02e-9bf6-4c67-b772-ed9f86ccf44c | 0 | 1 | 0 | 1
9416c2dd-55d8-469d-8edf-ef447c511897 | 0 | 1 | 0 | 1
24e3e7d4-4053-4035-9d69-f451642f0c1e | 0 | 1 | 0 | 1
65bf3f6d-bcf2-4db6-8515-fc5c57423037 | 0 | 1 | 0 | 1
3688268a-260c-48bf-bf71-fff350d4d3d5 | 0 | 1 | 0 | 1

## Objects that depend on [ProductModel]

- Production.ProductModel
  - Production.Product
    - dbo.KrystianProductView
    - dbo.ufnGetProductDealerPrice
      - Person.functionSynonym
    - dbo.ufnGetProductListPrice
    - dbo.ufnGetProductStandardCost
    - dbo.uspGetBillOfMaterials
      - HumanResources.ProcedureSynonym
    - dbo.uspGetWhereUsedProductID
    - Production.BillOfMaterials
    - Production.ProductCostHistory
    - Production.ProductDocument
    - Production.ProductInventory
      - dbo.ufnGetStock
    - Production.ProductListPriceHistory
    - Production.ProductProductPhoto
    - Production.ProductReview
    - Production.TransactionHistory
      - Production.WorkOrder
        - Production.iWorkOrder
        - Production.uWorkOrder
        - Production.WorkOrderRouting
      - Purchasing.PurchaseOrderDetail
        - Purchasing.iPurchaseOrderDetail
        - Purchasing.uPurchaseOrderDetail
      - Sales.SalesOrderDetail
        - Sales.iduSalesOrderDetail
        - Sales.ufn_SalesByStore
    - Production.uspGetList
    - Production.vProductAndDescription
    - Purchasing.ProductVendor
    - Sales.ShoppingCartItem
    - Sales.SpecialOfferProduct
  - Production.ProductModelIllustration
  - Production.ProductModelProductDescriptionCulture
  - Production.vProductModelCatalogDescription
  - Production.vProductModelInstructions

## Objects on which [ProductModel] depends

- Production.ProductModel
  - Production.ManuInstructionsSchemaCollection
  - dbo.Name
  - Production.ProductDescriptionSchemaCollection

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[ProductModel]( [ProductModelID] [int] IDENTITY(1,1) NOT NULL, [Name] [dbo].[Name] NOT NULL, [CatalogDescription] [xml](CONTENT [Production].[ProductDescriptionSchemaCollection]) NULL, [Instructions] [xml](CONTENT [Production].[ManuInstructionsSchemaCollection]) NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for ProductModel records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModel', @level2type=N'COLUMN',@level2name=N'ProductModelID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product model description.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModel', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Detailed product catalog information in xml format.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModel', @level2type=N'COLUMN',@level2name=N'CatalogDescription' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Manufacturing instructions in xml format.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModel', @level2type=N'COLUMN',@level2name=N'Instructions' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModel', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModel', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product model classification.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductModel'

#### See also

List of Tables