# cofre_accounts

**Table name:** cofre\_accounts

**Description:** Table to store the users' accounts

<table id="bkmrk-field-type-descripti"><tbody><tr><td style="width: 149px;">**Field**

</td><td style="width: 86px;">**Type**

</td><td style="width: 168px;">**Description**

</td><td style="width: 406px;">**API**

</td></tr><tr><td style="width: 149px;">**ID**

</td><td style="width: 86px;">Integer

</td><td style="width: 168px;">Sequential number of the registry in the table

</td><td style="width: 406px;"></td></tr><tr><td style="width: 149px;">**connectionsID**

</td><td style="width: 86px;">Integer

</td><td style="width: 168px;">The id of the related connection in table cofre\_connections

</td><td style="width: 406px;"></td></tr><tr><td style="width: 149px;">**saltedge\_account\_id**

</td><td style="width: 86px;">String

</td><td style="width: 168px;">The id of the account

</td><td style="width: 406px;">https://www.saltedge.com/api/v5/accounts? connection\_id={connection.id}

</td></tr><tr><td style="width: 149px;">**status**

</td><td style="width: 86px;">Integer

</td><td style="width: 168px;">Status of the user for the Cofre platform

The accounts could be:

0 – Inactive

1 – Active

</td><td style="width: 406px;"></td></tr><tr><td style="width: 149px;">**datainsert**

</td><td style="width: 86px;">Timestamp

</td><td style="width: 168px;">Date and time when the registry was inserted in the table

</td><td style="width: 406px;"></td></tr><tr><td style="width: 149px;">**dataupdate**

</td><td style="width: 86px;">Timestamp

</td><td style="width: 168px;">Date and time of the last update of the registry in the table

</td><td style="width: 406px;"></td></tr></tbody></table>