org_unit_setting

-1 rows


Description

Org Unit settings

This table contains any arbitrary settings that a client program would like to save for an org unit.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('actor.org_unit_setting_id_seq'::regclass)
org_unit int4 10 null
org_unit.id org_unit_setting_org_unit_fkey C
name text 2147483647 null
org_unit_setting_type.name org_unit_setting_name_fkey R
value text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
org_unit_setting_pkey Primary key Asc id
actor_org_unit_setting_usr_idx Performance Asc org_unit
ou_once_per_key Must be unique Asc/Asc org_unit + name

Check Constraints

Constraint Name Constraint
aous_must_be_json (is_json(value))

Relationships

Close relationships within degrees of separation