Table: dbo.Bank
Data about banks is stored here. Bank_View exists and, as of 3004.75.120 limits the columns returned, so columns which should surface on the entity should be added there.
Columns
Name | Type | Constraints | Description
bank_KEY | int (4) | NOT NULL | Primary key for this table.
bank_name | nvarchar (100) | NOT NULL | Name of bank.
routing_number | nvarchar (18) | NOT NULL | Bank routing number
fractional_routing_number | nvarchar (24) | NOT NULL | Bank fractional routing number
comments | nvarchar (-1) |  | Comments about bank.
contact_KEY | int (4) | NOT NULL | Key of contact record associated with the bank.
record_status_KEY | int (4) | NOT NULL | The status of the Bank record.
is_international_bank | bit (1) | NOT NULL | Flag indicating this is an international bank.
existing_bad_data | bit (1) | NOT NULL | Existing bad data for the routing number based on the latest check constraint for the routing number
restrict_bank_client_access | bit (1) | NOT NULL | The default value 0 indicates that client access program users can interact with this bank normally 1 means that client access program users will be unable to view details of this bank or select it

Primary key
Name | Columns | Description
PK_Bank | bank_KEY |
Unique constraints
Name | Columns | Description
UK_Bank$contact_KEY | contact_KEY |
UK_Bank$routing_number | routing_number |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |
FK_Bank__Record_Status__record_status_KEY | record_status_KEY | Record_Status (record_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Agent_Direct_Deposit_Allocation__Bank__bank_KEY | bank_KEY | Tax_Agent_Direct_Deposit_Allocation |
FK_Tax_Agent_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEY | us_gateway_operator__bank_KEY | Tax_Agent_Direct_Deposit_Allocation |
FK_Spreadsheet_Import_Bank_Routing_Number__Bank__bank_KEY | bank_KEY | Spreadsheet_Import_Bank_Routing_Number |
FK_Recorded_Event_Object_N_Bank__Bank__bank_KEY | bank_KEY | Recorded_Event_Object_N_Bank |
FK_Checkbook__Bank__bank_KEY | bank_KEY | Checkbook |
FK_Client_Direct_Deposit__Bank__immediate_destination__bank_KEY | immediate_destination__bank_KEY | Client_Direct_Deposit |
FK_Client_Direct_Deposit__Bank__originator__bank_KEY | originator__bank_KEY | Client_Direct_Deposit |
FK_Vendor_Direct_Deposit_Allocation__Bank__bank_KEY | bank_KEY | Vendor_Direct_Deposit_Allocation |
FK_Vendor_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEY | us_gateway_operator__bank_KEY | Vendor_Direct_Deposit_Allocation |
FK_Direct_Deposit_Bank_Transaction_Allocation__Bank__bank_KEY | bank_KEY | Direct_Deposit_Bank_Transaction_Allocation |
FK_Direct_Deposit_Bank_Transaction_Allocation__Bank__us_gateway_operator__bank_KEY | us_gateway_operator__bank_KEY | Direct_Deposit_Bank_Transaction_Allocation |
FK_Employee_Direct_Deposit_Allocation__Bank__bank_KEY | bank_KEY | Employee_Direct_Deposit_Allocation |
FK_Employee_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEY | us_gateway_operator__bank_KEY | Employee_Direct_Deposit_Allocation |
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Bank__bank_KEY | bank_KEY | Employee_Payroll_Item_Direct_Deposit_Allocation |