Sales.CreditCard (table)

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales