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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.CreditCard |- |} {| border="1" cellpadding="5" cellspacing="0" style="...)
 
Line 59: Line 59:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 +
| CreditCardID
 +
| CreditCardID
 +
|-
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
| CreditCardID
 +
| CreditCardID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.CreditCard
 +
|-
 +
 +
| '''Description
 +
| Customer credit card information.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

wikibot

Table Sales.CreditCard


Column Data Type Nullable Default PK Index
CreditCardID int not null PK_CreditCard_CreditCardID
CardType nvarchar(50) not null
CardNumber nvarchar(25) not null AK_CreditCard_CardNumber
ExpMonth tinyint not null
ExpYear smallint not null
ModifiedDate datetime not null (getdate())


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

automatically generated

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