| id |
int(11)
|
|
|
|
| template_id |
int(11)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| estimated_value |
decimal(10,2)
|
|
|
|
| frequency |
enum('Diario', 'Semanal', 'Mensual', 'Trimestral', 'Anual')
|
utf8mb4_general_ci
|
|
|
| responsible_user |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| objective |
text
|
utf8mb4_general_ci
|
|
|
| calculation_formula |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| baseline |
decimal(10,2)
|
|
|
|
| threshold_green |
decimal(10,2)
|
|
|
|
| threshold_yellow |
decimal(10,2)
|
|
|
|
| threshold_direction |
enum('ASC', 'DESC', 'RANGE')
|
utf8mb4_general_ci
|
|
|
| category_id |
int(11)
|
|
|
|
| share_token |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| objective_id |
int(11)
|
|
|
Browse foreign values
|
| unique_code |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| unit_of_measurement |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| data_source |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| collection_method |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| calculation_responsible |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| organizational_level_id |
int(11)
|
|
|
|
| status |
enum('Activo', 'Obsoleto', 'En Revisi├│n')
|
utf8mb4_general_ci
|
|
|