action.fieldset_group

↑ action schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.usr, actor.org_unit, action.fieldset_group.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: fieldset_group_creator_fkey, fieldset_group_owning_lib_fkey, fieldset_group_rollback_group_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('action.fieldset_group_id_seq'::regclass)

name

text

No

create_time

timestamp with time zone

No

now()

complete_time

timestamp with time zone

Yes

container

integer

Yes

container_type

text

Yes

can_rollback

boolean

Yes

true

rollback_group FK

integer

Yes

→ action.fieldset_group(id)

rollback_time

timestamp with time zone

Yes

creator FK

integer

No

→ actor.usr(id)

owning_lib FK

integer

No

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

creator

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

fieldset_group_creator_fkey

owning_lib

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

fieldset_group_owning_lib_fkey

rollback_group

action.fieldset_group(id)

CASCADE

NO ACTION

DEFERRED

fieldset_group_rollback_group_fkey

Indexes

Index Method Definition

fieldset_group_pkey PK

btree

CREATE UNIQUE INDEX fieldset_group_pkey ON action.fieldset_group USING btree (id)

Referenced By

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

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

action.fieldset

fieldset_group

id

fieldset_fieldset_group_fkey

action.fieldset_group

rollback_group

id

fieldset_group_rollback_group_fkey
Previous
Next