Ir para o conteúdo principal

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