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

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