Sales.StoreContact (table) - Revision history

104.168.57.151: /* Foreign Keys */

2020-04-24T21:43:24Z

‎Foreign Keys

Bot at 22:17, 23 June 2010

2010-06-23T22:17:56Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:45Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:40Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:24Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:47Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:02Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:16Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:27Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:40Z

@@ Line 82: / Line 82: @@
 |}
-=== Foreign Keys ===
+Hi,
-|- valign="top"
+We'd like to introduce to you our explainer video service which we feel can benefit your site devio.at.
-| [[Person.Contact_(table)|Person.Contact]]
-| ContactID
+Check out some of our existing videos here:
-| ContactID
+https://www.youtube.com/watch?v=zvGF7uRfH04
-|- valign="top"
+https://www.youtube.com/watch?v=MOnhn77TgDE
-| [[Person.ContactType_(table)|Person.ContactType]]
+https://www.youtube.com/watch?v=KhSCHaI6gw0
-| ContactTypeID
-| ContactTypeID
+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.
-|- valign="top"
-| [[Sales.Store_(table)|Sales.Store]]
+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.
-| CustomerID
-| CustomerID
+Our prices are as follows depending on video length:
-|}
+-1 minutes = $159
 === References ===

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.StoreContact
@@ Line 8: / Line 8: @@
 | '''Description
 | Cross-reference table mapping stores and their employees.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | CustomerID
@@ Line 58: / Line 56: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_StoreContact_CustomerID_ContactID
 | CustomerID, ContactID
@@ Line 69: / Line 67: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_StoreContact_rowguid
 | Unique
 | rowguid
-|-
+|- valign="top"
 | IX_StoreContact_ContactID
+|
 | ContactID
-|-
+|- valign="top"
 | IX_StoreContact_ContactTypeID
+|
@@ Line 90: / Line 88: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.Contact_(table)|Person.Contact]]
 | ContactID
 | ContactID
-|-
+|- valign="top"
 | [[Person.ContactType_(table)|Person.ContactType]]
 | ContactTypeID
 | ContactTypeID
-|-
+|- valign="top"
 | [[Sales.Store_(table)|Sales.Store]]
 | CustomerID
@@ Line 112: / Line 110: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 126: / Line 124: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
-|-
+|- valign="top"
 | Select
 | SQL table-valued-function

@@ 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
+|
-| Store identification number. Foreign key to Customer.CustomerID.<br />PK_StoreContact_CustomerID_ContactID
+| Store identification number. Foreign key to Customer.CustomerID.
 |- valign="top"
 | ContactID
@@ Line 31: / Line 32: @@
 | 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"
 | ContactTypeID
@@ Line 37: / Line 38: @@
 | 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"
 | rowguid
@@ Line 43: / Line 44: @@
 | not null
 | (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"
 | ModifiedDate
@@ Line 49: / Line 50: @@
 | 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 74: / Line 105: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 92: / Line 137: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.StoreContact
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | CustomerID
 | int
 | not null
+|
-| PK_StoreContact_CustomerID_ContactID
+| Store identification number. Foreign key to Customer.CustomerID.<br />PK_StoreContact_CustomerID_ContactID
+|- valign="top"
 | ContactID
 | int
 | not null
+|
-| PK_StoreContact_CustomerID_ContactID
+| Contact (store employee) identification number. Foreign key to Contact.ContactID.<br />PK_StoreContact_CustomerID_ContactIDIX_StoreContact_ContactID
-| IX_StoreContact_ContactID
+|- valign="top"
 | ContactTypeID
 | int
 | not null
+|
+| Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.<br />IX_StoreContact_ContactTypeID
-| IX_StoreContact_ContactTypeID
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_StoreContact_rowguid
-| AK_StoreContact_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 76: / Line 73: @@
 | CustomerID
 |}
 == automatically generated ==

@@ Line 83: / Line 83: @@
 | Sales.StoreContact
 |- valign="top"
 | '''Description
 | Cross-reference table mapping stores and their employees.
 |-
 |}

@@ Line 151: / Line 151: @@
 | CustomerID
 | CustomerID
 |}
@@ Line 159: / Line 172: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]