Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id1 | INTEGER | 2000000000 | null |
|
|
||||||
| id2 | INTEGER | 2000000000 | null |
|
|
||||||
| relationship_type_id | INTEGER | 2000000000 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| transfer_relationship_s_pk | Primary key | Asc/Asc/Asc | id1 + id2 + relationship_type_id |
| idx_transfer_relationship_id1 | Performance | Asc | id1 |
| idx_transfer_relationship_id2_type | Performance | Asc/Asc | id2 + relationship_type_id |
| idx_transfer_relationship_type | Performance | Asc | relationship_type_id |
| sqlite_autoindex_transfer_relationship_1 | Must be unique | Asc/Asc/Asc | id1 + id2 + relationship_type_id |
Relationships
Close relationships within degrees of separation
