Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
| | '''Table | | | '''Table |
| | Production.ProductModel | | | Production.ProductModel |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Product model classification.
| |
| |} | | |} |
| | | |
− | === Columns ===
| + | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| |- style="background:silver" | | |- style="background:silver" |
Line 17: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description | + | | '''PK |
− | | + | | '''Index |
− | |- valign="top" | + | |
| + | |- |
| | ProductModelID | | | ProductModelID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key for ProductModel records. | + | | PK_ProductModel_ProductModelID |
− | |- valign="top" | + | | |
| + | |- |
| | Name | | | Name |
| | dbo.Name | | | dbo.Name |
| | not null | | | not null |
| | | | | |
− | | Product model description. | + | | |
− | |- valign="top" | + | | AK_ProductModel_Name |
| + | |- |
| | CatalogDescription | | | CatalogDescription |
| | xml | | | xml |
| | null | | | null |
| | | | | |
− | | Detailed product catalog information in xml format. | + | | |
− | |- valign="top" | + | | PXML_ProductModel_CatalogDescription |
| + | |- |
| | Instructions | | | Instructions |
| | xml | | | xml |
| | null | | | null |
| | | | | |
− | | Manufacturing instructions in xml format. | + | | |
− | |- valign="top" | + | | PXML_ProductModel_Instructions |
| + | |- |
| | rowguid | | | rowguid |
| | uniqueidentifier | | | uniqueidentifier |
| | not null | | | not null |
| | (newid()) | | | (newid()) |
− | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | + | | |
− | |- valign="top" | + | | AK_ProductModel_rowguid |
| + | |- |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
| | (getdate()) | | | (getdate()) |
− | | Date and time the record was last updated.
| |
− | |}
| |
− |
| |
− | === Primary Key ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Primary Key
| |
− | | '''Columns
| |
− | |- valign="top"
| |
− | | PK_ProductModel_ProductModelID
| |
− | | ProductModelID
| |
− | |}
| |
− |
| |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− |
| |
− | |- valign="top"
| |
− | | AK_ProductModel_Name
| |
− | | Unique
| |
− | | Name
| |
− | |- valign="top"
| |
− | | AK_ProductModel_rowguid
| |
− | | Unique
| |
− | | rowguid
| |
− | |- valign="top"
| |
− | | PXML_ProductModel_CatalogDescription
| |
| | | | | |
− | | CatalogDescription
| |
− | |- valign="top"
| |
− | | PXML_ProductModel_Instructions
| |
| | | | | |
− | | Instructions
| |
− | |}
| |
− |
| |
− | === Detail Tables ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Detail Table
| |
− | | '''Column
| |
− | | '''Referencing Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Production.Product_(table)|Production.Product]]
| |
− | | ProductModelID
| |
− | | ProductModelID
| |
− | |- valign="top"
| |
− | | [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
| |
− | | ProductModelID
| |
− | | ProductModelID
| |
− | |- valign="top"
| |
− | | [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
| |
− | | ProductModelID
| |
− | | ProductModelID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Data Type
| |
− | | Type
| |
− | | [[dbo.Name_(type)|dbo.Name]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
− | |- valign="top"
| |
− | | Data Type
| |
− | | XML Schema Collection
| |
− | | [[Production.ManuInstructionsSchemaCollection_(xml schema collection)|Production.ManuInstructionsSchemaCollection]]
| |
− |
| |
− | |- valign="top"
| |
− | | Data Type
| |
− | | XML Schema Collection
| |
− | | [[Production.ProductDescriptionSchemaCollection_(xml schema collection)|Production.ProductDescriptionSchemaCollection]]
| |
− |
| |
− | |}
| |
− |
| |
− | === Dependencies ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |- valign="top"
| |
− | | Select
| |
− | | View
| |
− | | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
| |
− |
| |
− | |- valign="top"
| |
− | | Select
| |
− | | View
| |
− | | [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
| |
− |
| |
− | |- valign="top"
| |
− | | Select
| |
− | | View
| |
− | | [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |-
| |
− | | '''Table
| |
− | | Production.ProductModel
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Product model classification.
| |
− | |-
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description / PK / Index
| |
− |
| |
− | |- valign="top"
| |
− | | ProductModelID
| |
− | | int
| |
− | | not null
| |
− | |
| |
− | | Primary key for ProductModel records.<br />PK_ProductModel_ProductModelID
| |
− | |- valign="top"
| |
− | | Name
| |
− | | Name
| |
− | | not null
| |
− | |
| |
− | | Product model description.<br />AK_ProductModel_Name
| |
− | |- valign="top"
| |
− | | CatalogDescription
| |
− | | XML
| |
− | | null
| |
− | |
| |
− | | Detailed product catalog information in xml format.<br />PXML_ProductModel_CatalogDescription
| |
− | |- valign="top"
| |
− | | Instructions
| |
− | | XML
| |
− | | null
| |
− | |
| |
− | | Manufacturing instructions in xml format.<br />PXML_ProductModel_Instructions
| |
− | |- valign="top"
| |
− | | rowguid
| |
− | | uniqueidentifier
| |
− | | not null
| |
− | | (NEWID())
| |
− | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ProductModel_rowguid
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (GETDATE())
| |
− | | Date and time the record was last updated.<br />
| |
| |} | | |} |
| | | |
Line 246: |
Line 82: |
| | ProductModelID | | | ProductModelID |
| | ProductModelID | | | ProductModelID |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Data Type
| |
− | | Type
| |
− | | [[dbo.Name_(type)|dbo.Name]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
− | |-
| |
− | | Data Type
| |
− | | XML Schema Collection
| |
− | | [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
| |
− |
| |
− | |-
| |
− | | Data Type
| |
− | | XML Schema Collection
| |
− | | [[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|Production.ProductDescriptionSchemaCollection]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |-
| |
− | | Select
| |
− | | View
| |
− | | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
| |
− |
| |
− | |-
| |
− | | Select
| |
− | | View
| |
− | | [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
| |
− |
| |
− | |-
| |
− | | Select
| |
− | | View
| |
− | | [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
| |
− |
| |
| |} | | |} |