Sales CreditCard (table)

wikibot ¶

Table	Sales.CreditCard
Description	Customer credit card information.

Columns ¶

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 ¶

Primary Key	Columns
PK_CreditCard_CreditCardID	CreditCardID

Indexes ¶

Index	Type	Columns
AK_CreditCard_CardNumber	Unique	CardNumber

Detail Tables ¶

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

References ¶

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales