Sales.CreditCard

Table: 'Sales.CreditCard'

6 fields. 173 bytes.

Customer credit card information.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
CreditCardID	int identity		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			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.CreditCard'

Primary Key Name	Field Name
PK_CreditCard_CreditCardID	CreditCardID

There are no Foreign Keys for this table.

Indexes for table 'Sales.CreditCard', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_CreditCard_CreditCardID	Clustered index created by a primary key constraint.	Yes	Yes	CreditCardID
AK_CreditCard_CardNumber	Unique nonclustered index.	No	Yes	CardNumber

Triggers for table 'Sales.CreditCard', 1 item

Name	Description	Type	Enabled
uCreditCard	AFTER UPDATE trigger setting the ModifiedDate column in the CreditCard table to the current date.	after Update	Yes

Dependencies for table 'Sales.CreditCard', 1 item

Object Name	Type	Field Name
Sales.uCreditCard	trigger	N/A