Difference between revisions of "Sales.CreditCard (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.CreditCard |- |} {| border="1" cellpadding="5" cellspacing="0" style="...)
 
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''Table
 +
| Sales.CreditCard
 +
|- valign="top"
 +
| '''Description
 +
| Customer credit card information.
 +
|}
 +
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 +
|- valign="top"
 +
| CreditCardID
 +
| int
 +
| not null
 +
|
 +
| Primary key for CreditCard records.
 +
|- valign="top"
 +
| CardType
 +
| nvarchar(50)
 +
| not null
 +
|
 +
| Credit card name.
 +
|- valign="top"
 +
| CardNumber
 +
| nvarchar(25)
 +
| not null
 +
|
 +
| Credit card number.
 +
|- valign="top"
 +
| ExpMonth
 +
| tinyint
 +
| not null
 +
|
 +
| Credit card expiration month.
 +
|- valign="top"
 +
| ExpYear
 +
| smallint
 +
| not null
 +
|
 +
| Credit card expiration year.
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (getdate())
 +
| Date and time the record was last updated.
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_CreditCard_CreditCardID
 +
| CreditCardID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| AK_CreditCard_CardNumber
 +
| Unique
 +
| CardNumber
 +
|}
 +
 +
=== Detail Tables ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|- valign="top"
 +
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]]
 +
| CreditCardID
 +
| CreditCardID
 +
|- valign="top"
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
| CreditCardID
 +
| CreditCardID
 +
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 118:
 
| '''Table
 
| '''Table
 
| Sales.CreditCard
 
| Sales.CreditCard
 +
|- valign="top"
 +
| '''Description
 +
| Customer credit card information.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 131:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| CreditCardID
 
| CreditCardID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_CreditCard_CreditCardID
+
| Primary key for CreditCard records.<br />PK_CreditCard_CreditCardID
−
|
+
|- valign="top"
−
|-
 
 
| CardType
 
| CardType
 
| nvarchar(50)
 
| nvarchar(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Credit card name.<br />
−
|
+
|- valign="top"
−
|-
 
 
| CardNumber
 
| CardNumber
 
| nvarchar(25)
 
| nvarchar(25)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Credit card number.<br />AK_CreditCard_CardNumber
−
| AK_CreditCard_CardNumber
+
|- valign="top"
−
|-
 
 
| ExpMonth
 
| ExpMonth
 
| tinyint
 
| tinyint
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Credit card expiration month.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ExpYear
 
| ExpYear
 
| smallint
 
| smallint
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Credit card expiration year.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 78: Line 187:
 
| CreditCardID
 
| CreditCardID
 
| CreditCardID
 
| CreditCardID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 
|}
 
|}

Latest revision as of 00:17, 24 June 2010

wikibot[edit]

Table Sales.CreditCard
Description Customer credit card information.

Columns[edit]

Column Data Type Nullable Default Description
CreditCardID 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 not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_CreditCard_CreditCardID CreditCardID

Indexes[edit]

Index Type Columns
AK_CreditCard_CardNumber Unique CardNumber

Detail Tables[edit]

Detail Table Column Referencing Column
Sales.ContactCreditCard CreditCardID CreditCardID
Sales.SalesOrderHeader CreditCardID CreditCardID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

Table Sales.CreditCard
Description Customer credit card information.


Column Data Type Nullable Default Description / PK / Index
CreditCardID int not null Primary key for CreditCard records.
PK_CreditCard_CreditCardID
CardType nvarchar(50) not null Credit card name.
CardNumber nvarchar(25) not null Credit card number.
AK_CreditCard_CardNumber
ExpMonth tinyint not null Credit card expiration month.
ExpYear smallint not null Credit card expiration year.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Sales.ContactCreditCard CreditCardID CreditCardID
Sales.SalesOrderHeader CreditCardID CreditCardID


Dependency Type Object Type Referenced Object
Schema Schema Sales
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.CreditCard_(table)&oldid=2661"