From dbscript Online Help
wikibot
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
CustomerID
|
int
|
not null
|
|
PK_StoreContact_CustomerID_ContactID
|
|
ContactID
|
int
|
not null
|
|
PK_StoreContact_CustomerID_ContactID
|
IX_StoreContact_ContactID
|
ContactTypeID
|
int
|
not null
|
|
|
IX_StoreContact_ContactTypeID
|
rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_StoreContact_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
automatically generated
Table
|
Sales.StoreContact
|
Description
|
Cross-reference table mapping stores and their employees.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description / PK / Index
|
CustomerID
|
int
|
not null
|
|
Store identification number. Foreign key to Customer.CustomerID.PK_StoreContact_CustomerID_ContactID
|
ContactID
|
int
|
not null
|
|
Contact (store employee) identification number. Foreign key to Contact.ContactID.PK_StoreContact_CustomerID_ContactIDIX_StoreContact_ContactID
|
ContactTypeID
|
int
|
not null
|
|
Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.IX_StoreContact_ContactTypeID
|
rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_StoreContact_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|