Org Relations Table Schema (org_relations)


Description

Tracks relationships between organisations

org_relations table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
description LONGTEXT 2147483647 √ null
id1 BIGINT 19 null
org.id orgrela_id12_fk R
id2 BIGINT 19 null
org.id orgrela_id22_fk R

Table contained -1 rows

org_relations table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
orgrela_id1_ix Performance Asc id1
orgrela_id2_ix Performance Asc id2

org_relations table relationships

Close relationships within degrees of separation