Sales CreditCard (table)

wikibot

TableSales.CreditCard
DescriptionCustomer credit card information.

Columns

ColumnData TypeNullableDefaultDescription
CreditCardIDintnot null Primary key for CreditCard records.
CardTypenvarchar(50)not null Credit card name.
CardNumbernvarchar(25)not null Credit card number.
ExpMonthtinyintnot null Credit card expiration month.
ExpYearsmallintnot null Credit card expiration year.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_CreditCard_CreditCardIDCreditCardID

Indexes

IndexTypeColumns
AK_CreditCard_CardNumberUniqueCardNumber

Detail Tables

Detail TableColumnReferencing Column
Sales.ContactCreditCardCreditCardIDCreditCardID
Sales.SalesOrderHeaderCreditCardIDCreditCardID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales