Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
||||||
| left_type | int4 | 10 | null |
|
|
||||||
| right_type | int4 | 10 | null |
|
|
||||||
| leftward_type | varchar | 32 | null |
|
|
||||||
| rightward_type | varchar | 32 | null |
|
|
||||||
| left_min_cardinality | int4 | 10 | √ | null |
|
|
|||||
| left_max_cardinality | int4 | 10 | √ | null |
|
|
|||||
| right_min_cardinality | int4 | 10 | √ | null |
|
|
|||||
| right_max_cardinality | int4 | 10 | √ | null |
|
|
|||||
| copy_to_left | bool | 1 | false |
|
|
||||||
| copy_to_right | bool | 1 | false |
|
|
||||||
| tilted | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| relationship_type_pkey | Primary key | Asc | id |
| relationship_type_by_left_label_idx | Performance | Asc | leftward_type |
| relationship_type_by_left_type_idx | Performance | Asc | left_type |
| relationship_type_by_right_label_idx | Performance | Asc | rightward_type |
| relationship_type_by_right_type_idx | Performance | Asc | right_type |
| u_relationship_type_constraint | Must be unique | Asc/Asc/Asc/Asc | left_type + right_type + leftward_type + rightward_type |
Relationships
Close relationships within degrees of separation
