fieldset

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('action.fieldset_id_seq'::regclass)
fieldset_col_val.fieldset fieldset_col_val_fieldset_fkey C
fieldset_group int4 10 √ null
fieldset_group.id fieldset_fieldset_group_fkey C
owner int4 10 null
usr.id fieldset_owner_fkey R
owning_lib int4 10 null
org_unit.id fieldset_owning_lib_fkey R
status text 2147483647 null
creation_time timestamptz 35,6 now()
scheduled_time timestamptz 35,6 √ null
applied_time timestamptz 35,6 √ null
classname text 2147483647 null
name text 2147483647 null
error_msg text 2147483647 √ null
stored_query int4 10 √ null
stored_query.id fieldset_stored_query_fkey R
pkey_value text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
fieldset_pkey Primary key Asc id
action_fieldset_sched_time_idx Performance Asc scheduled_time
action_owner_idx Performance Asc owner
lib_name_unique Must be unique Asc/Asc owning_lib + name

Check Constraints

Constraint Name Constraint
fieldset_one_or_the_other ((((stored_query IS NOT NULL) AND (pkey_value IS NULL)) OR ((pkey_value IS NOT NULL) AND (stored_query IS NULL))))
valid_status ((status = ANY (ARRAY['PENDING'::text, 'APPLIED'::text, 'ERROR'::text])))

Relationships

Close relationships within degrees of separation