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