Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Column | Type | Collation | Nullable | Default
- ----------------------+--------------------------+-----------+----------+------------------------------------------------
- id | integer | | not null | nextval('container.carousel_id_seq'::regclass)
- type | integer | | not null |
- owner | integer | | not null |
- name | text | | not null |
- bucket | integer | | |
- creator | integer | | not null |
- editor | integer | | not null |
- create_time | timestamp with time zone | | not null | now()
- edit_time | timestamp with time zone | | not null | now()
- age_filter | interval | | |
- owning_lib_filter | integer[] | | |
- copy_location_filter | integer[] | | |
- last_refresh_time | timestamp with time zone | | |
- active | boolean | | not null | true
- max_items | integer | | not null |
- Indexes:
- "carousel_pkey" PRIMARY KEY, btree (id)
- Foreign-key constraints:
- "carousel_bucket_fkey" FOREIGN KEY (bucket) REFERENCES container.biblio_record_entry_bucket(id)
- "carousel_creator_fkey" FOREIGN KEY (creator) REFERENCES actor.usr(id)
- "carousel_editor_fkey" FOREIGN KEY (editor) REFERENCES actor.usr(id)
- "carousel_owner_fkey" FOREIGN KEY (owner) REFERENCES actor.org_unit(id)
- "carousel_type_fkey" FOREIGN KEY (type) REFERENCES config.carousel_type(id)
- Referenced by:
- TABLE "container.carousel_org_unit" CONSTRAINT "carousel_org_unit_carousel_fkey" FOREIGN KEY (carousel) REFERENCES container.carousel(id) ON DELETE CASCADE
- evergreen=# \d container.carousel
- container.carousel container.carousel_org_unit container.carousel_org_unit_pkey
- container.carousel_id_seq container.carousel_org_unit_id_seq container.carousel_pkey
- evergreen=# \d container.carousel
- container.carousel container.carousel_org_unit container.carousel_org_unit_pkey
- container.carousel_id_seq container.carousel_org_unit_id_seq container.carousel_pkey
- evergreen=# \d config.carousel_type;
- Table "config.carousel_type"
- Column | Type | Collation | Nullable | Default
- ---------------------------+---------+-----------+----------+--------------------------------------------------
- id | integer | | not null | nextval('config.carousel_type_id_seq'::regclass)
- name | text | | not null |
- automatic | boolean | | not null | true
- filter_by_age | boolean | | not null | false
- filter_by_copy_owning_lib | boolean | | not null | false
- filter_by_copy_location | boolean | | not null | false
- Indexes:
- "carousel_type_pkey" PRIMARY KEY, btree (id)
- Referenced by:
- TABLE "container.carousel" CONSTRAINT "carousel_type_fkey" FOREIGN KEY (type) REFERENCES config.carousel_type(id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement