From 691f0148907c4174199c13815d49ee520e7eb7a5 Mon Sep 17 00:00:00 2001 From: Robert Soulliere Date: Fri, 10 Sep 2010 12:00:25 -0400 Subject: [PATCH] Clean up some of my admin docs. add schema.xml to repo. Add the docbook conversion script to tools directory. Add postgresql autodoc xml docbook template (xml.tmpl) to tools directory. --- 1.6/admin/requirements-configuration.xml | 2 +- 1.6/admin/serveradministration.xml | 554 +- 1.6/admin/z3950.xml | 19 +- 1.6/appendices/schema.xml | 43534 +++++++++++++++++++++ 1.6/intro/releasenotes.xml | 44 + 1.6/root.xml | 3 +- tools/docbookConvert.sh | 16 + tools/xml.tmpl | 129 + 8 files changed, 44016 insertions(+), 285 deletions(-) create mode 100644 1.6/appendices/schema.xml create mode 100755 tools/docbookConvert.sh create mode 100644 tools/xml.tmpl diff --git a/1.6/admin/requirements-configuration.xml b/1.6/admin/requirements-configuration.xml index a9295f0574..c1a4fb7268 100644 --- a/1.6/admin/requirements-configuration.xml +++ b/1.6/admin/requirements-configuration.xml @@ -44,7 +44,7 @@ The key to Evergreen scalability is in the openSRF configuration files /openils/conf/opensrf.xml and /openils/conf/opensrf_core.xml. By configuring these files, an administrator could cluster evergreen services over multiple hosts, change the host running a specific service - or change the host of the postgreSQL database. + or change the host of the PostgreSQL database. The default configuration of Evergreen in the installation instructions assumes a single localhost server setup. For more complex multi-server clustered configurations, some server administration and database administration experience or knowledge will be required. diff --git a/1.6/admin/serveradministration.xml b/1.6/admin/serveradministration.xml index 394e35de79..454d1b2c6e 100644 --- a/1.6/admin/serveradministration.xml +++ b/1.6/admin/serveradministration.xml @@ -109,7 +109,8 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati Select the Organization Unit Type and Parent Organization Unit. Check the Can Have Volumes and Copies check box if the - organization units of this type will have volumes and copies assigned to it.organization unitsvolumes and copies + organization units of this type will have volumes and copies assigned to it.organization unitsvolumes + and copies Check the OPAC Visible check box if you want this location to be visible in the OPAC for searching.Organization Unitsopac visible Click Save to save your new organizational unit. @@ -272,278 +273,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati -
- Adjusting Search Relevancy Rankings - - - This section describes indexed field weighting and matchpoint weighting, which - control relevance ranking in Evergreen catalog search results. Adjusting relevancy can only be completed through access to the Evergreen database as of version 1.6. - - In tuning search relevance, it is good practice to make incremental - adjustments, capture search logs, and assess results before making further - adjustments. - - - - - Indexed-field Weighting<indexterm><primary>relevancy</primary><secondary>indexed-field weighting</secondary></indexterm> - Indexed-field weighting is configured in the Evergreen database in the weight column - of the config.metabib_field table, which follows the other four columns in this table: - field_class, name, xpath, and format. - The following is one representative line from the config.metabib_field table: - author | conference | //mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']] | mods32 | 1 ) - The default value for index-field weights in config.metabib_field is 1. Adjust the - weighting of indexed fields to boost or lower the relevance score for matches on that - indexed field. The weight value may be increased or decreased by whole integers. - For example, by increasing the weight of the title-proper field from 1 to 2, a search - for jaguar would double the relevance for the book titled - Aimee and Jaguar than for a record with the term - jaguar in another indexed field. - - - Match point Weighting<indexterm><primary>relevancy</primary><secondary>match point weighting</secondary></indexterm> - Match point weighting provides another way to fine-tune Evergreen relevance ranking, - and is configured through floating-point multipliers in the multiplier column of the - search.relevance_adjustment table. - Weighting can be adjusted for one, more, or all multiplier fields in - search.relevance_adjustment. - You can adjust the following three matchpoints: - - - first_wordboosts relevance if the query is - one term long and matches the first term in the indexed field (search for twain, get a bonus for twain, mark - but not mark twain) - - - word_order increases relevance for words - matching the order of search terms, so that the results for the search legend suicide would match higher for the book Legend of a Suicide than for the book, - Suicide Legend - - - full_match boosts relevance when the full - query exactly matches the entire indexed field (after space, case, and diacritics are - normalized). So a title search for The Future of Ice - would get a relevance boost above Ice>Ages of the - Future. - - - Here are the default settings of the search.relevance_adjustment table: - - search.relevance_adjustment table - - - - field_class - name - bump_type - multiplier - - - - - author - conference - first_word - 1.5 - - - author - corporate - first_word - 1.5 - - - author - other - first_word - 1.5 - - - author - personal - first_word - 1.5 - - - keyword - keyword - word_order - 10 - - - series - seriestitle - first_word - 1.5 - - - series - seriestitle - full_match - 20 - - - title - abbreviated - first_word - 1.5 - - - title - abbreviated - full_match - 20 - - - title - abbreviated - word_order - 10 - - - title - alternative - first_word - 1.5 - - - title - alternative - full_match - 20 - - - title - alternative - word_order - 10 - - - title - proper - first_word - 1.5 - - - title - proper - full_match - 20 - - - title - proper - word_order - 10 - - - title - translated - first_word - 1.5 - - - title - translated - full_match - 20 - - - title - translated - word_order - 10 - - - title - uniform - first_word - 1.5 - - - title - uniform - full_match - 20 - - - title - uniform - word_order - 10 - - - -
- - - Combining Index Weighting and Match point Weighting - Index weighting and matchpoint weighting may be combined. The relevance boost of the combined - weighting is equal to the product of the two multiplied values. - If the relevance setting in the config.metabib_field were increased to 2, and the multiplier - set to 1.2 in the search.relevance_adjustment table, the resulting matchpoint increase would be - 240%. - - In practice, these weights are applied serially -- first the index weight, then all - the matchpoint weights that apply -- because they are evaluated at different stages of the - search process. - - - - Adjusting Relevancy for Keyword Searches<indexterm><primary>relevancy</primary><secondary>keyword searches</secondary></indexterm> - Searching the out of the box keyword does not boost the ranking for terms appearing in, the title or subject fields since there is just one - keyword index which does not distinguish terms that appear in the title field from those in the notes field for example. In comparison, the title index is actually composed of - a number of separate indexes: title|proper, title|uniform, title|alternative, title|translated, etc, that collectively form the title index. You can see this in the - config.metabib_field table. The following procedure will add a keyword|title index so that terms found in the title field of an item are given more weight than terms in - other fields. - - - From the command line, access the PostgreSQL command line interface - psql -U evergreen - - - Clone the title|proper index to create a keyword|title index - 6 = the title|proper index - INSERT INTO config.metabib_field - (field_class, name, xpath, weight, - format, search_field, facet_field) - SELECT 'keyword', 'title', xpath, weight, format, - search_field, facet_field - FROM config.metabib_field - WHERE id = 6; - - - Populate the keyword|title index with a set of index entries cloned from the metabib.title_field_entry table; - 6 = the title|proper index - INSERT INTO metabib.keyword_field_entry (source, field, value) - SELECT source, 17, value (the field value, 17, field be different - in your database so you may need to check the - config.metabib_field for the id of your new index). - FROM metabib.title_field_entry - WHERE field = 6; - - - Bump the relevance when the first search term appears first in the title in a keyword search. - 17 = our new keyword|title index (This may be different in your database so you may need to check the config.metabib_field for the id - of your new index). - INSERT INTO search.relevance_adjustment - (active, field, bump_type, multiplier) - VALUES (true, 17, 'first_word', 5); - - - Boost the relevance for search terms appearing in the title in general - 17 = our new keyword|title index (This may be different in your database so you may need to check the config.metabib_field for the id - of your new index). - UPDATE config.metabib_field - SET weight = 10 - WHERE id = 17; - - - -
+
User and Group Permissions <indexterm><primary>permissions</primary><secondary>group</secondary></indexterm> @@ -2005,4 +1735,282 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
+
+ Adjusting Search Relevancy Rankings + + + This section describes indexed field weighting and matchpoint weighting, which + control relevance ranking in Evergreen catalog search results. Adjusting relevancy can only be completed through access to the Evergreen database as of version 1.6. + + In tuning search relevance, it is good practice to make incremental + adjustments, capture search logs, and assess results before making further + adjustments. + + + + + Indexed-field Weighting<indexterm><primary>relevancy</primary><secondary>indexed-field weighting</secondary></indexterm> + Indexed-field weighting is configured in the Evergreen database in the weight column + of the config.metabib_field table, which follows the other four columns in this table: + field_class, name, xpath, and format. + The following is one representative line from the config.metabib_field table: + author | conference | //mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']] | mods32 | 1 ) + The default value for index-field weights in config.metabib_field is 1. Adjust the + weighting of indexed fields to boost or lower the relevance score for matches on that + indexed field. The weight value may be increased or decreased by whole integers. + For example, by increasing the weight of the title-proper field from 1 to 2, a search + for jaguar would double the relevance for the book titled + Aimee and Jaguar than for a record with the term + jaguar in another indexed field. + + + Match point Weighting<indexterm><primary>relevancy</primary><secondary>match point weighting</secondary></indexterm> + Match point weighting provides another way to fine-tune Evergreen relevance ranking, + and is configured through floating-point multipliers in the multiplier column of the + search.relevance_adjustment table. + Weighting can be adjusted for one, more, or all multiplier fields in + search.relevance_adjustment. + You can adjust the following three matchpoints: + + + first_wordboosts relevance if the query is + one term long and matches the first term in the indexed field (search for twain, get a bonus for twain, mark + but not mark twain) + + + word_order increases relevance for words + matching the order of search terms, so that the results for the search legend suicide would match higher for the book Legend of a Suicide than for the book, + Suicide Legend + + + full_match boosts relevance when the full + query exactly matches the entire indexed field (after space, case, and diacritics are + normalized). So a title search for The Future of Ice + would get a relevance boost above Ice>Ages of the + Future. + + + Here are the default settings of the search.relevance_adjustment table: + + search.relevance_adjustment table + + + + field_class + name + bump_type + multiplier + + + + + author + conference + first_word + 1.5 + + + author + corporate + first_word + 1.5 + + + author + other + first_word + 1.5 + + + author + personal + first_word + 1.5 + + + keyword + keyword + word_order + 10 + + + series + seriestitle + first_word + 1.5 + + + series + seriestitle + full_match + 20 + + + title + abbreviated + first_word + 1.5 + + + title + abbreviated + full_match + 20 + + + title + abbreviated + word_order + 10 + + + title + alternative + first_word + 1.5 + + + title + alternative + full_match + 20 + + + title + alternative + word_order + 10 + + + title + proper + first_word + 1.5 + + + title + proper + full_match + 20 + + + title + proper + word_order + 10 + + + title + translated + first_word + 1.5 + + + title + translated + full_match + 20 + + + title + translated + word_order + 10 + + + title + uniform + first_word + 1.5 + + + title + uniform + full_match + 20 + + + title + uniform + word_order + 10 + + + +
+ + + Combining Index Weighting and Match point Weighting + Index weighting and matchpoint weighting may be combined. The relevance boost of the combined + weighting is equal to the product of the two multiplied values. + If the relevance setting in the config.metabib_field were increased to 2, and the multiplier + set to 1.2 in the search.relevance_adjustment table, the resulting matchpoint increase would be + 240%. + + In practice, these weights are applied serially -- first the index weight, then all + the matchpoint weights that apply -- because they are evaluated at different stages of the + search process. + + + + Adjusting Relevancy for Keyword Searches<indexterm><primary>relevancy</primary><secondary>keyword searches</secondary></indexterm> + Searching the out of the box keyword does not boost the ranking for terms appearing in, the title or subject fields since there is just one + keyword index which does not distinguish terms that appear in the title field from those in the notes field for example. In comparison, the title index is actually composed of + a number of separate indexes: title|proper, title|uniform, title|alternative, title|translated, etc, that collectively form the title index. You can see this in the + config.metabib_field table. The following procedure will add a keyword|title index so that terms found in the title field of an item are given more weight than terms in + other fields. + + + From the command line, access the PostgreSQL command line interface + psql -U evergreen + + + Clone the title|proper index to create a keyword|title index + 6 = the title|proper index + + INSERT INTO config.metabib_field + (field_class, name, xpath, weight, format, search_field, facet_field) + SELECT 'keyword', 'title', xpath, weight, format, search_field, facet_field + FROM config.metabib_field + WHERE id = 6; + + + + Populate the keyword|title index with a set of index entries cloned from the metabib.title_field_entry table; + 6 = the title|proper index + + INSERT INTO metabib.keyword_field_entry + (source, field, value) + SELECT source, 17, value (the field value, 17, field be different in your database so you may need to check the + config.metabib_field for the id of your new index). + FROM metabib.title_field_entry + WHERE field = 6; + + + + Bump the relevance when the first search term appears first in the title in a keyword search. + 17 = our new keyword|title index (This may be different in your database so you may need to check the config.metabib_field for the id + of your new index). + + INSERT INTO search.relevance_adjustment + (active, field, bump_type, multiplier) + VALUES (true, 17, 'first_word', 5); + + + + Boost the relevance for search terms appearing in the title in general + 17 = our new keyword|title index (This may be different in your database so you may need to check the config.metabib_field for the id + of your new index). + + UPDATE config.metabib_field + SET weight = 10 + WHERE id = 17; + + + + +
diff --git a/1.6/admin/z3950.xml b/1.6/admin/z3950.xml index 79c77054c2..f2d99dd1b9 100644 --- a/1.6/admin/z3950.xml +++ b/1.6/admin/z3950.xml @@ -19,11 +19,10 @@ hostname: Some older versions of yaz-client have known issues with SRU. Ensure that you are using the latest edition of yaz from http://www.indexdata.com/yaz. - - $ yaz-client http://dev.gapines.org/opac/extras/sru - Z> sru GET 1.1 - Z> find hemingway - + $ yaz-client http://dev.gapines.org/opac/extras/sru + Z> sru GET 1.1 + Z> find hemingway + If your database has records that match that term, you will get the corresponding MARCXML records in your response from yaz-client. Here's what the SRU request looks like as sent to the Evergreen web server: GET /opac/extras/sru?version=1.1&operation=searchRetrieve&query=hemingway&maximumRecords=0 @@ -109,7 +108,7 @@ Create a Simple2ZOOM configuration file. Something like the following is a good start, and is based on the Simple2ZOOM documentation example. We'll name the file dgo.conf for our example: - + <client> <database name="gapines"> <zurl>http://dev.gapines.org/opac/extras/sru</zurl> @@ -128,7 +127,7 @@ </search> </database> </client> - + You can have multiple <database> sections in a single file, each pointing to a different scope of your consortium. The name attribute on the <database> element is used in your Z39.50 connection string to name the database. The <zurl> element must point to http://hostname/opac/extras/sru. As of Evergreen 1.6, you can append an optional organization unit shortname for search @@ -140,7 +139,7 @@ Run simple2ZOOM as a daemon, specifying the configuration files and one or more listener addresses that the Z39.50 server will be accessible on. If you do not specify a port, it will automatically run on port 9999. In the following example, we tell it to listen both to localhost on port 2210, and on dev.gapines.org on port 210: - + <yazgfs> <server id="server1"> <retrievalinfo> @@ -153,7 +152,7 @@ </retrievalinfo> </server> </yazgfs> - + Run simple2ZOOM as a daemon, specifying the configuration files and one or more listener addresses that the Z39.50 server will be accessible on. @@ -162,7 +161,7 @@ simple2zoom -c dgo.conf -- -f xml2marc-yaz.cfg localhost:2210 dev.gapines.org:210 - To test the Z39.50 server, we can use yaz-client again:] + To test the Z39.50 server, we can use yaz-client again: yaz-client Z> open localhost:2210/gapines diff --git a/1.6/appendices/schema.xml b/1.6/appendices/schema.xml new file mode 100644 index 0000000000..1496441ad6 --- /dev/null +++ b/1.6/appendices/schema.xml @@ -0,0 +1,43534 @@ + + + Database Schema + This is the schema for the Evergreen database. + +
+ Schema acq + + + currency_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + label + text + + + + + + + + + + + + + + + + + + Tables referencing acq.exchange_rate via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + distribution_formula + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + skip_count + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing acq.distribution_formula_entry via Foreign Key Constraints + + + + + + + + + + + + + + + + distribution_formula_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + formula + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + position + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + item_count + integer + + + + NOT NULL; + + + + + + + + owning_lib + integer + + + + + + + + + + + + + + + + + location + integer + + + + + + + + + + + + + + + + + + + + + + + Constraints on distribution_formula_entry + + + acqdfe_must_be_somewhere + CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL))) + + + + + + + + + + + + + exchange_rate + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + from_currency + text + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + to_currency + text + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + ratio + numeric + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + fiscal_calendar + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing acq.fiscal_year via Foreign Key Constraints + + + + + + + + + + + + + + + + fiscal_year + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + calendar + integer + + + + + UNIQUE#1 + ; + + + + + UNIQUE#2 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + year + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + year_begin + timestamp with time zone + + + + + UNIQUE#2 + ; + + + + NOT NULL; + + + + + + + + + + year_end + timestamp with time zone + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + fund + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + org + integer + + + + + UNIQUE#2 + ; + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + year + integer + + + + + UNIQUE#2 + ; + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT date_part('year'::text, now()); + + + + + + + + + + + currency_type + text + + + + + + + NOT NULL; + + + + + + + + + + + + code + text + + + + + UNIQUE#2 + ; + + + + + + + + + + + + + + + + + + + + Tables referencing acq.fund_allocation via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + fund_allocation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + funding_source + integer + + + + + + + NOT NULL; + + + + + + + + + + + + fund + integer + + + + + + + NOT NULL; + + + + + + + + + + + + amount + numeric + + + + + + + + + + percent + numeric + + + + + + + + + + allocator + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + Constraints on fund_allocation + + + allocation_amount_or_percent + CHECK ((((percent IS NULL) AND (amount IS NOT NULL)) OR ((percent IS NOT NULL) AND (amount IS NULL)))) + + + + + + fund_allocation_percent_check + CHECK (((percent IS NULL) OR ((percent >= 0.0) AND (percent <= 100.0)))) + + + + + + + + + + + + + fund_allocation_total + + + + + + + + Field + Data Type + Constraints and References + + + + + + fund + integer + + + + + + + + + + amount + numeric(100,2) + + + + + + + + + + + + + + + + + + + + + fund_combined_balance + + + + + + + + Field + Data Type + Constraints and References + + + + + + fund + integer + + + + + + + + + + amount + numeric + + + + + + + + + + + + + + + + + + + + + fund_debit + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + fund + integer + + + + + + + NOT NULL; + + + + + + + + + + + + origin_amount + numeric + + + + NOT NULL; + + + + + + + + origin_currency_type + text + + + + + + + NOT NULL; + + + + + + + + + + + + amount + numeric + + + + NOT NULL; + + + + + + + + encumbrance + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + debit_type + text + + + + NOT NULL; + + + + + + + + xfer_destination + integer + + + + + + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + Tables referencing acq.lineitem_detail via Foreign Key Constraints + + + + + + + + + + + + + + + + fund_debit_total + + + + + + + + Field + Data Type + Constraints and References + + + + + + fund + integer + + + + + + + + + + encumbrance + boolean + + + + + + + + + + amount + numeric + + + + + + + + + + + + + + + + + + + + + fund_encumbrance_total + + + + + + + + Field + Data Type + Constraints and References + + + + + + fund + integer + + + + + + + + + + amount + numeric + + + + + + + + + + + + + + + + + + + + + fund_spent_balance + + + + + + + + Field + Data Type + Constraints and References + + + + + + fund + integer + + + + + + + + + + amount + numeric + + + + + + + + + + + + + + + + + + + + + fund_spent_total + + + + + + + + Field + Data Type + Constraints and References + + + + + + fund + integer + + + + + + + + + + amount + numeric + + + + + + + + + + + + + + + + + + + + + fund_tag + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing acq.fund_tag_map via Foreign Key Constraints + + + + + + + + + + + + + + + + fund_tag_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + fund + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + tag + integer + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + funding_source + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + currency_type + text + + + + + + + NOT NULL; + + + + + + + + + + + + code + text + + + + + UNIQUE; + + + + + + + + + + + + + + + + + + + + Tables referencing acq.fund_allocation via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + funding_source_allocation_total + + + + + + + + Field + Data Type + Constraints and References + + + + + + funding_source + integer + + + + + + + + + + amount + numeric(100,2) + + + + + + + + + + + + + + + + + + + + + funding_source_balance + + + + + + + + Field + Data Type + Constraints and References + + + + + + funding_source + integer + + + + + + + + + + amount + numeric(100,2) + + + + + + + + + + + + + + + + + + + + + funding_source_credit + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + funding_source + integer + + + + + + + NOT NULL; + + + + + + + + + + + + amount + numeric + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + + + + + + + + + + + + funding_source_credit_total + + + + + + + + Field + Data Type + Constraints and References + + + + + + funding_source + integer + + + + + + + + + + amount + numeric + + + + + + + + + + + + + + + + + + + + + lineitem + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + creator + integer + + + + + + + NOT NULL; + + + + + + + + + + + + editor + integer + + + + + + + NOT NULL; + + + + + + + + + + + + selector + integer + + + + + + + NOT NULL; + + + + + + + + + + + + provider + integer + + + + + + + + + + + + + + + + + purchase_order + integer + + + + + + + + + + + + + + + + + picklist + integer + + + + + + + + + + + + + + + + + expected_recv_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + eg_bib_id + integer + + + + + + + + + + + + + + + + + source_label + text + + + + + + + + + + item_count + integer + + + + NOT NULL; + + + + + + + + state + text + + + + NOT NULL; + + + DEFAULT 'new'::text; + + + + + + + + + + + + + Constraints on lineitem + + + picklist_or_po + CHECK (((picklist IS NOT NULL) OR (purchase_order IS NOT NULL))) + + + + + + + + + + Tables referencing acq.lineitem_attr via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + lineitem_attr + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + definition + bigint + + + + NOT NULL; + + + + + + + + lineitem + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + attr_type + text + + + + NOT NULL; + + + + + + + + attr_name + text + + + + NOT NULL; + + + + + + + + attr_value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + lineitem_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + code + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + + + + lineitem_detail + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + lineitem + integer + + + + + + + NOT NULL; + + + + + + + + + + + + fund + integer + + + + + + + + + + + + + + + + + fund_debit + integer + + + + + + + + + + + + + + + + + eg_copy_id + bigint + + + + + + + + + + + + + + + + + barcode + text + + + + + + + + + + cn_label + text + + + + + + + + + + note + text + + + + + + + + + + collection_code + text + + + + + + + + + + circ_modifier + text + + + + + + + + + + + + + + + + + owning_lib + integer + + + + + + + + + + + + + + + + + location + integer + + + + + + + + + + + + + + + + + recv_time + timestamp with time zone + + + + + + + + + + + + + + + + + + + + + lineitem_generated_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('lineitem_attr_definition_id_seq'::regclass); + + + + + + + + + code + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + xpath + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + lineitem_local_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('lineitem_attr_definition_id_seq'::regclass); + + + + + + + + + code + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + + + + lineitem_marc_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('lineitem_attr_definition_id_seq'::regclass); + + + + + + + + + code + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + xpath + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + lineitem_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + lineitem + integer + + + + + + + NOT NULL; + + + + + + + + + + + + creator + integer + + + + + + + NOT NULL; + + + + + + + + + + + + editor + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + lineitem_provider_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('lineitem_attr_definition_id_seq'::regclass); + + + + + + + + + code + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + xpath + text + + + + NOT NULL; + + + + + + + + provider + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + lineitem_usr_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('lineitem_attr_definition_id_seq'::regclass); + + + + + + + + + code + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + picklist + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + creator + integer + + + + + + + NOT NULL; + + + + + + + + + + + + editor + integer + + + + + + + NOT NULL; + + + + + + + + + + + + org_unit + integer + + + + + + + NOT NULL; + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + Tables referencing acq.lineitem via Foreign Key Constraints + + + + + + + + + + + + + + + + po_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + purchase_order + integer + + + + + + + NOT NULL; + + + + + + + + + + + + creator + integer + + + + + + + NOT NULL; + + + + + + + + + + + + editor + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + provider + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + owner + integer + + + + + UNIQUE#2 + ; + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + currency_type + text + + + + + + + NOT NULL; + + + + + + + + + + + + code + text + + + + + UNIQUE#2 + ; + + + + NOT NULL; + + + + + + + + + + holding_tag + text + + + + + + + + + + + + + + + + + + Tables referencing acq.lineitem via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + provider_address + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + valid + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + address_type + text + + + + + + + + + + provider + integer + + + + + + + NOT NULL; + + + + + + + + + + + + street1 + text + + + + NOT NULL; + + + + + + + + street2 + text + + + + + + + + + + city + text + + + + NOT NULL; + + + + + + + + county + text + + + + + + + + + + state + text + + + + NOT NULL; + + + + + + + + country + text + + + + NOT NULL; + + + + + + + + post_code + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + provider_contact + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + provider + integer + + + + + + + NOT NULL; + + + + + + + + + + + + name + text + + + + + + + + + + role + text + + + + + + + + + + email + text + + + + + + + + + + phone + text + + + + + + + + + + + + + + + + + + Tables referencing acq.provider_contact_address via Foreign Key Constraints + + + + + + + + + + + + + + + + provider_contact_address + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + valid + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + address_type + text + + + + + + + + + + contact + integer + + + + + + + NOT NULL; + + + + + + + + + + + + street1 + text + + + + NOT NULL; + + + + + + + + street2 + text + + + + + + + + + + city + text + + + + NOT NULL; + + + + + + + + county + text + + + + + + + + + + state + text + + + + NOT NULL; + + + + + + + + country + text + + + + NOT NULL; + + + + + + + + post_code + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + provider_holding_subfield_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + provider + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + subfield + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + purchase_order + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + creator + integer + + + + + + + NOT NULL; + + + + + + + + + + + + editor + integer + + + + + + + NOT NULL; + + + + + + + + + + + + ordering_agency + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + provider + integer + + + + + + + NOT NULL; + + + + + + + + + + + + state + text + + + + NOT NULL; + + + DEFAULT 'new'::text; + + + + + + + order_date + timestamp with time zone + + + + + + + + + + name + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing acq.lineitem via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema action + + + aged_circulation + + + + + + + + Field + Data Type + Constraints and References + + + + + + usr_post_code + text + + + + + + + + + + usr_home_ou + integer + + + + NOT NULL; + + + + + + + + usr_profile + integer + + + + NOT NULL; + + + + + + + + usr_birth_year + integer + + + + + + + + + + copy_call_number + integer + + + + NOT NULL; + + + + + + + + copy_location + integer + + + + NOT NULL; + + + + + + + + copy_owning_lib + integer + + + + NOT NULL; + + + + + + + + copy_circ_lib + integer + + + + NOT NULL; + + + + + + + + copy_bib_record + bigint + + + + NOT NULL; + + + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + xact_start + timestamp with time zone + + + + NOT NULL; + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + target_copy + bigint + + + + NOT NULL; + + + + + + + + circ_lib + integer + + + + NOT NULL; + + + + + + + + circ_staff + integer + + + + NOT NULL; + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + NOT NULL; + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + NOT NULL; + + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + NOT NULL; + + + + + + + + desk_renewal + boolean + + + + NOT NULL; + + + + + + + + opac_renewal + boolean + + + + NOT NULL; + + + + + + + + duration_rule + text + + + + NOT NULL; + + + + + + + + recuring_fine_rule + text + + + + NOT NULL; + + + + + + + + max_fine_rule + text + + + + NOT NULL; + + + + + + + + stop_fines + text + + + + + + + + + + + + + + + + + + + + + all_circulation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr_post_code + text + + + + + + + + + + usr_home_ou + integer + + + + + + + + + + usr_profile + integer + + + + + + + + + + usr_birth_year + integer + + + + + + + + + + copy_call_number + bigint + + + + + + + + + + copy_location + integer + + + + + + + + + + copy_owning_lib + integer + + + + + + + + + + copy_circ_lib + integer + + + + + + + + + + copy_bib_record + bigint + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + target_copy + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + circ_staff + integer + + + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + + + + + + + desk_renewal + boolean + + + + + + + + + + opac_renewal + boolean + + + + + + + + + + duration_rule + text + + + + + + + + + + recuring_fine_rule + text + + + + + + + + + + max_fine_rule + text + + + + + + + + + + stop_fines + text + + + + + + + + + + + + + + + + + + + + + billable_circulations + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + target_copy + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + circ_staff + integer + + + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + + + + + + + desk_renewal + boolean + + + + + + + + + + opac_renewal + boolean + + + + + + + + + + duration_rule + text + + + + + + + + + + recuring_fine_rule + text + + + + + + + + + + max_fine_rule + text + + + + + + + + + + stop_fines + text + + + + + + + + + + + + + + + + + + + + + billable_cirulations + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + target_copy + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + circ_staff + integer + + + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + + + + + + + desk_renewal + boolean + + + + + + + + + + opac_renewal + boolean + + + + + + + + + + duration_rule + text + + + + + + + + + + recuring_fine_rule + text + + + + + + + + + + max_fine_rule + text + + + + + + + + + + stop_fines + text + + + + + + + + + + + + + + + + + + + + + circulation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('money.billable_xact_id_seq'::regclass); + + + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + xact_start + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + target_copy + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + circ_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + circ_staff + integer + + + + NOT NULL; + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + NOT NULL; + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + NOT NULL; + + + DEFAULT '1 day'::interval; + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + desk_renewal + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + opac_renewal + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + duration_rule + text + + + + NOT NULL; + + + + + + + + recuring_fine_rule + text + + + + NOT NULL; + + + + + + + + max_fine_rule + text + + + + NOT NULL; + + + + + + + + stop_fines + text + + + + + + + + + + + + + + + + Constraints on circulation + + + circulation_stop_fines_check + CHECK ((stop_fines = ANY (ARRAY['CHECKIN'::text, 'CLAIMSRETURNED'::text, 'LOST'::text, 'MAXFINES'::text, 'RENEW'::text, 'LONGOVERDUE'::text]))) + + + + + + + + + + + + + hold_copy_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + hold + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + target_copy + bigint + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + + + hold_notification + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + hold + integer + + + + + + + NOT NULL; + + + + + + + + + + + + notify_staff + integer + + + + + + + + + + + + + + + + + notify_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + method + text + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + + + + + + + + + + + + hold_request + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + request_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + capture_time + timestamp with time zone + + + + + + + + + + fulfillment_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + return_time + timestamp with time zone + + + + + + + + + + prev_check_time + timestamp with time zone + + + + + + + + + + expire_time + timestamp with time zone + + + + + + + + + + cancel_time + timestamp with time zone + + + + + + + + + + target + bigint + + + + NOT NULL; + + + + + + + + current_copy + bigint + + + + + + + + + + + + + + + + + fulfillment_staff + integer + + + + + + + + + + + + + + + + + fulfillment_lib + integer + + + + + + + + + + + + + + + + + request_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + requestor + integer + + + + + + + NOT NULL; + + + + + + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + selection_ou + integer + + + + NOT NULL; + + + + + + + + selection_depth + integer + + + + NOT NULL; + + + + + + + + pickup_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + hold_type + text + + + + NOT NULL; + + + + + + + + holdable_formats + text + + + + + + + + + + phone_notify + text + + + + + + + + + + email_notify + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + frozen + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + thaw_date + timestamp with time zone + + + + + + + + + + cancel_cause + integer + + + + + + + + + + cancel_note + text + + + + + + + + + + shelf_time + timestamp with time zone + + + + + + + + + + + + + + + + Constraints on hold_request + + + hold_request_hold_type_check + CHECK ((hold_type = ANY (ARRAY['M'::text, 'T'::text, 'V'::text, 'C'::text]))) + + + + + + + + + + Tables referencing action.hold_copy_map via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + hold_request_cancel_cause + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + label + text + + + + + UNIQUE; + + + + + + + + + + + + + + + + + + + + + + + hold_transit_copy + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + PRIMARY KEY + + + + + + DEFAULT nextval('transit_copy_id_seq'::regclass); + + + + + + + + + source_send_time + timestamp with time zone + + + + + + + + + + dest_recv_time + timestamp with time zone + + + + + + + + + + target_copy + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + source + integer + + + + NOT NULL; + + + + + + + + dest + integer + + + + NOT NULL; + + + + + + + + prev_hop + integer + + + + + + + + + + copy_status + integer + + + + NOT NULL; + + + + + + + + persistant_transfer + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + hold + integer + + + + + + + + + + + + + + + + + + + + + + + + + + + + in_house_use + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + item + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + staff + integer + + + + + + + NOT NULL; + + + + + + + + + + + + org_unit + integer + + + + + + + NOT NULL; + + + + + + + + + + + + use_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + + + non_cat_in_house_use + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + item_type + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + staff + integer + + + + + + + NOT NULL; + + + + + + + + + + + + org_unit + integer + + + + + + + NOT NULL; + + + + + + + + + + + + use_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + + + non_cataloged_circulation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + patron + integer + + + + + + + NOT NULL; + + + + + + + + + + + + staff + integer + + + + + + + NOT NULL; + + + + + + + + + + + + circ_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + item_type + integer + + + + + + + NOT NULL; + + + + + + + + + + + + circ_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + + + open_circulation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + target_copy + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + circ_staff + integer + + + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + + + + + + + desk_renewal + boolean + + + + + + + + + + opac_renewal + boolean + + + + + + + + + + duration_rule + text + + + + + + + + + + recuring_fine_rule + text + + + + + + + + + + max_fine_rule + text + + + + + + + + + + stop_fines + text + + + + + + + + + + + + + + + + + + + + + reservation_transit_copy + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + PRIMARY KEY + + + + + + DEFAULT nextval('transit_copy_id_seq'::regclass); + + + + + + + + + source_send_time + timestamp with time zone + + + + + + + + + + dest_recv_time + timestamp with time zone + + + + + + + + + + target_copy + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + source + integer + + + + NOT NULL; + + + + + + + + dest + integer + + + + NOT NULL; + + + + + + + + prev_hop + integer + + + + + + + + + + copy_status + integer + + + + NOT NULL; + + + + + + + + persistant_transfer + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + reservation + integer + + + + + + + + + + + + + + + + + + + + + + + + + + + + survey + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + start_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + end_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT (now() + '10 years'::interval); + + + + + + + usr_summary + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + opac + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + poll + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + required + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + name + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing action.survey_question via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + survey_answer + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + question + integer + + + + + + + NOT NULL; + + + + + + + + + + + + answer + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing action.survey_response via Foreign Key Constraints + + + + + + + + + + + + + + + + survey_question + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + survey + integer + + + + + + + NOT NULL; + + + + + + + + + + + + question + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing action.survey_answer via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + survey_response + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + response_group_id + integer + + + + + + + + + + usr + integer + + + + + + + + + + survey + integer + + + + + + + NOT NULL; + + + + + + + + + + + + question + integer + + + + + + + NOT NULL; + + + + + + + + + + + + answer + integer + + + + + + + NOT NULL; + + + + + + + + + + + + answer_date + timestamp with time zone + + + + + + + + + + effective_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + + + transit_copy + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + source_send_time + timestamp with time zone + + + + + + + + + + dest_recv_time + timestamp with time zone + + + + + + + + + + target_copy + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + source + integer + + + + + + + NOT NULL; + + + + + + + + + + + + dest + integer + + + + + + + NOT NULL; + + + + + + + + + + + + prev_hop + integer + + + + + + + + + + + + + + + + + copy_status + integer + + + + + + + NOT NULL; + + + + + + + + + + + + persistant_transfer + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing action.transit_copy via Foreign Key Constraints + + + + + + + + + + + + + + + + unfulfilled_hold_list + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + current_copy + bigint + + + + NOT NULL; + + + + + + + + hold + integer + + + + NOT NULL; + + + + + + + + circ_lib + integer + + + + NOT NULL; + + + + + + + + fail_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + +
+ +
+ Schema action_trigger + + + cleanup + + + + + + + + Field + Data Type + Constraints and References + + + + + + module + text + + + + PRIMARY KEY + + + + + + + + + + + + + description + text + + + + + + + + + + + + + + + + + + Tables referencing action_trigger.event_definition via Foreign Key Constraints + + + + + + + + + + + + + + + + collector + + + + + + + + Field + Data Type + Constraints and References + + + + + + module + text + + + + PRIMARY KEY + + + + + + + + + + + + + description + text + + + + + + + + + + + + + + + + + + Tables referencing action_trigger.environment via Foreign Key Constraints + + + + + + + + + + + + + + + + environment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + event_def + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + path + text + + + + + + + + + + collector + text + + + + + + + + + + + + + + + + + label + text + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + + + Constraints on environment + + + environment_label_check + CHECK ((label <> ALL (ARRAY['result'::text, 'target'::text, 'event'::text]))) + + + + + + + + + + + + + event + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + target + bigint + + + + NOT NULL; + + + + + + + + event_def + integer + + + + + + + + + + + + + + + + + add_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + run_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + start_time + timestamp with time zone + + + + + + + + + + update_time + timestamp with time zone + + + + + + + + + + complete_time + timestamp with time zone + + + + + + + + + + update_process + integer + + + + + + + + + + state + text + + + + NOT NULL; + + + DEFAULT 'pending'::text; + + + + + + + template_output + bigint + + + + + + + + + + + + + + + + + error_output + bigint + + + + + + + + + + + + + + + + + + + + + + + Constraints on event + + + event_state_check + CHECK ((state = ANY (ARRAY['pending'::text, 'invalid'::text, 'found'::text, 'collecting'::text, 'collected'::text, 'validating'::text, 'valid'::text, 'reacting'::text, 'reacted'::text, 'cleaning'::text, 'complete'::text, 'error'::text]))) + + + + + + + + + + + + + event_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + UNIQUE#2 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + hook + text + + + + + UNIQUE#2 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + validator + text + + + + + UNIQUE#2 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + reactor + text + + + + + UNIQUE#2 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + cleanup_success + text + + + + + + + + + + + + + + + + + cleanup_failure + text + + + + + + + + + + + + + + + + + delay + interval + + + + + UNIQUE#2 + ; + + + + NOT NULL; + + + DEFAULT '00:05:00'::interval; + + + + + + + + + max_delay + interval + + + + + + + + + + delay_field + text + + + + + UNIQUE#2 + ; + + + + + + + + + + + + group_field + text + + + + + + + + + + template + text + + + + + + + + + + + + + + + + + + Tables referencing action_trigger.environment via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + event_output + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + is_error + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + data + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing action_trigger.event via Foreign Key Constraints + + + + + + + + + + + + + + + + event_params + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + event_def + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + param + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + hook + + + + + + + + Field + Data Type + Constraints and References + + + + + + key + text + + + + PRIMARY KEY + + + + + + + + + + + + + core_type + text + + + + NOT NULL; + + + + + + + + description + text + + + + + + + + + + passive + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing action_trigger.event_definition via Foreign Key Constraints + + + + + + + + + + + + + + + + reactor + + + + + + + + Field + Data Type + Constraints and References + + + + + + module + text + + + + PRIMARY KEY + + + + + + + + + + + + + description + text + + + + + + + + + + + + + + + + + + Tables referencing action_trigger.event_definition via Foreign Key Constraints + + + + + + + + + + + + + + + + validator + + + + + + + + Field + Data Type + Constraints and References + + + + + + module + text + + + + PRIMARY KEY + + + + + + + + + + + + + description + text + + + + + + + + + + + + + + + + + + Tables referencing action_trigger.event_definition via Foreign Key Constraints + + + + + + + + + + + + + + +
+ +
+ Schema actor + + + card + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + barcode + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + + + + + + + + + + + + hours_of_operation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + + + + PRIMARY KEY + + + + + + + + + + + + + + + + + dow_0_open + time without time zone + + + + NOT NULL; + + + DEFAULT '09:00:00'::time without time zone; + + + + + + + dow_0_close + time without time zone + + + + NOT NULL; + + + DEFAULT '17:00:00'::time without time zone; + + + + + + + dow_1_open + time without time zone + + + + NOT NULL; + + + DEFAULT '09:00:00'::time without time zone; + + + + + + + dow_1_close + time without time zone + + + + NOT NULL; + + + DEFAULT '17:00:00'::time without time zone; + + + + + + + dow_2_open + time without time zone + + + + NOT NULL; + + + DEFAULT '09:00:00'::time without time zone; + + + + + + + dow_2_close + time without time zone + + + + NOT NULL; + + + DEFAULT '17:00:00'::time without time zone; + + + + + + + dow_3_open + time without time zone + + + + NOT NULL; + + + DEFAULT '09:00:00'::time without time zone; + + + + + + + dow_3_close + time without time zone + + + + NOT NULL; + + + DEFAULT '17:00:00'::time without time zone; + + + + + + + dow_4_open + time without time zone + + + + NOT NULL; + + + DEFAULT '09:00:00'::time without time zone; + + + + + + + dow_4_close + time without time zone + + + + NOT NULL; + + + DEFAULT '17:00:00'::time without time zone; + + + + + + + dow_5_open + time without time zone + + + + NOT NULL; + + + DEFAULT '09:00:00'::time without time zone; + + + + + + + dow_5_close + time without time zone + + + + NOT NULL; + + + DEFAULT '17:00:00'::time without time zone; + + + + + + + dow_6_open + time without time zone + + + + NOT NULL; + + + DEFAULT '09:00:00'::time without time zone; + + + + + + + dow_6_close + time without time zone + + + + NOT NULL; + + + DEFAULT '17:00:00'::time without time zone; + + + + + + + + + + + + + + + + + + org_address + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + valid + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + address_type + text + + + + NOT NULL; + + + DEFAULT 'MAILING'::text; + + + + + + + org_unit + integer + + + + + + + NOT NULL; + + + + + + + + + + + + street1 + text + + + + NOT NULL; + + + + + + + + street2 + text + + + + + + + + + + city + text + + + + NOT NULL; + + + + + + + + county + text + + + + + + + + + + state + text + + + + NOT NULL; + + + + + + + + country + text + + + + NOT NULL; + + + + + + + + post_code + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing actor.org_unit via Foreign Key Constraints + + + + + + + + + + + + + + + + org_lasso + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + + + + + + + + + + + + + + + + + Tables referencing actor.org_lasso_map via Foreign Key Constraints + + + + + + + + + + + + + + + + org_lasso_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + lasso + integer + + + + + + + NOT NULL; + + + + + + + + + + + + org_unit + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + org_unit + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + parent_ou + integer + + + + + + + + + + + + + + + + + ou_type + integer + + + + + + + NOT NULL; + + + + + + + + + + + + ill_address + integer + + + + + + + + + + + + + + + + + holds_address + integer + + + + + + + + + + + + + + + + + mailing_address + integer + + + + + + + + + + + + + + + + + billing_address + integer + + + + + + + + + + + + + + + + + shortname + text + + + + NOT NULL; + + + + + + + + name + text + + + + NOT NULL; + + + + + + + + email + text + + + + + + + + + + phone + text + + + + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + + + + + + + + + Tables referencing acq.distribution_formula via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + org_unit_closed + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + org_unit + integer + + + + + + + NOT NULL; + + + + + + + + + + + + close_start + timestamp with time zone + + + + NOT NULL; + + + + + + + + close_end + timestamp with time zone + + + + NOT NULL; + + + + + + + + reason + text + + + + + + + + + + + + + + + + + + + + + org_unit_proximity + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + from_org + integer + + + + + + + + + + to_org + integer + + + + + + + + + + prox + integer + + + + + + + + + + + + + + + + + + + + + org_unit_setting + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + org_unit + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + org_unit_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + NOT NULL; + + + + + + + + opac_label + text + + + + NOT NULL; + + + + + + + + depth + integer + + + + NOT NULL; + + + + + + + + parent + integer + + + + + + + + + + + + + + + + + can_have_vols + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + can_have_users + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + + + + + + + + + Tables referencing actor.org_unit via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + stat_cat + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing actor.stat_cat_entry via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + stat_cat_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + stat_cat + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + value + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + stat_cat_entry_usr_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + stat_cat_entry + text + + + + NOT NULL; + + + + + + + + stat_cat + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + target_usr + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + + + usr + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + card + integer + + + + + UNIQUE; + + + + + + + + + + + + profile + integer + + + + + + + NOT NULL; + + + + + + + + + + + + usrname + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + email + text + + + + + + + + + + passwd + text + + + + NOT NULL; + + + + + + + + standing + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + ident_type + integer + + + + + + + NOT NULL; + + + + + + + + + + + + ident_value + text + + + + + + + + + + ident_type2 + integer + + + + + + + + + + + + + + + + + ident_value2 + text + + + + + + + + + + net_access_level + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + photo_url + text + + + + + + + + + + prefix + text + + + + + + + + + + first_given_name + text + + + + NOT NULL; + + + + + + + + second_given_name + text + + + + + + + + + + family_name + text + + + + NOT NULL; + + + + + + + + suffix + text + + + + + + + + + + day_phone + text + + + + + + + + + + evening_phone + text + + + + + + + + + + other_phone + text + + + + + + + + + + mailing_address + integer + + + + + + + + + + + + + + + + + billing_address + integer + + + + + + + + + + + + + + + + + home_ou + integer + + + + + + + NOT NULL; + + + + + + + + + + + + dob + timestamp with time zone + + + + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + master_account + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + super_user + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + barred + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + deleted + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + usrgroup + serial + + + + NOT NULL; + + + + + + + + claims_returned_count + integer + + + + NOT NULL; + + + + + + + + credit_forward_balance + numeric(6,2) + + + + NOT NULL; + + + DEFAULT 0.00; + + + + + + + last_xact_id + text + + + + NOT NULL; + + + DEFAULT 'none'::text; + + + + + + + alert_message + text + + + + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + expire_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT (now() + '3 years'::interval); + + + + + + + alias + text + + + + + + + + + + juvenile + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing acq.fund_allocation via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + usr_address + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + valid + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + within_city_limits + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + address_type + text + + + + NOT NULL; + + + DEFAULT 'MAILING'::text; + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + street1 + text + + + + NOT NULL; + + + + + + + + street2 + text + + + + + + + + + + city + text + + + + NOT NULL; + + + + + + + + county + text + + + + + + + + + + state + text + + + + NOT NULL; + + + + + + + + country + text + + + + NOT NULL; + + + + + + + + post_code + text + + + + NOT NULL; + + + + + + + + pending + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + replaces + integer + + + + + + + + + + + + + + + + + + Tables referencing actor.usr via Foreign Key Constraints + + + + + + + + + + + + + + + + usr_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + creator + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + create_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + title + text + + + + NOT NULL; + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + usr_org_unit_opt_in + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + org_unit + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + usr + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + staff + integer + + + + + + + NOT NULL; + + + + + + + + + + + + opt_in_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + opt_in_ws + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + usr_password_reset + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + uuid + text + + + + NOT NULL; + + + + + + + + usr + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + request_time + timestamp without time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + has_been_reset + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + + + + usr_setting + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + usr_standing_penalty + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + org_unit + integer + + + + + + + NOT NULL; + + + + + + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + standing_penalty + integer + + + + + + + NOT NULL; + + + + + + + + + + + + staff + integer + + + + + + + + + + + + + + + + + set_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + stop_date + timestamp with time zone + + + + + + + + + + note + text + + + + + + + + + + + + + + + + + + + + + workstation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + owning_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + Tables referencing actor.usr_org_unit_opt_in via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema asset + + + call_number + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + creator + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + create_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + editor + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + edit_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + record + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + owning_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + label + text + + + + NOT NULL; + + + + + + + + deleted + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing asset.call_number_note via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + call_number_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + call_number + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + creator + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + create_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + title + text + + + + NOT NULL; + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + copy + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + circ_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + creator + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + call_number + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + editor + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + create_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + edit_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + copy_number + integer + + + + + + + + + + status + integer + + + + + + + NOT NULL; + + + + + + + + + + + + location + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + loan_duration + integer + + + + NOT NULL; + + + + + + + + fine_level + integer + + + + NOT NULL; + + + + + + + + age_protect + integer + + + + + + + + + + circulate + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + deposit + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + ref + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + holdable + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + deposit_amount + numeric(6,2) + + + + NOT NULL; + + + DEFAULT 0.00; + + + + + + + price + numeric(8,2) + + + + + + + + + + barcode + text + + + + NOT NULL; + + + + + + + + circ_modifier + text + + + + + + + + + + + + + + + + + circ_as_type + text + + + + + + + + + + dummy_title + text + + + + + + + + + + dummy_author + text + + + + + + + + + + alert_message + text + + + + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + deleted + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + Constraints on copy + + + copy_fine_level_check + CHECK ((fine_level = ANY (ARRAY[1, 2, 3]))) + + + + + + copy_loan_duration_check + CHECK ((loan_duration = ANY (ARRAY[1, 2, 3]))) + + + + + + + + + + Tables referencing acq.lineitem_detail via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + copy_location + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + owning_lib + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + holdable + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + hold_verify + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + circulate + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + + + + + + + + + Tables referencing acq.distribution_formula_entry via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + copy_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + owning_copy + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + creator + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + create_date + timestamp with time zone + + + + + DEFAULT now(); + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + title + text + + + + NOT NULL; + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + copy_transparency + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + deposit_amount + numeric(6,2) + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + circ_lib + integer + + + + + + + + + + + + + + + + + loan_duration + integer + + + + + + + + + + fine_level + integer + + + + + + + + + + holdable + boolean + + + + + + + + + + circulate + boolean + + + + + + + + + + deposit + boolean + + + + + + + + + + ref + boolean + + + + + + + + + + opac_visible + boolean + + + + + + + + + + circ_modifier + text + + + + + + + + + + circ_as_type + text + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + Constraints on copy_transparency + + + copy_transparency_fine_level_check + CHECK ((fine_level = ANY (ARRAY[1, 2, 3]))) + + + + + + copy_transparency_loan_duration_check + CHECK ((loan_duration = ANY (ARRAY[1, 2, 3]))) + + + + + + + + + + Tables referencing asset.copy_transparency_map via Foreign Key Constraints + + + + + + + + + + + + + + + + copy_transparency_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + transparency + integer + + + + + + + NOT NULL; + + + + + + + + + + + + target_copy + integer + + + + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + + + stat_cat + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing asset.stat_cat_entry via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + stat_cat_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + stat_cat + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + value + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing asset.stat_cat_entry_copy_map via Foreign Key Constraints + + + + + + + + + + + + + + + + stat_cat_entry_copy_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + stat_cat + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + stat_cat_entry + integer + + + + + + + NOT NULL; + + + + + + + + + + + + owning_copy + bigint + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + + + stat_cat_entry_transparency_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + stat_cat + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + stat_cat_entry + integer + + + + NOT NULL; + + + + + + + + owning_transparency + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + uri + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + href + text + + + + NOT NULL; + + + + + + + + label + text + + + + + + + + + + use_restriction + text + + + + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + + + + + + + + + Tables referencing asset.uri_call_number_map via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + uri_call_number_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + uri + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + call_number + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema auditor + + + actor_org_unit_history + + + + + + + + Field + Data Type + Constraints and References + + + + + + audit_id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + audit_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + audit_action + text + + + + NOT NULL; + + + + + + + + id + integer + + + + NOT NULL; + + + + + + + + parent_ou + integer + + + + + + + + + + ou_type + integer + + + + NOT NULL; + + + + + + + + ill_address + integer + + + + + + + + + + holds_address + integer + + + + + + + + + + mailing_address + integer + + + + + + + + + + billing_address + integer + + + + + + + + + + shortname + text + + + + NOT NULL; + + + + + + + + name + text + + + + NOT NULL; + + + + + + + + email + text + + + + + + + + + + phone + text + + + + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + actor_org_unit_lifecycle + + + + + + + + Field + Data Type + Constraints and References + + + + + + ?column? + bigint + + + + + + + + + + audit_time + timestamp with time zone + + + + + + + + + + audit_action + text + + + + + + + + + + id + integer + + + + + + + + + + parent_ou + integer + + + + + + + + + + ou_type + integer + + + + + + + + + + ill_address + integer + + + + + + + + + + holds_address + integer + + + + + + + + + + mailing_address + integer + + + + + + + + + + billing_address + integer + + + + + + + + + + shortname + text + + + + + + + + + + name + text + + + + + + + + + + email + text + + + + + + + + + + phone + text + + + + + + + + + + opac_visible + boolean + + + + + + + + + + + + + + + + + + + + + actor_usr_address_history + + + + + + + + Field + Data Type + Constraints and References + + + + + + audit_id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + audit_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + audit_action + text + + + + NOT NULL; + + + + + + + + id + integer + + + + NOT NULL; + + + + + + + + valid + boolean + + + + NOT NULL; + + + + + + + + within_city_limits + boolean + + + + NOT NULL; + + + + + + + + address_type + text + + + + NOT NULL; + + + + + + + + usr + integer + + + + NOT NULL; + + + + + + + + street1 + text + + + + NOT NULL; + + + + + + + + street2 + text + + + + + + + + + + city + text + + + + NOT NULL; + + + + + + + + county + text + + + + + + + + + + state + text + + + + NOT NULL; + + + + + + + + country + text + + + + NOT NULL; + + + + + + + + post_code + text + + + + NOT NULL; + + + + + + + + pending + boolean + + + + + + + + + + replaces + integer + + + + + + + + + + + + + + + + + + + + + actor_usr_address_lifecycle + + + + + + + + Field + Data Type + Constraints and References + + + + + + ?column? + bigint + + + + + + + + + + audit_time + timestamp with time zone + + + + + + + + + + audit_action + text + + + + + + + + + + id + integer + + + + + + + + + + valid + boolean + + + + + + + + + + within_city_limits + boolean + + + + + + + + + + address_type + text + + + + + + + + + + usr + integer + + + + + + + + + + street1 + text + + + + + + + + + + street2 + text + + + + + + + + + + city + text + + + + + + + + + + county + text + + + + + + + + + + state + text + + + + + + + + + + country + text + + + + + + + + + + post_code + text + + + + + + + + + + + + + + + + + + + + + actor_usr_history + + + + + + + + Field + Data Type + Constraints and References + + + + + + audit_id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + audit_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + audit_action + text + + + + NOT NULL; + + + + + + + + id + integer + + + + NOT NULL; + + + + + + + + card + integer + + + + + + + + + + profile + integer + + + + NOT NULL; + + + + + + + + usrname + text + + + + NOT NULL; + + + + + + + + email + text + + + + + + + + + + passwd + text + + + + NOT NULL; + + + + + + + + standing + integer + + + + NOT NULL; + + + + + + + + ident_type + integer + + + + NOT NULL; + + + + + + + + ident_value + text + + + + + + + + + + ident_type2 + integer + + + + + + + + + + ident_value2 + text + + + + + + + + + + net_access_level + integer + + + + NOT NULL; + + + + + + + + photo_url + text + + + + + + + + + + prefix + text + + + + + + + + + + first_given_name + text + + + + NOT NULL; + + + + + + + + second_given_name + text + + + + + + + + + + family_name + text + + + + NOT NULL; + + + + + + + + suffix + text + + + + + + + + + + day_phone + text + + + + + + + + + + evening_phone + text + + + + + + + + + + other_phone + text + + + + + + + + + + mailing_address + integer + + + + + + + + + + billing_address + integer + + + + + + + + + + home_ou + integer + + + + NOT NULL; + + + + + + + + dob + timestamp with time zone + + + + + + + + + + active + boolean + + + + NOT NULL; + + + + + + + + master_account + boolean + + + + NOT NULL; + + + + + + + + super_user + boolean + + + + NOT NULL; + + + + + + + + barred + boolean + + + + NOT NULL; + + + + + + + + deleted + boolean + + + + NOT NULL; + + + + + + + + usrgroup + integer + + + + NOT NULL; + + + + + + + + claims_returned_count + integer + + + + NOT NULL; + + + + + + + + credit_forward_balance + numeric(6,2) + + + + NOT NULL; + + + + + + + + last_xact_id + text + + + + NOT NULL; + + + + + + + + alert_message + text + + + + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + + + + + + expire_date + timestamp with time zone + + + + NOT NULL; + + + + + + + + alias + text + + + + + + + + + + juvenile + boolean + + + + + + + + + + + + + + + + + + + + + actor_usr_lifecycle + + + + + + + + Field + Data Type + Constraints and References + + + + + + ?column? + bigint + + + + + + + + + + audit_time + timestamp with time zone + + + + + + + + + + audit_action + text + + + + + + + + + + id + integer + + + + + + + + + + card + integer + + + + + + + + + + profile + integer + + + + + + + + + + usrname + text + + + + + + + + + + email + text + + + + + + + + + + passwd + text + + + + + + + + + + standing + integer + + + + + + + + + + ident_type + integer + + + + + + + + + + ident_value + text + + + + + + + + + + ident_type2 + integer + + + + + + + + + + ident_value2 + text + + + + + + + + + + net_access_level + integer + + + + + + + + + + photo_url + text + + + + + + + + + + prefix + text + + + + + + + + + + first_given_name + text + + + + + + + + + + second_given_name + text + + + + + + + + + + family_name + text + + + + + + + + + + suffix + text + + + + + + + + + + day_phone + text + + + + + + + + + + evening_phone + text + + + + + + + + + + other_phone + text + + + + + + + + + + mailing_address + integer + + + + + + + + + + billing_address + integer + + + + + + + + + + home_ou + integer + + + + + + + + + + dob + timestamp with time zone + + + + + + + + + + active + boolean + + + + + + + + + + master_account + boolean + + + + + + + + + + super_user + boolean + + + + + + + + + + barred + boolean + + + + + + + + + + deleted + boolean + + + + + + + + + + usrgroup + integer + + + + + + + + + + claims_returned_count + integer + + + + + + + + + + credit_forward_balance + numeric(6,2) + + + + + + + + + + last_xact_id + text + + + + + + + + + + alert_message + text + + + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + expire_date + timestamp with time zone + + + + + + + + + + + + + + + + + + + + + asset_call_number_history + + + + + + + + Field + Data Type + Constraints and References + + + + + + audit_id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + audit_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + audit_action + text + + + + NOT NULL; + + + + + + + + id + bigint + + + + NOT NULL; + + + + + + + + creator + bigint + + + + NOT NULL; + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + editor + bigint + + + + NOT NULL; + + + + + + + + edit_date + timestamp with time zone + + + + + + + + + + record + bigint + + + + NOT NULL; + + + + + + + + owning_lib + integer + + + + NOT NULL; + + + + + + + + label + text + + + + NOT NULL; + + + + + + + + deleted + boolean + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + asset_call_number_lifecycle + + + + + + + + Field + Data Type + Constraints and References + + + + + + ?column? + bigint + + + + + + + + + + audit_time + timestamp with time zone + + + + + + + + + + audit_action + text + + + + + + + + + + id + bigint + + + + + + + + + + creator + bigint + + + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + editor + bigint + + + + + + + + + + edit_date + timestamp with time zone + + + + + + + + + + record + bigint + + + + + + + + + + owning_lib + integer + + + + + + + + + + label + text + + + + + + + + + + deleted + boolean + + + + + + + + + + + + + + + + + + + + + asset_copy_history + + + + + + + + Field + Data Type + Constraints and References + + + + + + audit_id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + audit_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + audit_action + text + + + + NOT NULL; + + + + + + + + id + bigint + + + + NOT NULL; + + + + + + + + circ_lib + integer + + + + NOT NULL; + + + + + + + + creator + bigint + + + + NOT NULL; + + + + + + + + call_number + bigint + + + + NOT NULL; + + + + + + + + editor + bigint + + + + NOT NULL; + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + edit_date + timestamp with time zone + + + + + + + + + + copy_number + integer + + + + + + + + + + status + integer + + + + NOT NULL; + + + + + + + + location + integer + + + + NOT NULL; + + + + + + + + loan_duration + integer + + + + NOT NULL; + + + + + + + + fine_level + integer + + + + NOT NULL; + + + + + + + + age_protect + integer + + + + + + + + + + circulate + boolean + + + + NOT NULL; + + + + + + + + deposit + boolean + + + + NOT NULL; + + + + + + + + ref + boolean + + + + NOT NULL; + + + + + + + + holdable + boolean + + + + NOT NULL; + + + + + + + + deposit_amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + price + numeric(8,2) + + + + + + + + + + barcode + text + + + + NOT NULL; + + + + + + + + circ_modifier + text + + + + + + + + + + circ_as_type + text + + + + + + + + + + dummy_title + text + + + + + + + + + + dummy_author + text + + + + + + + + + + alert_message + text + + + + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + + + + + + deleted + boolean + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + asset_copy_lifecycle + + + + + + + + Field + Data Type + Constraints and References + + + + + + ?column? + bigint + + + + + + + + + + audit_time + timestamp with time zone + + + + + + + + + + audit_action + text + + + + + + + + + + id + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + creator + bigint + + + + + + + + + + call_number + bigint + + + + + + + + + + editor + bigint + + + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + edit_date + timestamp with time zone + + + + + + + + + + copy_number + integer + + + + + + + + + + status + integer + + + + + + + + + + location + integer + + + + + + + + + + loan_duration + integer + + + + + + + + + + fine_level + integer + + + + + + + + + + age_protect + integer + + + + + + + + + + circulate + boolean + + + + + + + + + + deposit + boolean + + + + + + + + + + ref + boolean + + + + + + + + + + holdable + boolean + + + + + + + + + + deposit_amount + numeric(6,2) + + + + + + + + + + price + numeric(8,2) + + + + + + + + + + barcode + text + + + + + + + + + + circ_modifier + text + + + + + + + + + + circ_as_type + text + + + + + + + + + + dummy_title + text + + + + + + + + + + dummy_author + text + + + + + + + + + + alert_message + text + + + + + + + + + + opac_visible + boolean + + + + + + + + + + deleted + boolean + + + + + + + + + + + + + + + + + + + + + biblio_record_entry_history + + + + + + + + Field + Data Type + Constraints and References + + + + + + audit_id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + audit_time + timestamp with time zone + + + + NOT NULL; + + + + + + + + audit_action + text + + + + NOT NULL; + + + + + + + + id + bigint + + + + NOT NULL; + + + + + + + + creator + integer + + + + NOT NULL; + + + + + + + + editor + integer + + + + NOT NULL; + + + + + + + + source + integer + + + + + + + + + + quality + integer + + + + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + + + + + + edit_date + timestamp with time zone + + + + NOT NULL; + + + + + + + + active + boolean + + + + NOT NULL; + + + + + + + + deleted + boolean + + + + NOT NULL; + + + + + + + + fingerprint + text + + + + + + + + + + tcn_source + text + + + + NOT NULL; + + + + + + + + tcn_value + text + + + + NOT NULL; + + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + last_xact_id + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + biblio_record_entry_lifecycle + + + + + + + + Field + Data Type + Constraints and References + + + + + + ?column? + bigint + + + + + + + + + + audit_time + timestamp with time zone + + + + + + + + + + audit_action + text + + + + + + + + + + id + bigint + + + + + + + + + + creator + integer + + + + + + + + + + editor + integer + + + + + + + + + + source + integer + + + + + + + + + + quality + integer + + + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + edit_date + timestamp with time zone + + + + + + + + + + active + boolean + + + + + + + + + + deleted + boolean + + + + + + + + + + fingerprint + text + + + + + + + + + + tcn_source + text + + + + + + + + + + tcn_value + text + + + + + + + + + + marc + text + + + + + + + + + + last_xact_id + text + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema authority + + + full_rec + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + NOT NULL; + + + + + + + + tag + character(3) + + + + NOT NULL; + + + + + + + + ind1 + text + + + + + + + + + + ind2 + text + + + + + + + + + + subfield + text + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + index_vector + public.tsvector + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + rec_descriptor + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + + + + record_status + text + + + + + + + + + + char_encoding + text + + + + + + + + + + + + + + + + + + + + + record_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + arn_source + text + + + + NOT NULL; + + + DEFAULT 'AUTOGEN'::text; + + + + + + + arn_value + text + + + + NOT NULL; + + + + + + + + creator + integer + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + editor + integer + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + deleted + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + source + integer + + + + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + last_xact_id + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing authority.record_note via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + record_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + creator + integer + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + editor + integer + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + + + tracing_links + + + + + + + + Field + Data Type + Constraints and References + + + + + + record + bigint + + + + + + + + + + main_id + bigint + + + + + + + + + + main_tag + character(3) + + + + + + + + + + main_value + text + + + + + + + + + + relationship + text + + + + + + + + + + use_restriction + text + + + + + + + + + + deprecation + text + + + + + + + + + + display_restriction + text + + + + + + + + + + link_id + bigint + + + + + + + + + + link_tag + character(3) + + + + + + + + + + link_value + text + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema biblio + + + record_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + creator + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + editor + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + source + integer + + + + + + + + + + quality + integer + + + + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + deleted + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + fingerprint + text + + + + + + + + + + tcn_source + text + + + + NOT NULL; + + + DEFAULT 'AUTOGEN'::text; + + + + + + + tcn_value + text + + + + NOT NULL; + + + DEFAULT next_autogen_tcn_value(); + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + last_xact_id + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing acq.lineitem via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + record_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + creator + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + editor + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + +
+ +
+ Schema booking + + + reservation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('money.billable_xact_id_seq'::regclass); + + + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + xact_start + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + request_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + start_time + timestamp with time zone + + + + + + + + + + end_time + timestamp with time zone + + + + + + + + + + capture_time + timestamp with time zone + + + + + + + + + + cancel_time + timestamp with time zone + + + + + + + + + + pickup_time + timestamp with time zone + + + + + + + + + + return_time + timestamp with time zone + + + + + + + + + + booking_interval + interval + + + + + + + + + + fine_interval + interval + + + + + + + + + + fine_amount + numeric(8,2) + + + + + + + + + + target_resource_type + integer + + + + + + + NOT NULL; + + + + + + + + + + + + target_resource + integer + + + + + + + + + + + + + + + + + current_resource + integer + + + + + + + + + + + + + + + + + request_lib + integer + + + + + + + NOT NULL; + + + + + + + + + + + + pickup_lib + integer + + + + + + + + + + + + + + + + + capture_staff + integer + + + + + + + + + + + + + + + + + max_fine + numeric(8,2) + + + + + + + + + + + + + + + + + + Tables referencing action.reservation_transit_copy via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + reservation_attr_value_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + reservation + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + attr_value + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + + + resource + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + type + integer + + + + + + + NOT NULL; + + + + + + + + + + + + overbook + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + barcode + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + deposit + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + deposit_amount + numeric(8,2) + + + + NOT NULL; + + + DEFAULT 0.00; + + + + + + + user_fee + numeric(8,2) + + + + NOT NULL; + + + DEFAULT 0.00; + + + + + + + + + + + + + + + Tables referencing action.reservation_transit_copy via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + resource_attr + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + resource_type + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + required + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing booking.resource_attr_map via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + resource_attr_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + resource + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + resource_attr + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + value + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + resource_attr_value + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + attr + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + valid_value + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing booking.reservation_attr_value_map via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + resource_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + fine_interval + interval + + + + + + + + + + fine_amount + numeric(8,2) + + + + NOT NULL; + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + catalog_item + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + transferable + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + record + bigint + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + + + + max_fine + numeric(8,2) + + + + + + + + + + elbow_room + interval + + + + + + + + + + + + + + + + + + Tables referencing booking.reservation via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema config + + + audience_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + description + text + + + + + + + + + + + + + + + + + + + + + bib_level_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + bib_source + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + quality + integer + + + + + + + + + + source + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + transcendant + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + Constraints on bib_source + + + bib_source_quality_check + CHECK (((quality >= 0) AND (quality <= 100))) + + + + + + + + + + Tables referencing vandelay.queued_bib_record via Foreign Key Constraints + + + + + + + + + + + + + + + + billing_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + default_price + numeric(6,2) + + + + + + + + + + + + + + + + + + Tables referencing money.billing via Foreign Key Constraints + + + + + + + + + + + + + + + + circ_matrix_circ_mod_test + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + matchpoint + integer + + + + + + + NOT NULL; + + + + + + + + + + + + items_out + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing config.circ_matrix_circ_mod_test_map via Foreign Key Constraints + + + + + + + + + + + + + + + + circ_matrix_circ_mod_test_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + circ_mod_test + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + circ_mod + text + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + + + circ_matrix_matchpoint + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + org_unit + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + grp + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + circ_modifier + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + marc_type + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + marc_form + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + marc_vr_format + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + ref_flag + boolean + + + + + UNIQUE#1 + ; + + + + + + + + + + + + is_renewal + boolean + + + + + UNIQUE#1 + ; + + + + + + + + + + + + usr_age_lower_bound + interval + + + + + UNIQUE#1 + ; + + + + + + + + + + + + usr_age_upper_bound + interval + + + + + UNIQUE#1 + ; + + + + + + + + + + + + juvenile_flag + boolean + + + + + UNIQUE#1 + ; + + + + + + + + + + + + circulate + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + duration_rule + integer + + + + + + + NOT NULL; + + + + + + + + + + + + recurring_fine_rule + integer + + + + + + + NOT NULL; + + + + + + + + + + + + max_fine_rule + integer + + + + + + + NOT NULL; + + + + + + + + + + + + script_test + text + + + + + + + + + + + + + + + + + + Tables referencing config.circ_matrix_circ_mod_test via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + circ_matrix_test + + + + + + + + Field + Data Type + Constraints and References + + + + + + matchpoint + integer + + + + + + + PRIMARY KEY + + + + + + + + + + + + + + + + + circulate + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + max_items_out + integer + + + + + + + + + + max_overdue + integer + + + + + + + + + + max_fines + numeric(8,2) + + + + + + + + + + org_depth + integer + + + + + + + + + + script_test + text + + + + + + + + + + + + + + + + + + + + + circ_modifier + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + sip2_media_type + text + + + + NOT NULL; + + + + + + + + magnetic_media + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + + + + + + + + + Tables referencing acq.lineitem_detail via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + copy_status + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + holdable + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + opac_visible + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing action.transit_copy via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + hold_matrix_matchpoint + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + user_home_ou + integer + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + request_ou + integer + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + pickup_ou + integer + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + item_owning_ou + integer + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + item_circ_ou + integer + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + usr_grp + integer + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + requestor_grp + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + circ_modifier + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + marc_type + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + marc_form + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + marc_vr_format + text + + + + + + + + UNIQUE#1 + ; + + + + + + + + + + + + + + + + ref_flag + boolean + + + + + + + + + + juvenile_flag + boolean + + + + + + + + + + age_hold_protect_rule + integer + + + + + + + + + + + + + + + + + holdable + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + distance_is_from_owner + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + transit_range + integer + + + + + + + + + + + + + + + + + max_holds + integer + + + + + + + + + + include_frozen_holds + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + stop_blocked_user + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing config.hold_matrix_test via Foreign Key Constraints + + + + + + + + + + + + + + + + hold_matrix_test + + + + + + + + Field + Data Type + Constraints and References + + + + + + matchpoint + integer + + + + + + + PRIMARY KEY + + + + + + + + + + + + + + + + + holdable + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + distance_is_from_owner + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + transit_range + integer + + + + + + + + + + + + + + + + + max_holds + integer + + + + + + + + + + include_frozen_holds + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + stop_blocked_user + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + age_hold_protect_rule + integer + + + + + + + + + + + + + + + + + + + + + + + + + + + + i18n_core + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + fq_field + text + + + + NOT NULL; + + + + + + + + identity_value + text + + + + NOT NULL; + + + + + + + + translation + text + + + + + + + NOT NULL; + + + + + + + + + + + + string + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + i18n_locale + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + marc_code + text + + + + + + + NOT NULL; + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + description + text + + + + + + + + + + + + + + + + + + Tables referencing config.i18n_core via Foreign Key Constraints + + + + + + + + + + + + + + + + identification_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing actor.usr via Foreign Key Constraints + + + + + + + + + + + + + + + + idl_field_doc + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + fm_class + text + + + + NOT NULL; + + + + + + + + field + text + + + + NOT NULL; + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + string + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + item_form_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + item_type_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + language_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing config.i18n_locale via Foreign Key Constraints + + + + + + + + + + + + + + + + lit_form_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + description + text + + + + + + + + + + + + + + + + + + + + + metabib_field + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + field_class + text + + + + NOT NULL; + + + + + + + + name + text + + + + NOT NULL; + + + + + + + + xpath + text + + + + NOT NULL; + + + + + + + + weight + integer + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + format + text + + + + NOT NULL; + + + DEFAULT 'mods32'::text; + + + + + + + search_field + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + facet_field + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + Constraints on metabib_field + + + metabib_field_field_class_check + CHECK ((lower(field_class) = ANY (ARRAY['title'::text, 'author'::text, 'subject'::text, 'keyword'::text, 'series'::text]))) + + + + + + + + + + Tables referencing metabib.author_field_entry via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + net_access_level + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing actor.usr via Foreign Key Constraints + + + + + + + + + + + + + + + + non_cataloged_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owning_lib + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + circ_duration + interval + + + + NOT NULL; + + + DEFAULT '14 days'::interval; + + + + + + + in_house + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing action.non_cat_in_house_use via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + rule_age_hold_protect + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + age + interval + + + + NOT NULL; + + + + + + + + prox + integer + + + + NOT NULL; + + + + + + + + + + + + + + Constraints on rule_age_hold_protect + + + rule_age_hold_protect_name_check + CHECK ((name ~ '^\\w+$'::text)) + + + + + + + + + + Tables referencing config.hold_matrix_matchpoint via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + rule_circ_duration + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + extended + interval + + + + NOT NULL; + + + + + + + + normal + interval + + + + NOT NULL; + + + + + + + + shrt + interval + + + + NOT NULL; + + + + + + + + max_renewals + integer + + + + NOT NULL; + + + + + + + + + + + + + + Constraints on rule_circ_duration + + + rule_circ_duration_name_check + CHECK ((name ~ '^\\w+$'::text)) + + + + + + + + + + Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints + + + + + + + + + + + + + + + + rule_max_fine + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + is_percent + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + Constraints on rule_max_fine + + + rule_max_fine_name_check + CHECK ((name ~ '^\\w+$'::text)) + + + + + + + + + + Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints + + + + + + + + + + + + + + + + rule_recuring_fine + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + high + numeric(6,2) + + + + NOT NULL; + + + + + + + + normal + numeric(6,2) + + + + NOT NULL; + + + + + + + + low + numeric(6,2) + + + + NOT NULL; + + + + + + + + recurance_interval + interval + + + + NOT NULL; + + + DEFAULT '1 day'::interval; + + + + + + + + + + + + + Constraints on rule_recuring_fine + + + rule_recuring_fine_name_check + CHECK ((name ~ '^\\w+$'::text)) + + + + + + + + + + Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints + + + + + + + + + + + + + + + + standing + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing actor.usr via Foreign Key Constraints + + + + + + + + + + + + + + + + standing_penalty + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + label + text + + + + NOT NULL; + + + + + + + + block_list + text + + + + + + + + + + + + + + + + + + Tables referencing actor.usr_standing_penalty via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + upgrade_log + + + + + + + + Field + Data Type + Constraints and References + + + + + + version + text + + + + PRIMARY KEY + + + + + + + + + + + + + install_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + + + + videorecording_format_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing config.circ_matrix_matchpoint via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + xml_transform + + + + + + + + Field + Data Type + Constraints and References + + + + + + name + text + + + + PRIMARY KEY + + + + + + + + + + + + + namespace_uri + text + + + + NOT NULL; + + + + + + + + prefix + text + + + + NOT NULL; + + + + + + + + xslt + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + z3950_attr + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + source + text + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + NOT NULL; + + + + + + + + label + text + + + + NOT NULL; + + + + + + + + code + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + format + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + truncation + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + z3950_source + + + + + + + + Field + Data Type + Constraints and References + + + + + + name + text + + + + PRIMARY KEY + + + + + + + + + + + + + label + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + host + text + + + + NOT NULL; + + + + + + + + port + integer + + + + NOT NULL; + + + + + + + + db + text + + + + NOT NULL; + + + + + + + + record_format + text + + + + NOT NULL; + + + DEFAULT 'FI'::text; + + + + + + + transmission_format + text + + + + NOT NULL; + + + DEFAULT 'usmarc'::text; + + + + + + + auth + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + + + + + + + + + Tables referencing config.z3950_attr via Foreign Key Constraints + + + + + + + + + + + + + + +
+ +
+ Schema container + + + biblio_record_entry_bucket + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + btype + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT 'misc'::text; + + + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + Tables referencing container.biblio_record_entry_bucket_item via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + biblio_record_entry_bucket_item + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + target_biblio_record_entry + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + pos + integer + + + + + + + + + + + + + + + + + + Tables referencing container.biblio_record_entry_bucket_item_note via Foreign Key Constraints + + + + + + + + + + + + + + + + biblio_record_entry_bucket_item_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + item + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + biblio_record_entry_bucket_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + biblio_record_entry_bucket_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + label + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + call_number_bucket + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + btype + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT 'misc'::text; + + + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + Tables referencing container.call_number_bucket_item via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + call_number_bucket_item + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + target_call_number + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + pos + integer + + + + + + + + + + + + + + + + + + Tables referencing container.call_number_bucket_item_note via Foreign Key Constraints + + + + + + + + + + + + + + + + call_number_bucket_item_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + item + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + call_number_bucket_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + call_number_bucket_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + label + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + copy_bucket + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + btype + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT 'misc'::text; + + + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + Tables referencing container.copy_bucket_item via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + copy_bucket_item + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + target_copy + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + pos + integer + + + + + + + + + + + + + + + + + + Tables referencing container.copy_bucket_item_note via Foreign Key Constraints + + + + + + + + + + + + + + + + copy_bucket_item_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + item + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + copy_bucket_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + copy_bucket_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + label + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + user_bucket + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + btype + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT 'misc'::text; + + + + + + + + + pub + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + + + + + + + + + Tables referencing container.user_bucket_item via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + user_bucket_item + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + target_user + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + pos + integer + + + + + + + + + + + + + + + + + + Tables referencing container.user_bucket_item_note via Foreign Key Constraints + + + + + + + + + + + + + + + + user_bucket_item_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + item + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + user_bucket_note + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + bucket + integer + + + + + + + NOT NULL; + + + + + + + + + + + + note + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + user_bucket_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + code + text + + + + PRIMARY KEY + + + + + + + + + + + + + label + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema extend_reporter + + + full_circ_count + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + circ_count + bigint + + + + + + + + + + + + + + + + + + + + + global_bibs_by_holding_update + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + holding_update + timestamp with time zone + + + + + + + + + + update_type + text + + + + + + + + + + + + + + + + + + + + + legacy_circ_count + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + PRIMARY KEY + + + + + + + + + + + + + + + + + circ_count + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + +
+ +
+ Schema metabib + + + author_field_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + source + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + field + integer + + + + + + + NOT NULL; + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + index_vector + public.tsvector + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + full_rec + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + record + bigint + + + + + + + + + + tag + character(3) + + + + + + + + + + ind1 + text + + + + + + + + + + ind2 + text + + + + + + + + + + subfield + text + + + + + + + + + + value + text + + + + + + + + + + index_vector + public.tsvector + + + + + + + + + + + + + + + + + + + + + keyword_field_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + source + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + field + integer + + + + + + + NOT NULL; + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + index_vector + public.tsvector + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + metarecord + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + fingerprint + text + + + + NOT NULL; + + + + + + + + master_record + bigint + + + + + + + + + + + + + + + + + mods + text + + + + + + + + + + + + + + + + + + Tables referencing metabib.metarecord_source_map via Foreign Key Constraints + + + + + + + + + + + + + + + + metarecord_source_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + metarecord + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + source + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + real_full_rec + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('full_rec_id_seq'::regclass); + + + + + + + + + record + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + tag + character(3) + + + + NOT NULL; + + + + + + + + ind1 + text + + + + + + + + + + ind2 + text + + + + + + + + + + subfield + text + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + index_vector + public.tsvector + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + rec_descriptor + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + + + + + + + + + + + item_type + text + + + + + + + + + + item_form + text + + + + + + + + + + bib_level + text + + + + + + + + + + control_type + text + + + + + + + + + + char_encoding + text + + + + + + + + + + enc_level + text + + + + + + + + + + audience + text + + + + + + + + + + lit_form + text + + + + + + + + + + type_mat + text + + + + + + + + + + cat_form + text + + + + + + + + + + pub_status + text + + + + + + + + + + item_lang + text + + + + + + + + + + vr_format + text + + + + + + + + + + date1 + text + + + + + + + + + + date2 + text + + + + + + + + + + + + + + + + + + + + + series_field_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + source + bigint + + + + NOT NULL; + + + + + + + + field + integer + + + + NOT NULL; + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + index_vector + public.tsvector + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + subject_field_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + source + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + field + integer + + + + + + + NOT NULL; + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + index_vector + public.tsvector + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + title_field_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + source + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + field + integer + + + + + + + NOT NULL; + + + + + + + + + + + + value + text + + + + NOT NULL; + + + + + + + + index_vector + public.tsvector + + + + NOT NULL; + + + + + + + + + + + + + + + + + +
+ +
+ Schema money + + + billable_xact + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + xact_start + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + + + + + + + + + + + + billable_xact_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + total_paid + numeric + + + + + + + + + + last_payment_ts + timestamp with time zone + + + + + + + + + + last_payment_note + text + + + + + + + + + + last_payment_type + name + + + + + + + + + + total_owed + numeric + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_type + text + + + + + + + + + + balance_owed + numeric + + + + + + + + + + xact_type + name + + + + + + + + + + + + + + + + + + + + + billable_xact_with_void_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + total_paid + numeric + + + + + + + + + + last_payment_ts + timestamp with time zone + + + + + + + + + + last_payment_note + text + + + + + + + + + + last_payment_type + name + + + + + + + + + + total_owed + numeric + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_type + text + + + + + + + + + + balance_owed + numeric + + + + + + + + + + xact_type + name + + + + + + + + + + + + + + + + + + + + + billing + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + billing_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + voider + integer + + + + + + + + + + void_time + timestamp with time zone + + + + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + billing_type + text + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + btype + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + bnm_desk_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + cash_drawer + integer + + + + + + + + + + + + + + + + + + + + + + + + + + + + bnm_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + bnm_payment_view + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + xact + bigint + + + + + + + + + + payment_ts + timestamp with time zone + + + + + + + + + + voided + boolean + + + + + + + + + + amount + numeric(6,2) + + + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + + + + + + + accepting_usr + integer + + + + + + + + + + payment_type + name + + + + + + + + + + + + + + + + + + + + + cash_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + cash_drawer + integer + + + + + + + + + + + + + + + + + + + + + cashdrawer_payment_view + + + + + + + + Field + Data Type + Constraints and References + + + + + + org_unit + integer + + + + + + + + + + cashdrawer + integer + + + + + + + + + + payment_type + name + + + + + + + + + + payment_ts + timestamp with time zone + + + + + + + + + + amount + numeric(6,2) + + + + + + + + + + voided + boolean + + + + + + + + + + note + text + + + + + + + + + + + + + + + + + + + + + check_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + cash_drawer + integer + + + + + + + + + + check_number + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + collections_tracker + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + + + NOT NULL; + + + + + + + + + + + + collector + integer + + + + + + + NOT NULL; + + + + + + + + + + + + location + integer + + + + + + + NOT NULL; + + + + + + + + + + + + enter_time + timestamp with time zone + + + + + + + + + + + + + + + + + + + + + credit_card_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + cash_drawer + integer + + + + + + + + + + cc_type + text + + + + + + + + + + cc_number + text + + + + + + + + + + expire_month + integer + + + + + + + + + + expire_year + integer + + + + + + + + + + approval_code + text + + + + + + + + + + + + + + + + + + + + + credit_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + desk_payment_view + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + xact + bigint + + + + + + + + + + payment_ts + timestamp with time zone + + + + + + + + + + voided + boolean + + + + + + + + + + amount + numeric(6,2) + + + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + + + + + + + accepting_usr + integer + + + + + + + + + + cash_drawer + integer + + + + + + + + + + payment_type + name + + + + + + + + + + + + + + + + + + + + + forgive_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + goods_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + grocery + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('billable_xact_id_seq'::regclass); + + + + + + + + + usr + integer + + + + NOT NULL; + + + + + + + + xact_start + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + billing_location + integer + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + + + + + + + + + + + + materialized_billable_xact_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + total_paid + numeric + + + + + + + + + + last_payment_ts + timestamp with time zone + + + + + + + + + + last_payment_note + text + + + + + + + + + + last_payment_type + name + + + + + + + + + + total_owed + numeric + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_type + text + + + + + + + + + + balance_owed + numeric + + + + + + + + + + xact_type + name + + + + + + + + + + + + + + + + + + + + + non_drawer_payment_view + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + xact + bigint + + + + + + + + + + payment_ts + timestamp with time zone + + + + + + + + + + voided + boolean + + + + + + + + + + amount + numeric(6,2) + + + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + + + + + + + accepting_usr + integer + + + + + + + + + + payment_type + name + + + + + + + + + + + + + + + + + + + + + open_billable_xact_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + billing_location + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + total_paid + numeric + + + + + + + + + + last_payment_ts + timestamp with time zone + + + + + + + + + + last_payment_note + text + + + + + + + + + + last_payment_type + name + + + + + + + + + + total_owed + numeric + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_type + text + + + + + + + + + + balance_owed + numeric + + + + + + + + + + xact_type + name + + + + + + + + + + + + + + + + + + + + + open_transaction_billing_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_billing_type + text + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + total_owed + numeric + + + + + + + + + + + + + + + + + + + + + open_transaction_billing_type_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_billing_type + text + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + total_owed + numeric + + + + + + + + + + + + + + + + + + + + + open_transaction_payment_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_payment_type + name + + + + + + + + + + last_payment_note + text + + + + + + + + + + last_payment_ts + timestamp with time zone + + + + + + + + + + total_paid + numeric + + + + + + + + + + + + + + + + + + + + + open_usr_circulation_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + usr + integer + + + + + + + + + + total_paid + numeric + + + + + + + + + + total_owed + numeric + + + + + + + + + + balance_owed + numeric + + + + + + + + + + + + + + + + + + + + + open_usr_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + usr + integer + + + + + + + + + + total_paid + numeric + + + + + + + + + + total_owed + numeric + + + + + + + + + + balance_owed + numeric + + + + + + + + + + + + + + + + + + + + + payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + + + + + + + + + + + + payment_view + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + xact + bigint + + + + + + + + + + payment_ts + timestamp with time zone + + + + + + + + + + voided + boolean + + + + + + + + + + amount + numeric(6,2) + + + + + + + + + + note + text + + + + + + + + + + payment_type + name + + + + + + + + + + + + + + + + + + + + + transaction_billing_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_billing_type + text + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + total_owed + numeric + + + + + + + + + + + + + + + + + + + + + transaction_billing_type_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_billing_type + text + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + total_owed + numeric + + + + + + + + + + + + + + + + + + + + + transaction_billing_with_void_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_billing_type + text + + + + + + + + + + last_billing_note + text + + + + + + + + + + last_billing_ts + timestamp with time zone + + + + + + + + + + total_owed + numeric + + + + + + + + + + + + + + + + + + + + + transaction_payment_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_payment_type + name + + + + + + + + + + last_payment_note + text + + + + + + + + + + last_payment_ts + timestamp with time zone + + + + + + + + + + total_paid + numeric + + + + + + + + + + + + + + + + + + + + + transaction_payment_with_void_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + last_payment_type + name + + + + + + + + + + last_payment_note + text + + + + + + + + + + last_payment_ts + timestamp with time zone + + + + + + + + + + total_paid + numeric + + + + + + + + + + + + + + + + + + + + + usr_circulation_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + usr + integer + + + + + + + + + + total_paid + numeric + + + + + + + + + + total_owed + numeric + + + + + + + + + + balance_owed + numeric + + + + + + + + + + + + + + + + + + + + + usr_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + usr + integer + + + + + + + + + + total_paid + numeric + + + + + + + + + + total_owed + numeric + + + + + + + + + + balance_owed + numeric + + + + + + + + + + + + + + + + + + + + + work_payment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('payment_id_seq'::regclass); + + + + + + + + + xact + bigint + + + + NOT NULL; + + + + + + + + payment_ts + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + voided + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + amount + numeric(6,2) + + + + NOT NULL; + + + + + + + + note + text + + + + + + + + + + amount_collected + numeric(6,2) + + + + NOT NULL; + + + + + + + + accepting_usr + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + +
+ +
+ Schema offline + + + script + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + session + text + + + + NOT NULL; + + + + + + + + requestor + integer + + + + NOT NULL; + + + + + + + + create_time + integer + + + + NOT NULL; + + + + + + + + workstation + text + + + + NOT NULL; + + + + + + + + logfile + text + + + + NOT NULL; + + + + + + + + time_delta + integer + + + + NOT NULL; + + + + + + + + count + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + session + + + + + + + + Field + Data Type + Constraints and References + + + + + + key + text + + + + PRIMARY KEY + + + + + + + + + + + + + org + integer + + + + NOT NULL; + + + + + + + + description + text + + + + + + + + + + creator + integer + + + + NOT NULL; + + + + + + + + create_time + integer + + + + NOT NULL; + + + + + + + + in_process + integer + + + + NOT NULL; + + + + + + + + start_time + integer + + + + + + + + + + end_time + integer + + + + + + + + + + num_complete + integer + + + + NOT NULL; + + + + + + + + + + + + + + + + + +
+ +
+ Schema permission + + + grp_penalty_threshold + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + grp + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + org_unit + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + penalty + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + threshold + numeric(8,2) + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + grp_perm_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + grp + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + perm + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + depth + integer + + + + NOT NULL; + + + + + + + + grantable + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + + + + grp_tree + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + name + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + parent + integer + + + + + + + + + + + + + + + + + usergroup + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + perm_interval + interval + + + + NOT NULL; + + + DEFAULT '3 years'::interval; + + + + + + + description + text + + + + + + + + + + application_perm + text + + + + + + + + + + + + + + + + + + Tables referencing actor.usr via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + perm_list + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + code + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + description + text + + + + + + + + + + + + + + + + + + Tables referencing permission.grp_perm_map via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + usr_grp_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + grp + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + + + usr_object_perm_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + perm + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + object_type + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + object_id + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + grantable + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + + + + usr_perm_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + perm + integer + + + + + UNIQUE#1 + ; + + + + + + + NOT NULL; + + + + + + + + + + + + + + depth + integer + + + + NOT NULL; + + + + + + + + grantable + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + + + + usr_work_ou_map + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + usr + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + work_ou + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + + + +
+
+ Schema reporter + + + circ_type + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + type + text + + + + + + + + + + + + + + + + + currently_running + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + + + + + + + runner_barcode + text + + + + + + + + + + name + text + + + + + + + + + + run_time + timestamp with time zone + + + + + + + + + + scheduled_wait_time + interval + + + + + + + + + + + + + + + + + + + + + demographic + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + + + + + + + dob + timestamp with time zone + + + + + + + + + + general_division + text + + + + + + + + + + + + + + + + + + + + + hold_request_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + + + + + + + target + bigint + + + + + + + + + + hold_type + text + + + + + + + + + + bib_record + bigint + + + + + + + + + + + + + + + + + + + + + materialized_simple_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + + + + + + + + fingerprint + text + + + + + + + + + + quality + integer + + + + + + + + + + tcn_source + text + + + + + + + + + + tcn_value + text + + + + + + + + + + title + text + + + + + + + + + + author + text + + + + + + + + + + publisher + text + + + + + + + + + + pubdate + text + + + + + + + + + + isbn + text[] + + + + + + + + + + issn + text[] + + + + + + + + + + + + + + + + + + + + + old_super_simple_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + fingerprint + text + + + + + + + + + + quality + integer + + + + + + + + + + tcn_source + text + + + + + + + + + + tcn_value + text + + + + + + + + + + title + text + + + + + + + + + + author + text + + + + + + + + + + publisher + text + + + + + + + + + + pubdate + text + + + + + + + + + + isbn + text[] + + + + + + + + + + issn + text[] + + + + + + + + + + + + + + + + + + + + + output_folder + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + parent + integer + + + + + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + name + text + + + + NOT NULL; + + + + + + + + shared + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + share_with + integer + + + + + + + + + + + + + + + + + + + + + + + + + Tables referencing reporter.output_folder via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + overdue_circs + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + target_copy + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + circ_staff + integer + + + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + + + + + + + desk_renewal + boolean + + + + + + + + + + opac_renewal + boolean + + + + + + + + + + duration_rule + text + + + + + + + + + + recuring_fine_rule + text + + + + + + + + + + max_fine_rule + text + + + + + + + + + + stop_fines + text + + + + + + + + + + + + + + + + + + + + + overdue_reports + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + + + + + + + runner_barcode + text + + + + + + + + + + name + text + + + + + + + + + + run_time + timestamp with time zone + + + + + + + + + + scheduled_wait_time + interval + + + + + + + + + + + + + + + + + + + + + pending_reports + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + integer + + + + + + + + + + runner_barcode + text + + + + + + + + + + name + text + + + + + + + + + + run_time + timestamp with time zone + + + + + + + + + + scheduled_wait_time + interval + + + + + + + + + + + + + + + + + + + + + report + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + name + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + description + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + template + integer + + + + + + + NOT NULL; + + + + + + + + + + + + data + text + + + + NOT NULL; + + + + + + + + folder + integer + + + + + + + NOT NULL; + + + + + + + + + + + + recur + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + recurance + interval + + + + + + + + + + + + + + + + + + Tables referencing reporter.schedule via Foreign Key Constraints + + + + + + + + + + + + + + + + report_folder + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + parent + integer + + + + + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + name + text + + + + NOT NULL; + + + + + + + + shared + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + share_with + integer + + + + + + + + + + + + + + + + + + + + + + + + + Tables referencing reporter.report via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + schedule + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + report + integer + + + + + + + NOT NULL; + + + + + + + + + + + + folder + integer + + + + + + + NOT NULL; + + + + + + + + + + + + runner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + run_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + start_time + timestamp with time zone + + + + + + + + + + complete_time + timestamp with time zone + + + + + + + + + + email + text + + + + + + + + + + excel_format + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + html_format + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + csv_format + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + chart_pie + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + chart_bar + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + chart_line + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + error_code + integer + + + + + + + + + + error_text + text + + + + + + + + + + + + + + + + + + + + + simple_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + metarecord + bigint + + + + + + + + + + fingerprint + text + + + + + + + + + + quality + integer + + + + + + + + + + tcn_source + text + + + + + + + + + + tcn_value + text + + + + + + + + + + title + text + + + + + + + + + + uniform_title + text + + + + + + + + + + author + text + + + + + + + + + + publisher + text + + + + + + + + + + pubdate + text + + + + + + + + + + series_title + text + + + + + + + + + + series_statement + text + + + + + + + + + + summary + text + + + + + + + + + + isbn + text[] + + + + + + + + + + issn + text[] + + + + + + + + + + topic_subject + text[] + + + + + + + + + + geographic_subject + text[] + + + + + + + + + + genre + text[] + + + + + + + + + + name_subject + text[] + + + + + + + + + + corporate_subject + text[] + + + + + + + + + + external_uri + text[] + + + + + + + + + + + + + + + + + + + + + super_simple_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + fingerprint + text + + + + + + + + + + quality + integer + + + + + + + + + + tcn_source + text + + + + + + + + + + tcn_value + text + + + + + + + + + + title + text + + + + + + + + + + author + text + + + + + + + + + + publisher + text + + + + + + + + + + pubdate + text + + + + + + + + + + isbn + text[] + + + + + + + + + + issn + text[] + + + + + + + + + + + + + + + + + + + + + template + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + name + text + + + + NOT NULL; + + + + + + + + description + text + + + + NOT NULL; + + + + + + + + data + text + + + + NOT NULL; + + + + + + + + folder + integer + + + + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + Tables referencing reporter.report via Foreign Key Constraints + + + + + + + + + + + + + + + + template_folder + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + parent + integer + + + + + + + + + + + + + + + + + owner + integer + + + + + + + NOT NULL; + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + name + text + + + + NOT NULL; + + + + + + + + shared + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + share_with + integer + + + + + + + + + + + + + + + + + + + + + + + + + Tables referencing reporter.template via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + xact_billing_totals + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + unvoided + numeric + + + + + + + + + + voided + numeric + + + + + + + + + + total + numeric + + + + + + + + + + + + + + + + + + + + + xact_paid_totals + + + + + + + + Field + Data Type + Constraints and References + + + + + + xact + bigint + + + + + + + + + + unvoided + numeric + + + + + + + + + + voided + numeric + + + + + + + + + + total + numeric + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema search + + + relevance_adjustment + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + field + integer + + + + + + + NOT NULL; + + + + + + + + + + + + bump_type + text + + + + NOT NULL; + + + + + + + + multiplier + numeric + + + + NOT NULL; + + + DEFAULT 1.0; + + + + + + + + + + + + + Constraints on relevance_adjustment + + + relevance_adjustment_bump_type_check + CHECK ((bump_type = ANY (ARRAY['word_order'::text, 'first_word'::text, 'full_match'::text]))) + + + + + + + + + + + +
+ +
+ Schema serial + + + bib_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + subscription + integer + + + + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + generated_coverage + text + + + + NOT NULL; + + + + + + + + textual_holdings + text + + + + + + + + + + + + + + + + + + + + + binding_unit + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + subscription + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + label + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + Tables referencing serial.issuance via Foreign Key Constraints + + + + + + + + + + + + + + + + index_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + subscription + integer + + + + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + generated_coverage + text + + + + NOT NULL; + + + + + + + + textual_holdings + text + + + + + + + + + + + + + + + + + + + + + issuance + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + subscription + integer + + + + + + + NOT NULL; + + + + + + + + + + + + target_copy + bigint + + + + + + + + + + + + + + + + + location + bigint + + + + + + + + + + + + + + + + + binding_unit + integer + + + + + + + + + + + + + + + + + label + text + + + + + + + + + + + + + + + + + + + + + record_entry + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + + + + + + + + + + + owning_lib + integer + + + + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + + + + + creator + integer + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + editor + integer + + + + NOT NULL; + + + DEFAULT 1; + + + + + + + source + integer + + + + + + + + + + create_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + edit_date + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + active + boolean + + + + NOT NULL; + + + DEFAULT true; + + + + + + + deleted + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + last_xact_id + text + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + subscription + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + callnumber + bigint + + + + + + + + + + + + + + + + + uri + integer + + + + + + + + + + + + + + + + + start_date + date + + + + NOT NULL; + + + + + + + + end_date + date + + + + + + + + + + + + + + + + + + Tables referencing serial.bib_summary via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + sup_summary + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + subscription + integer + + + + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + + + + + generated_coverage + text + + + + NOT NULL; + + + + + + + + textual_holdings + text + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema stats + + + fleshed_call_number + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + creator + bigint + + + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + editor + bigint + + + + + + + + + + edit_date + timestamp with time zone + + + + + + + + + + record + bigint + + + + + + + + + + owning_lib + integer + + + + + + + + + + label + text + + + + + + + + + + deleted + boolean + + + + + + + + + + create_date_day + date + + + + + + + + + + edit_date_day + date + + + + + + + + + + create_date_hour + timestamp with time zone + + + + + + + + + + edit_date_hour + timestamp with time zone + + + + + + + + + + item_lang + text + + + + + + + + + + item_type + text + + + + + + + + + + item_form + text + + + + + + + + + + + + + + + + + + + + + fleshed_circulation + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + usr + integer + + + + + + + + + + xact_start + timestamp with time zone + + + + + + + + + + xact_finish + timestamp with time zone + + + + + + + + + + unrecovered + boolean + + + + + + + + + + target_copy + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + circ_staff + integer + + + + + + + + + + checkin_staff + integer + + + + + + + + + + checkin_lib + integer + + + + + + + + + + renewal_remaining + integer + + + + + + + + + + due_date + timestamp with time zone + + + + + + + + + + stop_fines_time + timestamp with time zone + + + + + + + + + + checkin_time + timestamp with time zone + + + + + + + + + + create_time + timestamp with time zone + + + + + + + + + + duration + interval + + + + + + + + + + fine_interval + interval + + + + + + + + + + recuring_fine + numeric(6,2) + + + + + + + + + + max_fine + numeric(6,2) + + + + + + + + + + phone_renewal + boolean + + + + + + + + + + desk_renewal + boolean + + + + + + + + + + opac_renewal + boolean + + + + + + + + + + duration_rule + text + + + + + + + + + + recuring_fine_rule + text + + + + + + + + + + max_fine_rule + text + + + + + + + + + + stop_fines + text + + + + + + + + + + start_date_day + date + + + + + + + + + + finish_date_day + date + + + + + + + + + + start_date_hour + timestamp with time zone + + + + + + + + + + finish_date_hour + timestamp with time zone + + + + + + + + + + call_number_label + text + + + + + + + + + + owning_lib + integer + + + + + + + + + + item_lang + text + + + + + + + + + + item_type + text + + + + + + + + + + item_form + text + + + + + + + + + + + + + + + + + + + + + fleshed_copy + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + + + + + + + circ_lib + integer + + + + + + + + + + creator + bigint + + + + + + + + + + call_number + bigint + + + + + + + + + + editor + bigint + + + + + + + + + + create_date + timestamp with time zone + + + + + + + + + + edit_date + timestamp with time zone + + + + + + + + + + copy_number + integer + + + + + + + + + + status + integer + + + + + + + + + + location + integer + + + + + + + + + + loan_duration + integer + + + + + + + + + + fine_level + integer + + + + + + + + + + age_protect + integer + + + + + + + + + + circulate + boolean + + + + + + + + + + deposit + boolean + + + + + + + + + + ref + boolean + + + + + + + + + + holdable + boolean + + + + + + + + + + deposit_amount + numeric(6,2) + + + + + + + + + + price + numeric(8,2) + + + + + + + + + + barcode + text + + + + + + + + + + circ_modifier + text + + + + + + + + + + circ_as_type + text + + + + + + + + + + dummy_title + text + + + + + + + + + + dummy_author + text + + + + + + + + + + alert_message + text + + + + + + + + + + opac_visible + boolean + + + + + + + + + + deleted + boolean + + + + + + + + + + create_date_day + date + + + + + + + + + + edit_date_day + date + + + + + + + + + + create_date_hour + timestamp with time zone + + + + + + + + + + edit_date_hour + timestamp with time zone + + + + + + + + + + call_number_label + text + + + + + + + + + + owning_lib + integer + + + + + + + + + + item_lang + text + + + + + + + + + + item_type + text + + + + + + + + + + item_form + text + + + + + + + + + + + + + + + + + + + +
+ +
+ Schema vandelay + + + authority_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + code + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + description + text + + + + + + + + + + xpath + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing vandelay.queued_authority_record_attr via Foreign Key Constraints + + + + + + + + + + + + + + + + authority_match + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + matched_attr + integer + + + + + + + + + + + + + + + + + queued_record + bigint + + + + + + + + + + + + + + + + + eg_record + bigint + + + + + + + + + + + + + + + + + + + + + + + + + + + + authority_queue + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('queue_id_seq'::regclass); + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + complete + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + queue_type + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT 'authority'::text; + + + + + + + + + + + + + + + Constraints on authority_queue + + + authority_queue_queue_type_check + CHECK ((queue_type = 'authority'::text)) + + + + + + queue_queue_type_check + CHECK ((queue_type = ANY (ARRAY['bib'::text, 'authority'::text]))) + + + + + + + + + + Tables referencing vandelay.queued_authority_record via Foreign Key Constraints + + + + + + + + + + + + + + + + bib_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + serial + + + + PRIMARY KEY + + + + + + + + + + + + + code + text + + + + + UNIQUE; + + + + NOT NULL; + + + + + + + + + + description + text + + + + + + + + + + xpath + text + + + + NOT NULL; + + + + + + + + remove + text + + + + NOT NULL; + + + DEFAULT ''::text; + + + + + + + ident + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + + + + + + + + + Tables referencing vandelay.queued_bib_record_attr via Foreign Key Constraints + + + + + + + + + + + + + + + + bib_match + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + field_type + text + + + + NOT NULL; + + + + + + + + matched_attr + integer + + + + + + + + + + + + + + + + + queued_record + bigint + + + + + + + + + + + + + + + + + eg_record + bigint + + + + + + + + + + + + + + + + + + + + + + + Constraints on bib_match + + + bib_match_field_type_check + CHECK ((field_type = ANY (ARRAY['isbn'::text, 'tcn_value'::text, 'id'::text]))) + + + + + + + + + + + + + bib_queue + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('queue_id_seq'::regclass); + + + + + + + + + owner + integer + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + complete + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + queue_type + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT 'bib'::text; + + + + + + + + + item_attr_def + bigint + + + + + + + + + + + + + + + + + + + + + + + Constraints on bib_queue + + + bib_queue_queue_type_check + CHECK ((queue_type = 'bib'::text)) + + + + + + queue_queue_type_check + CHECK ((queue_type = ANY (ARRAY['bib'::text, 'authority'::text]))) + + + + + + + + + + Tables referencing vandelay.queued_bib_record via Foreign Key Constraints + + + + + + + + + + + + + + + + import_bib_trash_fields + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + field + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + + + + + + + + import_item + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + definition + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + owning_lib + integer + + + + + + + + + + circ_lib + integer + + + + + + + + + + call_number + text + + + + + + + + + + copy_number + integer + + + + + + + + + + status + integer + + + + + + + + + + location + integer + + + + + + + + + + circulate + boolean + + + + + + + + + + deposit + boolean + + + + + + + + + + deposit_amount + numeric(8,2) + + + + + + + + + + ref + boolean + + + + + + + + + + holdable + boolean + + + + + + + + + + price + numeric(8,2) + + + + + + + + + + barcode + text + + + + + + + + + + circ_modifier + text + + + + + + + + + + circ_as_type + text + + + + + + + + + + alert_message + text + + + + + + + + + + pub_note + text + + + + + + + + + + priv_note + text + + + + + + + + + + opac_visible + boolean + + + + + + + + + + + + + + + + + + + + + import_item_attr_definition + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + tag + text + + + + NOT NULL; + + + + + + + + keep + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + owning_lib + text + + + + + + + + + + circ_lib + text + + + + + + + + + + call_number + text + + + + + + + + + + copy_number + text + + + + + + + + + + status + text + + + + + + + + + + location + text + + + + + + + + + + circulate + text + + + + + + + + + + deposit + text + + + + + + + + + + deposit_amount + text + + + + + + + + + + ref + text + + + + + + + + + + holdable + text + + + + + + + + + + price + text + + + + + + + + + + barcode + text + + + + + + + + + + circ_modifier + text + + + + + + + + + + circ_as_type + text + + + + + + + + + + alert_message + text + + + + + + + + + + opac_visible + text + + + + + + + + + + pub_note_title + text + + + + + + + + + + pub_note + text + + + + + + + + + + priv_note_title + text + + + + + + + + + + priv_note + text + + + + + + + + + + + + + + + + + + Tables referencing vandelay.bib_queue via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + queue + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + owner + integer + + + + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + + + + + name + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + + + + + + + + complete + boolean + + + + NOT NULL; + + + DEFAULT false; + + + + + + + queue_type + text + + + + + UNIQUE#1 + ; + + + + NOT NULL; + + + DEFAULT 'bib'::text; + + + + + + + + + + + + + + + Constraints on queue + + + queue_queue_type_check + CHECK ((queue_type = ANY (ARRAY['bib'::text, 'authority'::text]))) + + + + + + + + + + + + + queued_authority_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('queued_record_id_seq'::regclass); + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + import_time + timestamp with time zone + + + + + + + + + + purpose + text + + + + NOT NULL; + + + DEFAULT 'import'::text; + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + queue + integer + + + + + + + NOT NULL; + + + + + + + + + + + + imported_as + integer + + + + + + + + + + + + + + + + + + + + + + + Constraints on queued_authority_record + + + queued_record_purpose_check + CHECK ((purpose = ANY (ARRAY['import'::text, 'overlay'::text]))) + + + + + + + + + + Tables referencing vandelay.authority_match via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + queued_authority_record_attr + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + field + integer + + + + + + + NOT NULL; + + + + + + + + + + + + attr_value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing vandelay.authority_match via Foreign Key Constraints + + + + + + + + + + + + + + + + queued_bib_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigint + + + + PRIMARY KEY + + + + + + DEFAULT nextval('queued_record_id_seq'::regclass); + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + import_time + timestamp with time zone + + + + + + + + + + purpose + text + + + + NOT NULL; + + + DEFAULT 'import'::text; + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + queue + integer + + + + + + + NOT NULL; + + + + + + + + + + + + bib_source + integer + + + + + + + + + + + + + + + + + imported_as + integer + + + + + + + + + + + + + + + + + + + + + + + Constraints on queued_bib_record + + + queued_record_purpose_check + CHECK ((purpose = ANY (ARRAY['import'::text, 'overlay'::text]))) + + + + + + + + + + Tables referencing vandelay.bib_match via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + queued_bib_record_attr + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + record + bigint + + + + + + + NOT NULL; + + + + + + + + + + + + field + integer + + + + + + + NOT NULL; + + + + + + + + + + + + attr_value + text + + + + NOT NULL; + + + + + + + + + + + + + + + + Tables referencing vandelay.bib_match via Foreign Key Constraints + + + + + + + + + + + + + + + + queued_record + + + + + + + + Field + Data Type + Constraints and References + + + + + + id + bigserial + + + + PRIMARY KEY + + + + + + + + + + + + + create_time + timestamp with time zone + + + + NOT NULL; + + + DEFAULT now(); + + + + + + + import_time + timestamp with time zone + + + + + + + + + + purpose + text + + + + NOT NULL; + + + DEFAULT 'import'::text; + + + + + + + marc + text + + + + NOT NULL; + + + + + + + + + + + + + + Constraints on queued_record + + + queued_record_purpose_check + CHECK ((purpose = ANY (ARRAY['import'::text, 'overlay'::text]))) + + + + + + + + + + + +
+ + + diff --git a/1.6/intro/releasenotes.xml b/1.6/intro/releasenotes.xml index 1db9488432..693a21c43c 100644 --- a/1.6/intro/releasenotes.xml +++ b/1.6/intro/releasenotes.xml @@ -4,6 +4,50 @@ Release Notes + + + + 1.6.0.8 + + New features + + Added index for case insensitive barcode searching (1.6.0.7) for speed. + Move to BibTemplate for general title detail display, not just overlay of MVR-based display. + + + + Bug fixes + + Offline transaction timestamp and export fixes. + More configuration interface improvements. + Printing improvements to avoid the dreaded inner print_tree errors. + Fix Google Books full-text functionality. + User Editor improvements (addresses, appropriate required fields). + + + + + 1.6.0.7 + + New features + + Made barcode searching from the general user search interface case insensitive + + + + Bug fixes + + FIFO Holds Org Setting name in the Library Settings Editor did not match that used by the SQL – repaired. + Repaired Authority Record ingest. + Backdating timestamp format bug fixed – patch from James Fournie at SITKA. + Configuration interface bugs addressed (ongoing improvement from 1.6.0.4). + Action/Trigger (notifications, etc) bugs addressed. + In-Database record merging bug fixes (indicators, Located URIs) + In-Database hold testing stored procedure bug fixed – patch from John Craig. + + + + 1.6.0.6 diff --git a/1.6/root.xml b/1.6/root.xml index b854936c91..638207e9f8 100755 --- a/1.6/root.xml +++ b/1.6/root.xml @@ -114,7 +114,8 @@ Appendices - + + diff --git a/tools/docbookConvert.sh b/tools/docbookConvert.sh new file mode 100755 index 0000000000..51b5f914d7 --- /dev/null +++ b/tools/docbookConvert.sh @@ -0,0 +1,16 @@ +#/bin/bash + +#generate draft html + xsltproc --xinclude --stringparam base.dir /openils/var/web/evergreen_documentation/draft/html/ /home/rsoulliere/doctools/EvergreenDocumentation/evergreen_docbook_files/evergreen_xhtml.xsl /home/rsoulliere/doctools/EvergreenDocumentation/root.xml + + +#Generate PDF via FO +xsltproc --xinclude --output /home/rsoulliere/doctools/EvergreenDocumentation/pdf/temp.fo /home/rsoulliere/doctools/EvergreenDocumentation/evergreen_docbook_files/evergreen_fo.xsl /home/rsoulliere/doctools/EvergreenDocumentation/root.xml + +# must run fop from same directory as root.xml +cd /home/rsoulliere/doctools/EvergreenDocumentation/ + + ~/doctools/fop/fop -fo pdf/temp.fo -pdf /openils/var/web/evergreen_documentation/draft/pdf/Evergreen_Documentation.pdf + +# remove temporary .fo file +rm pdf/temp.fo diff --git a/tools/xml.tmpl b/tools/xml.tmpl new file mode 100644 index 0000000000..7758a8f9e4 --- /dev/null +++ b/tools/xml.tmpl @@ -0,0 +1,129 @@ + + + Database Schema + This is the schema for the Evergreen database. + +
"> + Schema <!-- TMPL_VAR name="schema_dbk" --> + + " xreflabel="."> + <!-- TMPL_VAR name="table_dbk" --> + + + + + + + + Field + Data Type + Constraints and References + + + + + + + + + + + PRIMARY KEY + + + UNIQUE# + ; + + + + NOT NULL; + + + DEFAULT ; + + + + "/> + + + + + + + + + + + + + Constraints on <!-- TMPL_VAR name="table_dbk" --> + + + + + + + + + + + + + + Tables referencing <!-- TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="fk_schema_dbk" -->.<!-- /TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="fk_table_dbk" --> via Foreign Key Constraints + + + + "/> + + + + + + + + + + Permissions on <!-- TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="schema" -->.<!-- /TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR name="table_dbk" --> + + + + + + + + Select + + + Insert + + + Update + + + Delete + + + Rule + + + References + + + Trigger + + + + + + + + + + + + +
+ + + -- 2.43.2