Advertisement
chrissharp123

Untitled

Nov 19th, 2019
373
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.52 KB | None | 0 0
  1. Column | Type | Collation | Nullable | Default
  2. ----------------------+--------------------------+-----------+----------+------------------------------------------------
  3. id | integer | | not null | nextval('container.carousel_id_seq'::regclass)
  4. type | integer | | not null |
  5. owner | integer | | not null |
  6. name | text | | not null |
  7. bucket | integer | | |
  8. creator | integer | | not null |
  9. editor | integer | | not null |
  10. create_time | timestamp with time zone | | not null | now()
  11. edit_time | timestamp with time zone | | not null | now()
  12. age_filter | interval | | |
  13. owning_lib_filter | integer[] | | |
  14. copy_location_filter | integer[] | | |
  15. last_refresh_time | timestamp with time zone | | |
  16. active | boolean | | not null | true
  17. max_items | integer | | not null |
  18. Indexes:
  19. "carousel_pkey" PRIMARY KEY, btree (id)
  20. Foreign-key constraints:
  21. "carousel_bucket_fkey" FOREIGN KEY (bucket) REFERENCES container.biblio_record_entry_bucket(id)
  22. "carousel_creator_fkey" FOREIGN KEY (creator) REFERENCES actor.usr(id)
  23. "carousel_editor_fkey" FOREIGN KEY (editor) REFERENCES actor.usr(id)
  24. "carousel_owner_fkey" FOREIGN KEY (owner) REFERENCES actor.org_unit(id)
  25. "carousel_type_fkey" FOREIGN KEY (type) REFERENCES config.carousel_type(id)
  26. Referenced by:
  27. TABLE "container.carousel_org_unit" CONSTRAINT "carousel_org_unit_carousel_fkey" FOREIGN KEY (carousel) REFERENCES container.carousel(id) ON DELETE CASCADE
  28.  
  29. evergreen=# \d container.carousel
  30. container.carousel container.carousel_org_unit container.carousel_org_unit_pkey
  31. container.carousel_id_seq container.carousel_org_unit_id_seq container.carousel_pkey
  32. evergreen=# \d container.carousel
  33. container.carousel container.carousel_org_unit container.carousel_org_unit_pkey
  34. container.carousel_id_seq container.carousel_org_unit_id_seq container.carousel_pkey
  35. evergreen=# \d config.carousel_type;
  36. Table "config.carousel_type"
  37. Column | Type | Collation | Nullable | Default
  38. ---------------------------+---------+-----------+----------+--------------------------------------------------
  39. id | integer | | not null | nextval('config.carousel_type_id_seq'::regclass)
  40. name | text | | not null |
  41. automatic | boolean | | not null | true
  42. filter_by_age | boolean | | not null | false
  43. filter_by_copy_owning_lib | boolean | | not null | false
  44. filter_by_copy_location | boolean | | not null | false
  45. Indexes:
  46. "carousel_type_pkey" PRIMARY KEY, btree (id)
  47. Referenced by:
  48. 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