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 |