Table: ProductModel Table: ProductModel| 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 |
| Name | Value |
|---|---|
| MS_Description | Product model classification. |
| 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 |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| ProductModelID | 1 | 1 | 128 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_ProductModel_ProductModelID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| ProductModelID |
| 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() |
| 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 |
|
|
|
|
|
| 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 |
| 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 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.0078125 | 4 | ProductModelID |
| 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 |
| 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 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.0078125 | 31.82813 | Name |
| 0.0078125 | 35.82813 | Name, ProductModelID |
| 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 |
| 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 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.0078125 | 16 | rowguid |
| 0.0078125 | 20 | rowguid, ProductModelID |
| 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 |
| 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' |