Sales.Store (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:55Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:04Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:38Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:23Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:45Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:00Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:14Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:25Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:38Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.Store |- |} {| border="1" cellpadding="5" cellspacing="0" style="borde...

2009-01-03T12:35:14Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.Store |- |} {| border="1" cellpadding="5" cellspacing="0" style="borde...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Sales.Store
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| CustomerID
| int
| not null
|
| PK_Store_CustomerID
|
|-
| Name
| dbo.Name
| not null
|
|
|
|-
| SalesPersonID
| int
| null
|
|
| IX_Store_SalesPersonID
|-
| Demographics
| xml
| null
|
|
| PXML_Store_Demographics
|-
| rowguid
| uniqueidentifier
| not null
| (newid())
|
| AK_Store_rowguid
|-
| ModifiedDate
| datetime
| not null
| (getdate())
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[Sales.Customer_(table)|Sales.Customer]]
| CustomerID
| CustomerID
|-
| [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
| SalesPersonID
| SalesPersonID
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[Sales.StoreContact_(table)|Sales.StoreContact]]
| CustomerID
| CustomerID
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Triggers
| '''Type

|-
| iStore
| ON INSERT
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.Store
@@ Line 8: / Line 8: @@
 | '''Description
 | Customers (resellers) of Adventure Works products.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | CustomerID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Store_CustomerID
 | CustomerID
@@ Line 75: / Line 73: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_Store_rowguid
 | Unique
 | rowguid
-|-
+|- valign="top"
 | IX_Store_SalesPersonID
+|
 | SalesPersonID
-|-
+|- valign="top"
 | PXML_Store_Demographics
+|
@@ Line 96: / Line 94: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Sales.Customer_(table)|Sales.Customer]]
 | CustomerID
 | CustomerID
-|-
+|- valign="top"
 | [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 | SalesPersonID
@@ Line 113: / Line 111: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.StoreContact_(table)|Sales.StoreContact]]
 | CustomerID
@@ Line 123: / Line 121: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Triggers
+| '''Trigger
 | '''Type
-−
-|-
+|- valign="top"
 | iStore
 | ON INSERT
 |}
-	Trigger iStore
+==== Trigger iStore ====
 <pre>
 CREATE TRIGGER [Sales].[iStore] ON [Sales].[Store]
@@ Line 170: / Line 168: @@
 END;
 </pre>
-−
 === References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
@@ Line 181: / Line 179: @@
 | '''Child Object
-|-
+|- valign="top"
 | Data Type
 | Type
@@ Line 188: / Line 186: @@
+|
+|
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 195: / Line 193: @@
+|
+|
-|-
+|- valign="top"
 | Data Type
 | XML Schema Collection
-| [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|Sales.StoreSurveySchemaCollection]]
+| [[Sales.StoreSurveySchemaCollection_(xml schema collection)|Sales.StoreSurveySchemaCollection]]
+|
+|
-|-
+|- valign="top"
 | Select
 | Table
@@ Line 209: / Line 207: @@
 | Trigger
 | iStore
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 216: / Line 214: @@
 | Trigger
 | iStore
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 235: / Line 233: @@
 | '''Child Object
-|-
+|- valign="top"
 | Select
 | View
@@ Line 242: / Line 240: @@
+|
+|
-|-
+|- valign="top"
 | Select
 | Table

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key. Foreign key to Customer.CustomerID.<br />PK_Store_CustomerID
+| Primary key. Foreign key to Customer.CustomerID.
 |- valign="top"
 | Name
@@ Line 31: / Line 32: @@
 | not null
+|
-| Name of the store.<br />
+| Name of the store.
 |- valign="top"
 | SalesPersonID
@@ Line 37: / Line 38: @@
 | null
+|
-| ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID.<br />IX_Store_SalesPersonID
+| ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID.
 |- valign="top"
 | Demographics
@@ Line 43: / Line 44: @@
 | null
+|
-| Demographic informationg about the store such as the number of employees, annual sales and store type.<br />PXML_Store_Demographics
+| Demographic informationg about the store such as the number of employees, annual sales and store type.
 |- valign="top"
 | rowguid
@@ Line 49: / Line 50: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Store_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 55: / Line 56: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 76: / Line 107: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 89: / Line 120: @@
 |}
+=== Triggers ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 100: / Line 131: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 114: / Line 185: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
+|
@@ Line 147: / Line 225: @@
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 172: / Line 250: @@
 | iuIndividual
 |}

@@ Line 110: / Line 110: @@
 | Sales.Store
 |- valign="top"
 | '''Description
 | Customers (resellers) of Adventure Works products.
 |-
 |}

@@ Line 209: / Line 209: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
-| '''Object Type
-| '''Dependency Type
+| '''Child Type
 |-
 | [[dbo.Name_(type)|dbo.Name]]
-| Type
-| Data Type
 |-
 | Schema
 | Schema
 |-
 | [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|Sales.StoreSurveySchemaCollection]]
-| XML Schema Collection
-| Data Type
 |-
 | [[Sales.Individual_(table)|Sales.Individual]]
-| Table
 | Trigger
 | iStore
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | iStore
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | iStore
@@ Line 248: / Line 263: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
-| '''Object Type
-| '''Reference Type
+| '''Child Type
 |-
 | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
-| View
 | Select
-|-
+| Table
 | [[Sales.Individual_(table)|Sales.Individual]]
-| Table
 | Trigger
 | iuIndividual
 |}

@@ Line 212: / Line 212: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.Name_(type)|dbo.Name]]
 | Type
 | Data Type
 |-
 | [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|Sales.StoreSurveySchemaCollection]]
@@ Line 225: / Line 229: @@
 | Table
 | Select
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 | Procedure
 | Execute
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 | Procedure
 | Execute
 |}
@@ Line 241: / Line 251: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
@@ Line 250: / Line 260: @@
 | Table
 | Select
 |}