Table: Credit_Card | |||
Columns | |||
Name | Type | Constraints | Description |
credit_card_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned key for this record. |
credit_card_type_KEY | int | NOT NULL | Database assigned key for this credit card type. |
cardholder_name | nvarchar (50) | NOT NULL | Credit card holder name. |
billing_name | nvarchar (50) | NOT NULL | Name on billing information. |
billing__address_KEY | int | NOT NULL | Billing address. |
update_date_utc | datetime | NOT NULL | |
update__staff_KEY | int | NOT NULL | |
expiration_month | int | NOT NULL | Credit card expiration date month |
expiration_year | int | NOT NULL | Credit card expiration date year |
Primary key | |||
Name | Columns | Description | |
PK_Credit_Card$credit_card_KEY | credit_card_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Credit_Card$billing__address_KEY | billing__address_KEY | Index supports foreign key FK_Credit_Card__Address__billing__address_KEY | |
IX_Credit_Card$credit_card_type_KEY | credit_card_type_KEY | Index supports foreign key FK_Credit_Card__Credit_Card_Type__credit_card_type_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Credit_Card__Address__billing__address_KEY | billing__address_KEY | Address | |
FK_Credit_Card__Credit_Card_Type__credit_card_type_KEY | credit_card_type_KEY | Credit_Card_Type |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Ledger_Entry_Submittal__Credit_Card__credit_card_KEY | credit_card_KEY | Ledger_Entry_Submittal |