Difference between revisions of "Sales.Store (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.Store |- |} {| border="1" cellpadding="5" cellspacing="0" style="borde...)
 
Line 59: Line 59:
 
| (getdate())
 
| (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
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.Store
 +
|-
 +
 +
| '''Description
 +
| Customers (resellers) of Adventure Works products.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
| '''PK / Index
 +
 +
|-
 +
| CustomerID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to Customer.CustomerID.
 +
| PK_Store_CustomerID
 +
|-
 +
| Name
 +
| Name
 +
| not null
 +
|
 +
| Name of the store.
 +
|
 +
|-
 +
| SalesPersonID
 +
| int
 +
| null
 +
|
 +
| ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID.
 +
| IX_Store_SalesPersonID
 +
|-
 +
| Demographics
 +
| XML
 +
| null
 +
|
 +
| Demographic informationg about the store such as the number of employees, annual sales and store type.
 +
| PXML_Store_Demographics
 +
|-
 +
| rowguid
 +
| uniqueidentifier
 +
| not null
 +
| (NEWID())
 +
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 +
| AK_Store_rowguid
 +
|-
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:27, 26 November 2009

wikibot

Table Sales.Store


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())


Relation Column Referenced Column
Sales.Customer CustomerID CustomerID
Sales.SalesPerson SalesPersonID SalesPersonID


Detail Table Column Referencing Column
Sales.StoreContact CustomerID CustomerID


Triggers Type
iStore ON INSERT

automatically generated

Table Sales.Store
Description Customers (resellers) of Adventure Works products.


Column Data Type Nullable Default Description PK / Index
CustomerID int not null Primary key. Foreign key to Customer.CustomerID. PK_Store_CustomerID
Name Name not null Name of the store.
SalesPersonID int null ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID. IX_Store_SalesPersonID
Demographics XML null Demographic informationg about the store such as the number of employees, annual sales and store type. PXML_Store_Demographics
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_Store_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Sales.Customer CustomerID CustomerID
Sales.SalesPerson SalesPersonID SalesPersonID


Detail Table Column Referencing Column
Sales.StoreContact CustomerID CustomerID


Triggers Type
iStore ON INSERT
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.Store_(table)&oldid=1132"