Sales.CreditCard - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	CreditCard
Module	Sales

Customer credit card information.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		CreditCardID	int		Identity		Primary key for CreditCard records.
Primary key for CreditCard records. Identity
	2		CardType	nvarchar(50)				Credit card name.
Credit card name.
	3		CardNumber	nvarchar(25)				Credit card number.
Credit card number.
	4		ExpMonth	tinyint				Credit card expiration month.
Credit card expiration month.
	5		ExpYear	smallint				Credit card expiration year.
Credit card expiration year.
	6		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Sales.PersonCreditCard		Sales.CreditCard	Sales.PersonCreditCard.CreditCardID = Sales.CreditCard.CreditCardID	FK_PersonCreditCard_CreditCard_CreditCardID Foreign key constraint referencing CreditCard.CreditCardID.
Sales.PersonCreditCard.CreditCardID = Sales.CreditCard.CreditCardID Name: FK_PersonCreditCard_CreditCard_CreditCardID Foreign key constraint referencing CreditCard.CreditCardID.
Sales.SalesOrderHeader		Sales.CreditCard	Sales.SalesOrderHeader.CreditCardID = Sales.CreditCard.CreditCardID	FK_SalesOrderHeader_CreditCard_CreditCardID Foreign key constraint referencing CreditCard.CreditCardID.
Sales.SalesOrderHeader.CreditCardID = Sales.CreditCard.CreditCardID Name: FK_SalesOrderHeader_CreditCard_CreditCardID Foreign key constraint referencing CreditCard.CreditCardID.

Unique keys

	Key name	Columns	Description
	PK_CreditCard_CreditCardID	CreditCardID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_CreditCard_CardNumber	CardNumber	Unique nonclustered index.
Unique nonclustered index.

Used by

Name
Sales.CreditCard
Sales.PersonCreditCard
Sales.SalesOrderHeader

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56