Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('gobs.indicator_id_seq'::regclass) |
|
|
ID |
|||||||||||||
| id_code | text | 2147483647 | null |
|
|
Short name |
||||||||||||||
| id_label | text | 2147483647 | null |
|
|
Title |
||||||||||||||
| id_description | text | 2147483647 | null |
|
|
Describes the indicator regarding its rôle inside the project. |
||||||||||||||
| id_date_format | text | 2147483647 | 'day'::text |
|
|
Help to know what is the format for the date. Example : ‘year’ |
||||||||||||||
| id_paths | text | 2147483647 | √ | null |
|
|
Paths given to help finding an indicator. They will be split up to fill the graph_node and r_indicator_node tables. If you need multiple paths, use | as a separator. Ex: Environment / Water resources | Measure / Physics / Water |
|||||||||||||
| id_category | text | 2147483647 | √ | null |
|
|
Category of the indicator. Used to group several indicators by themes. |
|||||||||||||
| created_at | timestamp | 29,6 | now() |
|
|
Creation timestamp |
||||||||||||||
| updated_at | timestamp | 29,6 | now() |
|
|
Last updated timestamp |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| indicator_pkey | Primary key | Asc | id |
| indicator_id_label_idx | Performance | Asc | id_code |
Relationships
Close relationships within degrees of separation
