1 DROP SCHEMA container CASCADE;
4 CREATE SCHEMA container;
6 CREATE TABLE container.copy_bucket (
9 REFERENCES actor.usr (id)
15 CONSTRAINT cb_name_once_per_owner UNIQUE (owner,name)
18 CREATE TABLE container.copy_bucket_item (
19 id SERIAL PRIMARY KEY,
21 REFERENCES container.copy_bucket (id)
26 target_copy INT NOT NULL
27 REFERENCES asset."copy" (id)
32 CONSTRAINT cb_cb_item_once_per_bucket UNIQUE (bucket,target_copy)
38 CREATE TABLE container.call_number_bucket (
39 id SERIAL PRIMARY KEY,
41 REFERENCES actor.usr (id)
47 CONSTRAINT cnb_name_once_per_owner UNIQUE (owner,name)
50 CREATE TABLE container.call_number_bucket_item (
51 id SERIAL PRIMARY KEY,
53 REFERENCES container.call_number_bucket (id)
58 target_call_number INT NOT NULL
59 REFERENCES asset.call_number (id)
64 CONSTRAINT cnb_item_once_per_bucket UNIQUE (bucket,target_call_number)
70 CREATE TABLE container.biblio_record_entry_bucket (
71 id SERIAL PRIMARY KEY,
73 REFERENCES actor.usr (id)
79 CONSTRAINT breb_name_once_per_owner UNIQUE (owner,name)
82 CREATE TABLE container.biblio_record_entry_bucket_item (
83 id SERIAL PRIMARY KEY,
85 REFERENCES container.biblio_record_entry_bucket (id)
90 target_biblio_record_entry INT NOT NULL
91 REFERENCES biblio.record_entry (id)
96 CONSTRAINT breb_item_once_per_bucket UNIQUE (bucket,target_biblio_record_entry)
102 CREATE TABLE container.user_bucket (
103 id SERIAL PRIMARY KEY,
105 REFERENCES actor.usr (id)
111 CONSTRAINT ub_name_once_per_owner UNIQUE (owner,name)
114 CREATE TABLE container.user_bucket_item (
115 id SERIAL PRIMARY KEY,
117 REFERENCES container.user_bucket (id)
122 target_user INT NOT NULL
123 REFERENCES actor.usr (id)
128 CONSTRAINT ub_item_once_per_bucket UNIQUE (bucket,target_user)