# MySQL # cofre_users #### **Table name:** cofre\_users **Description:** Table to store users registered in the Cofre Platform
**Field** **Type** **Description** **API**
**ID** Integer Sequential number of the registry in the table.
**name** String User’s name.
**msisdn** String User’s mobile phone.
**email** String User’s email address.
**cpf** String User’s CPF.
**password** String User’s password (encrypted).
**identifier** String An unique identification of the user supplied by Cofre before submit a customer creation to Salt Edge
**saltedge\_customer\_id** Integer An identification of the customer supplied by Salt Edge when the customer was created A Customer represents a single end-user of the Account Information API. The customer uses the API to create Connections, i.e. bank connections, that are further used to aggregate the customer's financial data. https://www.saltedge.com/api/v5/customers
**saltedge\_secret** String A secret generated by Salt Edge when the customer was created. https://www.saltedge.com/api/v5/customers
**uuid** String UUID generated by Google Firebase. Used for identify the user in sign-in process.
**pin** String Personal Identification Number (6 digits) for mobile phone or email validation. It will be used for register process or password recovery.
**status** Integer Status of the user for the Cofre platform. User’s status could be: 0 – Inactive 1 – Active 2 – Suspended
**datainsert** Timestamp Date and time when the registry was inserted in the table.
**dataupdate** Timestamp Date and time of the last update of the registry in the table.
# cofre_connections **Table name:** cofre\_connections **Description:** Table to store all Salte Edge users' connections.
**Field** **Type** **Description** **API**
**ID** Integer Sequential number of the registry in the table
**userID** Integer The id of the user in table cofre\_users
**saltedge\_connection\_id** String The id of the connection supplied by Salt Edge when the connection was created https://www.saltedge.com/api/v5/connections
**status** Integer Status of the connection for the Cofre platform A connection could be: 0 – Inactive 1 – Active 2 - Waiting **saltedge\_connection\_id**
**datainsert** Timestamp Date and time when the registry was inserted in the table
**dataupdate** Timestamp Date and time of the last update of the registry in the table
# cofre_providers **Table name:** cofre\_providers **Description:** Table to store all Salt Edge providers available for Cofre's users
**Field** **Type** **Description** **API**
**ID** Integer Sequential number of the registry in the table
**saltedge\_provider\_code** String The code of the provider https://www.saltedge.com/api/v5/providers
**provider\_name** String Given name (label) of the provider for front-end using
**saltedge\_logo\_url** String Image to identify the provider https://www.saltedge.com/api/v5/providers
**status** Integer Providers should be: 0 – Inactive (is not showed by the app) 1 – Active
**datainsert** Timestamp Date and time when the registry was inserted in the table
**dataupdate** Timestamp Date and time of the last update of the registry in the table
# cofre_accounts **Table name:** cofre\_accounts **Description:** Table to store the users' accounts
**Field** **Type** **Description** **API**
**ID** Integer Sequential number of the registry in the table
**connectionsID** Integer The id of the related connection in table cofre\_connections
**saltedge\_account\_id** String The id of the account https://www.saltedge.com/api/v5/accounts? connection\_id={connection.id}
**status** Integer Status of the user for the Cofre platform The accounts could be: 0 – Inactive 1 – Active
**datainsert** Timestamp Date and time when the registry was inserted in the table
**dataupdate** Timestamp Date and time of the last update of the registry in the table
# cofre_transactions **Table name:** cofre\_transactions **Description:** Table to store account transactions and savings
**Field** **Type** **Description** **API**
**ID** Integer Sequential number of the registry in the table.
**connectionsID** Integer The id of the related connection in table cofre\_connections.
**accountsID** Integer The id of the related account in table cofre\_accounts.
**saltedge\_transaction\_id** String The id of the transaction. Field `id` returned by the API. https://www.saltedge.com/api/v5/transactions?connection\_id={connection.id}&account\_id={account.id}
**saltedge\_amount** Decimal The amount of the transaction. Field `amount` returned by the API. https://www.saltedge.com/api/v5/transactions?connection\_id={connection.id}&account\_id={account.id}
**amount\_saved** Decimal The amount saved (AS): AS = saltedge\_amount \* percentage. The percentage is defined by the Cofre’s user.
**status** Integer Status of the transaction selected by the user to calculate a saving for the Cofre platform. Transactions could be: 0 – Selected, but not processed 1 – Saved 2 – Processing 3 – Technical error. Must be analysed 4 – Sent to payment gateway, but waiting response 5 – Not approved by payment gateway 6 – Retrieve asked by the user 7 – Retrieve processed
**saltedge\_made\_on** Datetime The date when the transaction was made. Field `made_on` returned by the API. https://www.saltedge.com/api/v5/transactions?connection\_id={connection.id}&account\_id={account.id}
**dt\_saving** DatetimeDate and time when the saving was responded by the payment gateway.
**dt\_retrieve** DatetimeDate and time when the user asked a retrieving.
**datainsert** Timestamp Date and time when the registry was inserted in the table.
**dataupdate** Timestamp Date and time of the last update of the registry in the table.
# cofre_users_parms **Table name:** cofre\_users\_parms **Description:** Table to store parameters for each user, like preferences, UI settings, percentage to saving etc.
**Field** **Type** **Description** **API**
**ID** Integer Sequential number of the registry in the table
**userID** Integer The id of the user in table cofre\_users
**category** String Where the parameter will be used. A category is keyword used to identify a set of data. **Examples:** SAVING, REGISTER, UI\_SETTINGS
**value** JSON JSON with all parameters referred to the category. **Example:** { “percentage”: 5.0, “amount\_max”: 1000.0 } All these key/values pair should be defined in another document.
**status** Integer A parameter could be: 0 – Inactive 1 – Active
**datainsert** Timestamp Date and time when the registry was inserted in the table
**dataupdate** Timestamp Date and time of the last update of the registry in the table