Difference between revisions of "Sales.CreditCard (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.CreditCard
 
| Sales.CreditCard
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Customer credit card information.
 
| Customer credit card information.
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
 
|- valign="top"
 
|- valign="top"
 
| CreditCardID
 
| CreditCardID
Line 64: Line 62:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| PK_CreditCard_CreditCardID
 
| PK_CreditCard_CreditCardID
 
| CreditCardID
 
| CreditCardID
Line 75: Line 73:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| AK_CreditCard_CardNumber
 
| AK_CreditCard_CardNumber
 
| Unique
 
| Unique
Line 88: Line 86:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 
| CreditCardID
 
| CreditCardID
 
| CreditCardID
 
| CreditCardID
|-
+
|- valign="top"
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
| CreditCardID
 
| CreditCardID
Line 106: Line 104:
 
| '''Referenced Object
 
| '''Referenced Object
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Schema
 
| Schema

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Sales.CreditCard
Description Customer credit card information.

Columns[edit]

Column Data Type Nullable Default Description
CreditCardID int not null Primary key for CreditCard records.
CardType nvarchar(50) not null Credit card name.
CardNumber nvarchar(25) not null Credit card number.
ExpMonth tinyint not null Credit card expiration month.
ExpYear smallint not null Credit card expiration year.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_CreditCard_CreditCardID CreditCardID

Indexes[edit]

Index Type Columns
AK_CreditCard_CardNumber Unique CardNumber

Detail Tables[edit]

Detail Table Column Referencing Column
Sales.ContactCreditCard CreditCardID CreditCardID
Sales.SalesOrderHeader CreditCardID CreditCardID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

Table Sales.CreditCard
Description Customer credit card information.


Column Data Type Nullable Default Description / PK / Index
CreditCardID int not null Primary key for CreditCard records.
PK_CreditCard_CreditCardID
CardType nvarchar(50) not null Credit card name.
CardNumber nvarchar(25) not null Credit card number.
AK_CreditCard_CardNumber
ExpMonth tinyint not null Credit card expiration month.
ExpYear smallint not null Credit card expiration year.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Sales.ContactCreditCard CreditCardID CreditCardID
Sales.SalesOrderHeader CreditCardID CreditCardID


Dependency Type Object Type Referenced Object
Schema Schema Sales