Table: Ledger_Entry_Submittal
Columns
Name | Type | Constraints | Description
ledger_entry_KEY | int | NOT NULL | The ledger entry this submittal applies to.
submittal_status_KEY | int | NOT NULL | The status for this ledger entry.
credit_card_KEY | int |  | Credit card info used in this submittal.
update_date | datetime | NOT NULL |
update__staff_KEY | int | NOT NULL |
order_number | nvarchar (40) | NOT NULL | Unique order number assigned by the program
swipe | bit | NOT NULL | Indicates the user chose to swipe the card on Secure Pay through an external browser

Primary key
Name | Columns | Description
PK_Ledger_Entry_Submittal$ledger_entry_KEY | ledger_entry_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Ledger_Entry_Submittal$credit_card_KEY | credit_card_KEY | Index supports foreign key FK_Ledger_Entry_Submittal__Credit_Card__credit_card_KEY
IX_Ledger_Entry_Submittal$submittal_status_KEY | submittal_status_KEY | Index supports foreign key FK_Ledger_Entry_Submittal__Submittal_Status__submittal_status_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Ledger_Entry_Submittal__Credit_Card__credit_card_KEY | credit_card_KEY | Credit_Card |
FK_Ledger_Entry_Submittal__Ledger_Entry__ledger_entry_KEY | ledger_entry_KEY | Ledger_Entry | on delete cascade;
FK_Ledger_Entry_Submittal__Submittal_Status__submittal_status_KEY | submittal_status_KEY | Submittal_Status |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Ledger_Entry_Submittal_Result__Ledger_Entry_Submittal__ledger_entry_KEY | ledger_entry_KEY | Ledger_Entry_Submittal_Result | on delete cascade;