toolbar

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('actor.toolbar_id_seq'::regclass)
ws int4 10 √ null
workstation.id toolbar_ws_fkey C
org int4 10 √ null
org_unit.id toolbar_org_fkey C
usr int4 10 √ null
usr.id toolbar_usr_fkey C
label text 2147483647 null
layout text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
toolbar_pkey Primary key Asc id
label_once_per_org Must be unique Asc/Asc org + label
label_once_per_usr Must be unique Asc/Asc usr + label
label_once_per_ws Must be unique Asc/Asc ws + label

Check Constraints

Constraint Name Constraint
layout_must_be_json (is_json(layout))
only_one_type ((((ws IS NOT NULL) AND (COALESCE(org, usr) IS NULL)) OR ((org IS NOT NULL) AND (COALESCE(ws, usr) IS NULL)) OR ((usr IS NOT NULL) AND (COALESCE(org, ws) IS NULL))))

Relationships

Close relationships within degrees of separation