# cofre_users_parms

**Table name:** cofre\_users\_parms

**Description:** Table to store parameters for each user, like preferences, UI settings, percentage to saving etc.

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

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

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

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

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

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

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

</td><td style="width: 305px;"></td></tr><tr><td style="width: 117px;">**userID**

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

</td><td style="width: 301px;">The id of the user in table cofre\_users

</td><td style="width: 305px;"></td></tr><tr><td style="width: 117px;">**category**

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

</td><td style="width: 301px;">Where the parameter will be used. A category is keyword used to identify a set of data.  
  
**Examples:** SAVING, REGISTER, UI\_SETTINGS

</td><td style="width: 305px;"></td></tr><tr><td style="width: 117px;">**value**

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

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

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

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

</td><td style="width: 301px;">A parameter could be:  
0 – Inactive

1 – Active

</td><td style="width: 305px;"></td></tr><tr><td style="width: 117px;">**datainsert**

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

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

</td><td style="width: 305px;"></td></tr><tr><td style="width: 117px;">**dataupdate**

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

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

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