Sales.PersonCreditCard - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	PersonCreditCard
Module	Sales

Cross-reference table mapping people to their credit card information in the CreditCard table.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			Person.Person	Business entity identification number. Foreign key to Person.BusinessEntityID.
Business entity identification number. Foreign key to Person.BusinessEntityID. References: Person.Person
	2		CreditCardID	int			Sales.CreditCard	Credit card identification number. Foreign key to CreditCard.CreditCardID.
Credit card identification number. Foreign key to CreditCard.CreditCardID. References: Sales.CreditCard
	3		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.PersonCreditCard		Person.Person	Sales.PersonCreditCard.BusinessEntityID = Person.Person.BusinessEntityID	FK_PersonCreditCard_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.
Sales.PersonCreditCard.BusinessEntityID = Person.Person.BusinessEntityID Name: FK_PersonCreditCard_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.

Unique keys

	Key name	Columns	Description
	PK_PersonCreditCard_BusinessEntityID_CreditCardID	BusinessEntityID, CreditCardID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Sales.PersonCreditCard
Person.Person
Sales.CreditCard

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