Table: dbo.Bank_Feeds_Import
this table will store off the start date and the end date of the last retrieve. Also there will be data for the date and time of the last successful retrieve.["BR"]
Columns
Name | Type | Constraints | Description
checkbook_KEY | int (4) | NOT NULL | The primary key of this table is same as ACS checkbook key, because these dates would pertain to an acs bank account for which we are retrieving bank feeds data
last_import_start_time_utc | datetime (8, 3) | NOT NULL | The date and time of the last import start date when the transactions were retrieved
last_import_end_time_utc | datetime (8, 3) | NOT NULL | The date and time of the last import end date when the transactions were retrieved
last_update_time_utc | datetime (8, 3) | NOT NULL | The date and time of the last update when the transactions were retrieved
additional_information | nvarchar (160) | NOT NULL | A field in table to save information whether email was sent to the client to link an account.

Primary key
Name | Columns | Description
PK_Bank_Feeds_Import$checkbook_KEY | checkbook_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Feeds_Import__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |