Sales.CreditCard (table)

From dbscript Online Help
Jump to: navigation, search

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