Tabelas
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. |
|
|
|
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. |
|