container.carousel

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('container.carousel_id_seq'::regclass)

type FK

integer

No

→ config.carousel_type(id)

owner FK

integer

No

→ actor.org_unit(id)

name

text

No

bucket FK

integer

Yes

→ container.biblio_record_entry_bucket(id)

creator FK

integer

No

→ actor.usr(id)

editor FK

integer

No

→ actor.usr(id)

create_time

timestamp with time zone

No

now()

edit_time

timestamp with time zone

No

now()

age_filter

interval

Yes

owning_lib_filter

integer[]

Yes

copy_location_filter

integer[]

Yes

last_refresh_time

timestamp with time zone

Yes

active

boolean

No

true

max_items

integer

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

bucket

container.biblio_record_entry_bucket(id)

NO ACTION

NO ACTION

No

carousel_bucket_fkey

creator

actor.usr(id)

NO ACTION

NO ACTION

No

carousel_creator_fkey

editor

actor.usr(id)

NO ACTION

NO ACTION

No

carousel_editor_fkey

owner

actor.org_unit(id)

NO ACTION

NO ACTION

No

carousel_owner_fkey

type

config.carousel_type(id)

NO ACTION

NO ACTION

No

carousel_type_fkey

Indexes

Index Method Definition

carousel_pkey PK

btree

CREATE UNIQUE INDEX carousel_pkey ON container.carousel USING btree (id)

Referenced By

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

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

container.carousel_org_unit

carousel

id

carousel_org_unit_carousel_fkey
Previous
Next