group_okr_nodes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('okr.group_okr_nodes_id_seq'::regclass)
okr_node_id int8 19 null
okr_nodes.id fk_group_okr_nodes_okr_nodesC
group_id int8 19 null
groups.id fk_group_okr_nodes_groupsC
organization_id int8 19 null
organizations.id fk_group_okr_nodes_organizationsC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
group_okr_nodes_pkey Primary key Asc id
idx_group_okr_nodes_on_group_id Performance Asc group_id
idx_group_okr_nodes_on_group_id_and_okr_node_id Must be unique Asc/Asc group_id + okr_node_id
idx_group_okr_nodes_on_okr_node_id Performance Asc okr_node_id
idx_group_okr_nodes_on_organization_id Performance Asc organization_id

Relationships