Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| node_id | int8 | 19 | √ | null |
|
|
|||||
| name | text | 2147483647 | √ | null |
|
|
|||||
| is_default | bool | 1 | null |
|
|
||||||
| id | serial | 10 | √ | nextval('node_names_id_seq'::regclass) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| node_names_pkey | Primary key | Asc | id |
| node_has_at_most_one_default_name | Performance | Asc/Asc | is_default + node_id |
| node_names_is_default_idx | Performance | Asc | is_default |
| node_names_name_idx | Performance | Asc | name |
| node_names_node_id_idx | Performance | Asc | node_id |
| node_names_node_id_is_default_idx | Performance | Asc/Asc | node_id + is_default |
| unique_node_name | Must be unique | Asc/Asc | node_id + name |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| only_one_name_for_trader_nodes | ( CASE WHEN (get_node_type(node_id) <> 'TRADER'::text) THEN true ELSE is_default END) |
| unique_trader_labels | ( CASE WHEN ((get_node_type(node_id) <> 'TRADER'::text) OR (get_node_level(node_id) <> 2)) THEN true ELSE (NOT trader_label_already_exists(name, node_id)) END) |
| name_must_be_uppercase | ((upper(name) = name)) |
Relationships
Close relationships within degrees of separation
