Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| node_id | int8 | 19 | null |
|
|
||||||
| qual_id | int4 | 10 | null |
|
|
||||||
| value | text | 2147483647 | null |
|
|
||||||
| time_start | timestamp | 29,6 | √ | null |
|
|
|||||
| time_end | timestamp | 29,6 | √ | null |
|
|
|||||
| ref_id | int4 | 10 | √ | null |
|
|
|||||
| inherited | bool | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| node_quals_node_id_qual_id_idx | Performance | Asc/Asc | node_id + qual_id |
| node_quals_qual_id_ref_id_idx | Performance | Asc/Asc | qual_id + ref_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| only_trader_can_inherit_node_quals | ( CASE WHEN (get_node_type(node_id) <> 'TRADER'::text) THEN (NOT inherited) ELSE true END) |
| uppercase_values | ((value = upper(value))) |
Relationships
Close relationships within degrees of separation
