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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.ContactCreditCard |- |} {| border="1" cellpadding="5" cellspacing="0" ...)
 
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''Table
 +
| Sales.ContactCreditCard
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
 +
|}
 +
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 +
|- valign="top"
 +
| ContactID
 +
| int
 +
| not null
 +
|
 +
| Customer identification number. Foreign key to Contact.ContactID.
 +
|- valign="top"
 +
| CreditCardID
 +
| int
 +
| not null
 +
|
 +
| Credit card identification number. Foreign key to CreditCard.CreditCardID.
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (getdate())
 +
| 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_ContactCreditCard_ContactID_CreditCardID
 +
| ContactID, CreditCardID
 +
|}
 +
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|- valign="top"
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
| ContactID
 +
| ContactID
 +
|- valign="top"
 +
| [[Sales.CreditCard_(table)|Sales.CreditCard]]
 +
| CreditCardID
 +
| CreditCardID
 +
|}
 +
 +
=== 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]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 87:
 
| '''Table
 
| '''Table
 
| Sales.ContactCreditCard
 
| Sales.ContactCreditCard
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 100:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| ContactID
 
| ContactID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ContactCreditCard_ContactID_CreditCardID
+
| Customer identification number. Foreign key to Contact.ContactID.<br />PK_ContactCreditCard_ContactID_CreditCardID
−
|
+
|- valign="top"
−
|-
 
 
| CreditCardID
 
| CreditCardID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ContactCreditCard_ContactID_CreditCardID
+
| Credit card identification number. Foreign key to CreditCard.CreditCardID.<br />PK_ContactCreditCard_ContactID_CreditCardID
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 57: Line 138:
 
| CreditCardID
 
| CreditCardID
 
| CreditCardID
 
| CreditCardID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 
|}
 
|}

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.ContactCreditCard_(table)&oldid=2659"