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

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
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 ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 19: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
 
|- valign="top"
 
|- valign="top"
 
| CreditCardID
 
| CreditCardID
Line 58: Line 57:
 
|}
 
|}
  
 +
=== Primary Key ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| PK_CreditCard_CreditCardID
 
| PK_CreditCard_CreditCardID
 
| CreditCardID
 
| CreditCardID
 
|}
 
|}
  
 +
=== Indexes ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 72: Line 73:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| AK_CreditCard_CardNumber
 
| AK_CreditCard_CardNumber
 
| Unique
 
| Unique
Line 79: Line 80:
 
|}
 
|}
  
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 84: 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 95: Line 97:
 
|}
 
|}
  
 +
=== 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]]
 +
 +
|}
  
  

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