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

From dbscript Online Help
Jump to: navigation, search
 
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.ContactCreditCard
 
| Sales.ContactCreditCard
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.  
 
| Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.  
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
 
|- valign="top"
 
|- valign="top"
 
| ContactID
 
| ContactID
Line 46: Line 44:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| PK_ContactCreditCard_ContactID_CreditCardID
 
| PK_ContactCreditCard_ContactID_CreditCardID
 
| ContactID, CreditCardID
 
| ContactID, CreditCardID
Line 57: Line 55:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[Person.Contact_(table)|Person.Contact]]
 
| [[Person.Contact_(table)|Person.Contact]]
 
| ContactID
 
| ContactID
 
| ContactID
 
| ContactID
|-
+
|- valign="top"
 
| [[Sales.CreditCard_(table)|Sales.CreditCard]]
 
| [[Sales.CreditCard_(table)|Sales.CreditCard]]
 
| CreditCardID
 
| CreditCardID
Line 75: Line 73:
 
| '''Referenced Object
 
| '''Referenced Object
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Schema
 
| Schema

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Sales.ContactCreditCard
Description Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.

Columns[edit]

Column Data Type Nullable Default Description
ContactID int not null Customer identification number. Foreign key to Contact.ContactID.
CreditCardID int not null Credit card identification number. Foreign key to CreditCard.CreditCardID.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_ContactCreditCard_ContactID_CreditCardID ContactID, CreditCardID

Foreign Keys[edit]

Relation Column Referenced Column
Person.Contact ContactID ContactID
Sales.CreditCard CreditCardID CreditCardID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

Table Sales.ContactCreditCard
Description Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.


Column Data Type Nullable Default Description / PK / Index
ContactID int not null Customer identification number. Foreign key to Contact.ContactID.
PK_ContactCreditCard_ContactID_CreditCardID
CreditCardID int not null Credit card identification number. Foreign key to CreditCard.CreditCardID.
PK_ContactCreditCard_ContactID_CreditCardID
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.Contact ContactID ContactID
Sales.CreditCard CreditCardID CreditCardID


Dependency Type Object Type Referenced Object
Schema Schema Sales