Sales.CreditCard Table

Description

Customer credit card information.

Properties

Creation Date	17/07/2014 16:11
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	19118
Data Space Used	1,496.00 KB
Index Space Used	832.00 KB

Columns

Column Name	Description	Datatype	Length	Default
CreditCardID	Primary key for CreditCard records.	Integer	4
CardType	Credit card name.	VarWChar	50
CardNumber	Credit card number.	VarWChar	25
ExpMonth	Credit card expiration month.	UnsignedTinyInt	1
ExpYear	Credit card expiration year.	SmallInt	2
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_CreditCard_CardNumber	Unique nonclustered index.
PK_CreditCard_CreditCardID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_PersonCreditCard_CreditCard_CreditCardID	Foreign key constraint referencing CreditCard.CreditCardID.
FK_SalesOrderHeader_CreditCard_CreditCardID	Foreign key constraint referencing CreditCard.CreditCardID.

Objects that depend on Sales.CreditCard

Database Object	Object Type	Description	Dep Level
iduSalesOrderDetail	Trigger	AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.	3
Sales.PersonCreditCard	Table	Cross-reference table mapping people to their credit card information in the CreditCard table.	1
Sales.SalesOrderDetail	Table	Individual products associated with a specific sales order. See SalesOrderHeader.	2
Sales.SalesOrderHeader	Table	General sales order information.	1
Sales.SalesOrderHeaderSalesReason	Table	Cross-reference table mapping sales orders to sales reason codes.	2
uSalesOrderHeader	Trigger	AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.	2
Sales.vSalesPersonSalesByFiscalYears	View	Uses PIVOT to return aggregated sales information for each sales representative.	2

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[CreditCard](
    [CreditCardID] [int] IDENTITY(1,1) NOT NULL,
    [CardType] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CardNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ExpMonth] [tinyint] NOT NULL,
    [ExpYear] [smallint] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_CreditCard_CreditCardID] PRIMARY KEY CLUSTERED 
(
    [CreditCardID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Sales].[CreditCard] ADD  CONSTRAINT [DF_CreditCard_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects

Sales Schema
AdventureWorks Database