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

From dbscript Online Help
Jump to: navigation, search
(→‎Foreign Keys)
 
(2 intermediate revisions by one other user not shown)
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
 
| Sales.StoreContact
 
| Sales.StoreContact
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Cross-reference table mapping stores and their employees.
 
| Cross-reference table mapping stores and their employees.
−
|-
 
 
|}
 
|}
  
−
 
+
=== 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 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
−
+
 
 
|- valign="top"
 
|- valign="top"
 
| CustomerID
 
| CustomerID
Line 25: Line 24:
 
| not null
 
| not null
 
|  
 
|  
−
| Store identification number. Foreign key to Customer.CustomerID.<br />PK_StoreContact_CustomerID_ContactID
+
| Store identification number. Foreign key to Customer.CustomerID.
 
|- valign="top"
 
|- valign="top"
 
| ContactID
 
| ContactID
Line 31: Line 30:
 
| not null
 
| not null
 
|  
 
|  
−
| Contact (store employee) identification number. Foreign key to Contact.ContactID.<br />PK_StoreContact_CustomerID_ContactIDIX_StoreContact_ContactID
+
| Contact (store employee) identification number. Foreign key to Contact.ContactID.
 
|- valign="top"
 
|- valign="top"
 
| ContactTypeID
 
| ContactTypeID
Line 37: Line 36:
 
| not null
 
| not null
 
|  
 
|  
−
| Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.<br />IX_StoreContact_ContactTypeID
+
| Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.
 
|- valign="top"
 
|- valign="top"
 
| rowguid
 
| rowguid
Line 43: Line 42:
 
| not null
 
| not null
 
| (newid())
 
| (newid())
−
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_StoreContact_rowguid
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 49: Line 48:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| 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_StoreContact_CustomerID_ContactID
 +
| CustomerID, ContactID
 +
|}
  
−
 
+
=== Indexes ===
 
{| 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"
−
| '''Relation
+
| '''Index
−
| '''Column
+
| '''Type
−
| '''Referenced Column
+
| '''Columns
−
+
 
−
|-
+
|- valign="top"
−
| [[Person.Contact_(table)|Person.Contact]]
+
| AK_StoreContact_rowguid
 +
| Unique
 +
| rowguid
 +
|- valign="top"
 +
| IX_StoreContact_ContactID
 +
|  
 
| ContactID
 
| ContactID
−
| ContactID
+
|- valign="top"
−
|-
+
| IX_StoreContact_ContactTypeID
−
| [[Person.ContactType_(table)|Person.ContactType]]
+
|  
 
| ContactTypeID
 
| ContactTypeID
−
| ContactTypeID
 
−
|-
 
−
| [[Sales.Store_(table)|Sales.Store]]
 
−
| CustomerID
 
−
| CustomerID
 
 
|}
 
|}
  
 +
Hi,
 +
 +
We'd like to introduce to you our explainer video service which we feel can benefit your site devio.at.
 +
 +
Check out some of our existing videos here:
 +
https://www.youtube.com/watch?v=zvGF7uRfH04
 +
https://www.youtube.com/watch?v=MOnhn77TgDE
 +
https://www.youtube.com/watch?v=KhSCHaI6gw0
 +
 +
All of our videos are in a similar animated format as the above examples and we have voice over artists with US/UK/Australian accents.
 +
 +
They can show a solution to a problem or simply promote one of your products or services. They are concise, can be uploaded to video such as Youtube, and can be embedded into your website or featured on landing pages.
 +
 +
Our prices are as follows depending on video length:
 +
0-1 minutes = $159
 +
1-2 minutes = $269
 +
2-3 minutes = $379
 +
 +
*All prices above are in USD and include a custom video, full script and a voice-over.
 +
 +
If this is something you would like to discuss further, don't hesitate to get in touch.
 +
If you are not interested, simply delete this message and we won't contact you again.
 +
 +
Kind Regards,
 +
Barbara
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
  
 +
=== Dependencies ===
 
{| 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 81: Line 129:
 
| '''Referencing Object
 
| '''Referencing Object
  
−
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View
 
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
  
−
|-
+
|- valign="top"
 
| Select
 
| Select
 
| SQL table-valued-function
 
| SQL table-valued-function
Line 92: Line 140:
  
 
|}
 
|}
−
 
  
  

Latest revision as of 23:43, 24 April 2020

wikibot[edit]

Table Sales.StoreContact
Description Cross-reference table mapping stores and their employees.

Columns[edit]

Column Data Type Nullable Default Description
CustomerID int not null Store identification number. Foreign key to Customer.CustomerID.
ContactID int not null Contact (store employee) identification number. Foreign key to Contact.ContactID.
ContactTypeID int not null Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.
rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_StoreContact_CustomerID_ContactID CustomerID, ContactID

Indexes[edit]

Index Type Columns
AK_StoreContact_rowguid Unique rowguid
IX_StoreContact_ContactID ContactID
IX_StoreContact_ContactTypeID ContactTypeID

Hi,

We'd like to introduce to you our explainer video service which we feel can benefit your site devio.at.

Check out some of our existing videos here: https://www.youtube.com/watch?v=zvGF7uRfH04 https://www.youtube.com/watch?v=MOnhn77TgDE https://www.youtube.com/watch?v=KhSCHaI6gw0

All of our videos are in a similar animated format as the above examples and we have voice over artists with US/UK/Australian accents.

They can show a solution to a problem or simply promote one of your products or services. They are concise, can be uploaded to video such as Youtube, and can be embedded into your website or featured on landing pages.

Our prices are as follows depending on video length: 0-1 minutes = $159 1-2 minutes = $269 2-3 minutes = $379

  • All prices above are in USD and include a custom video, full script and a voice-over.

If this is something you would like to discuss further, don't hesitate to get in touch. If you are not interested, simply delete this message and we won't contact you again.

Kind Regards, Barbara

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales

Dependencies[edit]

Reference Type Object Type Referencing Object
Select View Sales.vStoreWithDemographics
Select SQL table-valued-function dbo.ufnGetContactInformation


automatically generated[edit]

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.


Relation Column Referenced Column
Person.Contact ContactID ContactID
Person.ContactType ContactTypeID ContactTypeID
Sales.Store CustomerID CustomerID


Dependency Type Object Type Referenced Object
Schema Schema Sales


Reference Type Object Type Referencing Object
Select View Sales.vStoreWithDemographics
Select SQL table-valued-function dbo.ufnGetContactInformation
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.StoreContact_(table)&oldid=3107"