config.ui_staff_portal_page_entry

↑ config schema

Cascading Deletes: Deleting rows from this table will cascade to: config.ui_staff_portal_page_entry_type, actor.org_unit.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: cusppe_entry_type_fkey, cusppe_owner_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.ui_staff_portal_page_entry_id_seq'::regclass)

page_col

integer

No

col_pos

integer

No

entry_type FK

text

No

→ config.ui_staff_portal_page_entry_type(code)

label

text

Yes

image_url

text

Yes

target_url

text

Yes

url_newtab

boolean

Yes

entry_text

text

Yes

owner FK

integer

No

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

entry_type

config.ui_staff_portal_page_entry_type(code)

CASCADE

CASCADE

DEFERRED

cusppe_entry_type_fkey

owner

actor.org_unit(id)

CASCADE

CASCADE

DEFERRED

cusppe_owner_fkey

Indexes

Index Method Definition

ui_staff_portal_page_entry_pkey PK

btree

CREATE UNIQUE INDEX ui_staff_portal_page_entry_pkey ON config.ui_staff_portal_page_entry USING btree (id)
Previous
Next