1 DROP SCHEMA container CASCADE;
4 CREATE SCHEMA container;
6 CREATE TABLE container.copy_bucket (
9 REFERENCES actor.usr (id)
15 btype TEXT NOT NULL DEFAULT 'misc',
16 CONSTRAINT cb_name_once_per_owner UNIQUE (owner,name,btype)
19 CREATE TABLE container.copy_bucket_item (
20 id SERIAL PRIMARY KEY,
22 REFERENCES container.copy_bucket (id)
27 target_copy INT NOT NULL
28 REFERENCES asset."copy" (id)
33 CONSTRAINT cb_cb_item_once_per_bucket UNIQUE (bucket,target_copy)
39 CREATE TABLE container.call_number_bucket (
40 id SERIAL PRIMARY KEY,
42 REFERENCES actor.usr (id)
48 btype TEXT NOT NULL DEFAULT 'misc',
49 CONSTRAINT cnb_name_once_per_owner UNIQUE (owner,name,btype)
52 CREATE TABLE container.call_number_bucket_item (
53 id SERIAL PRIMARY KEY,
55 REFERENCES container.call_number_bucket (id)
60 target_call_number INT NOT NULL
61 REFERENCES asset.call_number (id)
66 CONSTRAINT cnb_item_once_per_bucket UNIQUE (bucket,target_call_number)
72 CREATE TABLE container.biblio_record_entry_bucket (
73 id SERIAL PRIMARY KEY,
75 REFERENCES actor.usr (id)
81 btype TEXT NOT NULL DEFAULT 'misc',
82 CONSTRAINT breb_name_once_per_owner UNIQUE (owner,name,btype)
85 CREATE TABLE container.biblio_record_entry_bucket_item (
86 id SERIAL PRIMARY KEY,
88 REFERENCES container.biblio_record_entry_bucket (id)
93 target_biblio_record_entry INT NOT NULL
94 REFERENCES biblio.record_entry (id)
99 CONSTRAINT breb_item_once_per_bucket UNIQUE (bucket,target_biblio_record_entry)
105 CREATE TABLE container.user_bucket (
106 id SERIAL PRIMARY KEY,
108 REFERENCES actor.usr (id)
114 btype TEXT NOT NULL DEFAULT 'misc',
115 CONSTRAINT ub_name_once_per_owner UNIQUE (owner,name,btype)
118 CREATE TABLE container.user_bucket_item (
119 id SERIAL PRIMARY KEY,
121 REFERENCES container.user_bucket (id)
126 target_user INT NOT NULL
127 REFERENCES actor.usr (id)
132 CONSTRAINT ub_item_once_per_bucket UNIQUE (bucket,target_user)