action.fieldset

↑ action schema

Cascading Deletes: Deleting rows from this table will cascade to: action.fieldset_group.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: fieldset_fieldset_group_fkey, fieldset_owner_fkey, fieldset_owning_lib_fkey, fieldset_stored_query_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('action.fieldset_id_seq'::regclass)

fieldset_group FK

integer

Yes

→ action.fieldset_group(id)

owner FK

integer

No

→ actor.usr(id)

owning_lib FK

integer

No

→ actor.org_unit(id)

status

text

No

creation_time

timestamp with time zone

No

now()

scheduled_time

timestamp with time zone

Yes

applied_time

timestamp with time zone

Yes

classname

text

No

name

text

No

error_msg

text

Yes

stored_query FK

integer

Yes

→ query.stored_query(id)

pkey_value

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

fieldset_group

action.fieldset_group(id)

CASCADE

NO ACTION

DEFERRED

fieldset_fieldset_group_fkey

owner

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

fieldset_owner_fkey

owning_lib

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

fieldset_owning_lib_fkey

stored_query

query.stored_query(id)

NO ACTION

NO ACTION

DEFERRED

fieldset_stored_query_fkey

Unique Constraints

  • lib_name_unique: (owning_lib, name)

Check Constraints

  • fieldset_one_or_the_other: CHECK ((stored_query IS NOT NULL) AND (pkey_value IS NULL OR pkey_value IS NOT NULL) AND (stored_query IS NULL))

  • valid_status: CHECK status = ANY (ARRAY['PENDING'::text, 'APPLIED'::text, 'ERROR'::text])

Indexes

Index Method Definition

fieldset_pkey PK

btree

CREATE UNIQUE INDEX fieldset_pkey ON action.fieldset USING btree (id)

lib_name_unique UNIQUE

btree

CREATE UNIQUE INDEX lib_name_unique ON action.fieldset USING btree (owning_lib, name)

action_fieldset_sched_time_idx

btree

CREATE INDEX action_fieldset_sched_time_idx ON action.fieldset USING btree (scheduled_time)

action_owner_idx

btree

CREATE INDEX action_owner_idx ON action.fieldset USING btree (owner)

Referenced By

The following tables have foreign keys pointing to action.fieldset (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

action.fieldset_col_val

fieldset

id

fieldset_col_val_fieldset_fkey
Previous
Next