# cofre_users

#### **Table name:** cofre\_users

**Description:** Table to store users registered in the Cofre Platform

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

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

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

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

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

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

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

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**name**

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

</td><td style="width: 265px;">User’s name.

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**msisdn**

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

</td><td style="width: 265px;">User’s mobile phone.

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**email**

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

</td><td style="width: 265px;">User’s email address.

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**cpf**

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

</td><td style="width: 265px;">User’s CPF.

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**password**

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

</td><td style="width: 265px;">User’s password (encrypted).

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**identifier**

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

</td><td style="width: 265px;">An unique identification of the user supplied by Cofre before submit a customer creation to Salt Edge

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**saltedge\_customer\_id**

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

</td><td style="width: 265px;">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.

</td><td style="width: 292px;">https://www.saltedge.com/api/v5/customers

</td></tr><tr><td style="width: 184px;">**saltedge\_secret**

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

</td><td style="width: 265px;">A secret generated by Salt Edge when the customer was created.

</td><td style="width: 292px;">https://www.saltedge.com/api/v5/customers

</td></tr><tr><td style="width: 184px;">**uuid**

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

</td><td style="width: 265px;">UUID generated by Google Firebase. Used for identify the user in sign-in process.

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**pin**

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

</td><td style="width: 265px;">Personal Identification Number (6 digits) for mobile phone or email validation. It will be used for register process or password recovery.

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

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

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

User’s status could be:

0 – Inactive

1 – Active

2 – Suspended

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**datainsert**

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

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

</td><td style="width: 292px;"></td></tr><tr><td style="width: 184px;">**dataupdate**

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

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

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