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

From dbscript Online Help
Jump to: navigation, search
Line 18: Line 18:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''Description / PK / Index
+
| '''Description
 
 
 
|- valign="top"
 
|- valign="top"
Line 25: Line 25:
 
| not null
 
| not null
 
|  
 
|  
| Customer identification number. Foreign key to Contact.ContactID.<br />PK_ContactCreditCard_ContactID_CreditCardID
+
| Customer identification number. Foreign key to Contact.ContactID.
 
|- valign="top"
 
|- valign="top"
 
| CreditCardID
 
| CreditCardID
Line 31: Line 31:
 
| not null
 
| not null
 
|  
 
|  
| Credit card identification number. Foreign key to CreditCard.CreditCardID.<br />PK_ContactCreditCard_ContactID_CreditCardID
+
| Credit card identification number. Foreign key to CreditCard.CreditCardID.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 37: Line 37:
 
| not null
 
| not null
 
| (getdate())
 
| (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"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| PK_ContactCreditCard_ContactID_CreditCardID
 +
| ContactID, CreditCardID
 +
|}
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"

Revision as of 22:36, 2 February 2010

wikibot

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
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 Columns
PK_ContactCreditCard_ContactID_CreditCardID ContactID, CreditCardID
Relation Column Referenced Column
Person.Contact ContactID ContactID
Sales.CreditCard CreditCardID CreditCardID


automatically generated

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