| Column name | Table | Key | Data type | Not NULL | Refers to |
| accepting_usr | forgive_payment | | INTEGER | Yes | |
| accepting_usr | goods_payment | | INTEGER | Yes | |
| accepting_usr | credit_payment | | INTEGER | Yes | |
| accepting_usr | credit_card_payment | | INTEGER | Yes | |
| accepting_usr | cash_payment | | INTEGER | Yes | |
| accepting_usr | bnm_desk_payment | | INTEGER | Yes | |
| accepting_usr | check_payment | | INTEGER | Yes | |
| accepting_usr | bnm_payment | | INTEGER | Yes | |
| accepting_usr | work_payment | | INTEGER | Yes | |
| active | relevance_adjustment | | BOOLEAN | Yes | |
| active | record_entry | | BOOLEAN | Yes | |
| active | record_entry | | BOOLEAN | Yes | |
| active | record_entry | | BOOLEAN | Yes | |
| active | usr | | BOOLEAN | Yes | |
| active | event_definition | | BOOLEAN | Yes | |
| active | uri | | BOOLEAN | Yes | |
| active | card | | BOOLEAN | Yes | |
| active | circ_matrix_matchpoint | | BOOLEAN | Yes | |
| active | hold_matrix_matchpoint | | BOOLEAN | Yes | |
| address_type | org_address | | TEXT | Yes | |
| address_type | usr_address | | TEXT | Yes | |
| address_type | provider_contact_address | | TEXT | No | |
| address_type | provider_address | | TEXT | No | |
| add_time | event | | TIMESTAMP WITH TIME ZONE | Yes | |
| age | rule_age_hold_protect | | INTERVAL | Yes | |
| age_hold_protect_rule | hold_matrix_matchpoint | FK | INTEGER | No | rule_age_hold_protect.id |
| age_protect | asset.copy | | INTEGER | No | |
| alert_message | asset.copy | | TEXT | No | |
| alert_message | usr | | TEXT | No | |
| alert_message | import_item | | TEXT | No | |
| alert_message | import_item_attr_definition | | TEXT | No | |
| alias | usr | | TEXT | No | |
| allocator | fund_allocation | FK | INTEGER | Yes | usr.id |
| amount | forgive_payment | | NUMERIC(6, 2) | Yes | |
| amount | cash_payment | | NUMERIC(6, 2) | Yes | |
| amount | payment | | NUMERIC(6, 2) | Yes | |
| amount | credit_payment | | NUMERIC(6, 2) | Yes | |
| amount | billing | | NUMERIC(6, 2) | Yes | |
| amount | rule_max_fine | | NUMERIC(6, 2) | Yes | |
| amount | funding_source_credit | | NUMERIC | Yes | |
| amount | fund_allocation | | NUMERIC | No | |
| amount | bnm_payment | | NUMERIC(6, 2) | Yes | |
| amount | fund_debit | | NUMERIC | Yes | |
| amount | goods_payment | | NUMERIC(6, 2) | Yes | |
| amount | work_payment | | NUMERIC(6, 2) | Yes | |
| amount | bnm_desk_payment | | NUMERIC(6, 2) | Yes | |
| amount | check_payment | | NUMERIC(6, 2) | Yes | |
| amount | credit_card_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | goods_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | work_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | cash_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | credit_card_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | forgive_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | bnm_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | bnm_desk_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | check_payment | | NUMERIC(6, 2) | Yes | |
| amount_collected | credit_payment | | NUMERIC(6, 2) | Yes | |
| answer | survey_answer | | TEXT | Yes | |
| answer | survey_response | FK | INTEGER | Yes | survey_answer.id |
| answer_date | survey_response | | TIMESTAMP | No | |
| application_perm | grp_tree | | TEXT | No | |
| approval_code | credit_card_payment | | TEXT | No | |
| arn_source | record_entry | | TEXT | Yes | |
| arn_value | record_entry | | TEXT | Yes | |
| attr_name | lineitem_attr | | TEXT | Yes | |
| attr_type | lineitem_attr | | TEXT | Yes | |
| attr_value | lineitem_attr | | TEXT | Yes | |
| attr_value | queued_bib_record_attr | | TEXT | Yes | |
| attr_value | queued_authority_record_attr | | TEXT | Yes | |
| audience | rec_descriptor | | TEXT | No | |
| auth | z3950_source | | BOOLEAN | Yes | |
| barcode | import_item_attr_definition | | TEXT | No | |
| barcode | card | | TEXT | Yes | |
| barcode | asset.copy | | TEXT | Yes | |
| barcode | lineitem_detail | | TEXT | No | |
| barcode | import_item | | TEXT | No | |
| barred | usr | | BOOLEAN | Yes | |
| bib_level | rec_descriptor | | TEXT | No | |
| bib_source | queued_bib_record | FK | INTEGER | No | bib_source.id |
| billing_address | org_unit | FK | INTEGER | No | org_address.id |
| billing_address | usr | FK | INTEGER | No | usr_address.id |
| billing_location | grocery | | INTEGER | Yes | |
| billing_ts | billing | | TIMESTAMP | Yes | |
| billing_type | billing | | TEXT | Yes | |
| binding_unit | issuance | FK | INTEGER | No | binding_unit.id |
| block_list | standing_penalty | | TEXT | No | |
| btype | call_number_bucket | FK | TEXT | Yes | call_number_bucket_type.code |
| btype | copy_bucket | FK | TEXT | Yes | copy_bucket_type.code |
| btype | user_bucket | FK | TEXT | Yes | user_bucket_type.code |
| btype | billing | FK | INTEGER | Yes | billing_type.id |
| btype | biblio_record_entry_bucket | FK | TEXT | Yes | biblio_record_entry_bucket_type.code |
| bucket | copy_bucket_item | FK | INTEGER | Yes | copy_bucket.id |
| bucket | copy_bucket_note | FK | INTEGER | Yes | copy_bucket.id |
| bucket | biblio_record_entry_bucket_item | FK | INTEGER | Yes | biblio_record_entry_bucket.id |
| bucket | biblio_record_entry_bucket_note | FK | INTEGER | Yes | biblio_record_entry_bucket.id |
| bucket | user_bucket_item | FK | INTEGER | Yes | user_bucket.id |
| bucket | user_bucket_note | FK | INTEGER | Yes | user_bucket.id |
| bucket | call_number_bucket_item | FK | INTEGER | Yes | call_number_bucket.id |
| bucket | call_number_bucket_note | FK | INTEGER | Yes | call_number_bucket.id |
| bump_type | relevance_adjustment | | TEXT | Yes | |
| callnumber | subscription | FK | BIGINT | No | call_number.id |
| call_number | asset.copy | FK | BIGINT | Yes | call_number.id |
| call_number | import_item_attr_definition | | TEXT | No | |
| call_number | uri_call_number_map | FK | INTEGER | Yes | call_number.id |
| call_number | import_item | | TEXT | No | |
| call_number | call_number_note | FK | BIGINT | Yes | call_number.id |
| cancel_cause | hold_request | FK | INTEGER | No | hold_request_cancel_cause.id |
| cancel_note | hold_request | | TEXT | No | |
| cancel_time | hold_request | | TIMESTAMP | No | |
| can_have_users | org_unit_type | | BOOLEAN | Yes | |
| can_have_vols | org_unit_type | | BOOLEAN | Yes | |
| capture_time | hold_request | | TIMESTAMP | No | |
| card | usr | | INTEGER | No | |
| cash_drawer | credit_card_payment | | INTEGER | No | |
| cash_drawer | cash_payment | | INTEGER | No | |
| cash_drawer | check_payment | | INTEGER | No | |
| cash_drawer | bnm_desk_payment | FK | INTEGER | No | workstation.id |
| cat_form | rec_descriptor | | TEXT | No | |
| cc_number | credit_card_payment | | TEXT | No | |
| cc_type | credit_card_payment | | TEXT | No | |
| char_encoding | rec_descriptor | | TEXT | No | |
| char_encoding | rec_descriptor | | TEXT | No | |
| checkin_lib | circulation | FK | INTEGER | No | org_unit.id |
| checkin_lib | aged_circulation | | INTEGER | No | |
| checkin_staff | aged_circulation | | INTEGER | No | |
| checkin_staff | circulation | FK | INTEGER | No | usr.id |
| checkin_time | aged_circulation | | TIMESTAMP | No | |
| checkin_time | circulation | | TIMESTAMP | No | |
| checkin_time | hold_request | | TIMESTAMP | No | |
| check_number | check_payment | | TEXT | Yes | |
| circulate | import_item | | BOOLEAN | No | |
| circulate | copy_location | | BOOLEAN | Yes | |
| circulate | copy_transparency | | BOOLEAN | No | |
| circulate | import_item_attr_definition | | TEXT | No | |
| circulate | circ_matrix_matchpoint | | BOOLEAN | Yes | |
| circulate | asset.copy | | BOOLEAN | Yes | |
| circ_as_type | import_item_attr_definition | | TEXT | No | |
| circ_as_type | import_item | | TEXT | No | |
| circ_as_type | copy_transparency | | TEXT | No | |
| circ_as_type | asset.copy | | TEXT | No | |
| circ_duration | non_cataloged_type | | INTERVAL | Yes | |
| circ_lib | aged_circulation | | INTEGER | Yes | |
| circ_lib | asset.copy | FK | INTEGER | Yes | org_unit.id |
| circ_lib | unfulfilled_hold_list | | INTEGER | Yes | |
| circ_lib | circulation | FK | INTEGER | Yes | org_unit.id, org_unit.id |
| circ_lib | non_cataloged_circulation | FK | INTEGER | Yes | org_unit.id |
| circ_lib | copy_transparency | FK | INTEGER | No | org_unit.id |
| circ_lib | import_item_attr_definition | | TEXT | No | |
| circ_lib | import_item | | INTEGER | No | |
| circ_mod | circ_matrix_circ_mod_test_map | FK | TEXT | Yes | circ_modifier.code |
| circ_modifier | import_item | | TEXT | No | |
| circ_modifier | import_item_attr_definition | | TEXT | No | |
| circ_modifier | asset.copy | | TEXT | No | |
| circ_modifier | lineitem_detail | FK | TEXT | No | circ_modifier.code |
| circ_modifier | copy_transparency | | TEXT | No | |
| circ_modifier | circ_matrix_matchpoint | FK | TEXT | No | circ_modifier.code |
| circ_modifier | hold_matrix_matchpoint | FK | TEXT | No | circ_modifier.code |
| circ_mod_test | circ_matrix_circ_mod_test_map | FK | INTEGER | Yes | circ_matrix_circ_mod_test.id |
| circ_staff | aged_circulation | | INTEGER | Yes | |
| circ_staff | circulation | FK | INTEGER | Yes | usr.id |
| circ_time | non_cataloged_circulation | | TIMESTAMP | Yes | |
| city | org_address | | TEXT | Yes | |
| city | usr_address | | TEXT | Yes | |
| city | provider_contact_address | | TEXT | Yes | |
| city | provider_address | | TEXT | Yes | |
| claims_returned_count | usr | | INTEGER | Yes | |
| cleanup_failure | event_definition | FK | CHARACTER(40) | No | cleanup.module |
| cleanup_success | event_definition | FK | TEXT | No | cleanup.module |
| close_end | org_unit_closed | | TIMESTAMP | Yes | |
| close_start | org_unit_closed | | TIMESTAMP | Yes | |
| cn_label | lineitem_detail | | TEXT | No | |
| code | provider | | TEXT | No | |
| code | lineitem_generated_attr_definition | | TEXT | Yes | |
| code | funding_source | | TEXT | No | |
| code | fund | | TEXT | No | |
| code | bib_attr_definition | | TEXT | Yes | |
| code | currency_type | PK | TEXT | Yes | |
| code | circ_modifier | PK | TEXT | Yes | |
| code | circ_matrix_matchpoint | | TEXT | No | |
| code | authority_attr_definition | | TEXT | Yes | |
| code | videorecording_format_map | PK | TEXT | Yes | |
| code | lineitem_usr_attr_definition | | TEXT | Yes | |
| code | hold_matrix_matchpoint | | TEXT | No | |
| code | perm_list | | TEXT | Yes | |
| code | lineitem_local_attr_definition | | TEXT | Yes | |
| code | biblio_record_entry_bucket_type | PK | TEXT | Yes | |
| code | call_number_bucket_type | PK | TEXT | Yes | |
| code | z3950_attr | | INTEGER | Yes | |
| code | item_form_map | PK | TEXT | Yes | |
| code | item_type_map | PK | TEXT | Yes | |
| code | bib_level_map | PK | TEXT | Yes | |
| code | copy_bucket_type | PK | TEXT | Yes | |
| code | asset.copy | FK | TEXT | No | circ_modifier.code |
| code | lineitem_detail | | TEXT | No | |
| code | lineitem_attr_definition | | TEXT | Yes | |
| code | i18n_locale | PK | TEXT | Yes | |
| code | lineitem_provider_attr_definition | | TEXT | Yes | |
| code | lineitem_marc_attr_definition | | TEXT | Yes | |
| code | user_bucket_type | PK | TEXT | Yes | |
| code | lit_form_map | PK | TEXT | Yes | |
| code | audience_map | PK | TEXT | Yes | |
| code | language_map | PK | TEXT | Yes | |
| code | fund_debit | | TEXT | No | |
| collection_code | lineitem_detail | | TEXT | No | |
| collector | collections_tracker | FK | INTEGER | Yes | usr.id |
| collector | environment | FK | TEXT | No | collector.module |
| complete | queue | | BOOLEAN | Yes | |
| complete_time | event | | TIMESTAMP WITH TIME ZONE | No | |
| contact | provider_contact_address | FK | INTEGER | Yes | provider_contact.id |
| control_type | rec_descriptor | | TEXT | No | |
| copy_bib_record | aged_circulation | | BIGINT | Yes | |
| copy_call_number | aged_circulation | | INTEGER | Yes | |
| copy_circ_lib | aged_circulation | | INTEGER | Yes | |
| copy_location | aged_circulation | | INTEGER | Yes | |
| copy_number | import_item | | INTEGER | No | |
| copy_number | import_item_attr_definition | | TEXT | No | |
| copy_number | asset.copy | | INTEGER | No | |
| copy_owning_lib | aged_circulation | | INTEGER | Yes | |
| copy_status | hold_transit_copy | | INTEGER | Yes | |
| copy_status | transit_copy | FK | INTEGER | Yes | copy_status.id |
| core_type | hook | | TEXT | Yes | |
| count | script | | INTEGER | Yes | |
| country | provider_address | | TEXT | Yes | |
| country | provider_contact_address | | TEXT | Yes | |
| country | org_address | | TEXT | Yes | |
| country | usr_address | | TEXT | Yes | |
| county | usr_address | | TEXT | No | |
| county | provider_address | | TEXT | No | |
| county | provider_contact_address | | TEXT | No | |
| county | org_address | | TEXT | No | |
| create_date | record_note | | TIMESTAMP | Yes | |
| create_date | call_number | | TIMESTAMP | No | |
| create_date | record_note | | TIMESTAMP | Yes | |
| create_date | usr_note | | TIMESTAMP | No | |
| create_date | record_entry | | TIMESTAMP | Yes | |
| create_date | usr | | TIMESTAMP | Yes | |
| create_date | copy_note | | TIMESTAMP | No | |
| create_date | record_entry | | TIMESTAMP | Yes | |
| create_date | asset.copy | | TIMESTAMP | No | |
| create_date | record_entry | | TIMESTAMP | Yes | |
| create_date | call_number_note | | TIMESTAMP | No | |
| create_time | queued_record | | TIMESTAMP | Yes | |
| create_time | script | | INTEGER | Yes | |
| create_time | session | | INTEGER | Yes | |
| create_time | copy_bucket | | TIMESTAMP | Yes | |
| create_time | lineitem | | TIMESTAMP | Yes | |
| create_time | picklist | | TIMESTAMP | Yes | |
| create_time | call_number_bucket_item | | TIMESTAMP | Yes | |
| create_time | copy_bucket_item | | TIMESTAMP | Yes | |
| create_time | aged_circulation | | TIMESTAMP | Yes | |
| create_time | po_note | | TIMESTAMP | Yes | |
| create_time | lineitem_note | | TIMESTAMP | Yes | |
| create_time | purchase_order | | TIMESTAMP | Yes | |
| create_time | call_number_bucket | | TIMESTAMP | Yes | |
| create_time | circulation | | TIMESTAMP | Yes | |
| create_time | user_bucket_item | | TIMESTAMP | Yes | |
| create_time | biblio_record_entry_bucket | | TIMESTAMP | Yes | |
| create_time | fund_debit | | TIMESTAMP | Yes | |
| create_time | event_output | | TIMESTAMP WITH TIME ZONE | Yes | |
| create_time | biblio_record_entry_bucket_item | | TIMESTAMP | Yes | |
| create_time | fund_allocation | | TIMESTAMP | Yes | |
| create_time | user_bucket | | TIMESTAMP | Yes | |
| creator | usr_note | FK | BIGINT | Yes | usr.id |
| creator | record_entry | | INTEGER | Yes | |
| creator | lineitem_note | FK | INTEGER | Yes | usr.id |
| creator | record_note | FK | INTEGER | Yes | usr.id |
| creator | picklist | FK | INTEGER | Yes | usr.id |
| creator | asset.copy | FK | BIGINT | Yes | usr.id |
| creator | call_number_note | FK | BIGINT | Yes | usr.id |
| creator | po_note | | INTEGER | Yes | |
| creator | record_note | | INTEGER | Yes | |
| creator | record_entry | FK | INTEGER | Yes | usr.id |
| creator | call_number | | BIGINT | Yes | |
| creator | purchase_order | FK | INTEGER | Yes | usr.id |
| creator | record_entry | | INTEGER | Yes | |
| creator | copy_note | FK | BIGINT | Yes | usr.id |
| creator | lineitem | FK | INTEGER | Yes | usr.id |
| creator | session | | INTEGER | Yes | |
| credit_forward_balance | usr | | NUMERIC(6, 2) | Yes | |
| curent_copy | unfulfilled_hold_list | FK | BIGINT | Yes | asset.copy.id |
| currency_type | funding_source | FK | TEXT | Yes | currency_type.code |
| currency_type | provider | FK | TEXT | Yes | currency_type.code |
| currency_type | fund | FK | TEXT | Yes | currency_type.code |
| current_copy | hold_request | FK | BIGINT | No | asset.copy.id |
| data | event_output | | TEXT | Yes | |
| date1 | rec_descriptor | | TEXT | No | |
| date2 | rec_descriptor | | TEXT | No | |
| day_phone | usr | | TEXT | No | |
| db | z3950_source | | TEXT | Yes | |
| debit_type | fund_debit | | TEXT | Yes | |
| default_price | billing_type | | NUMERIC(6, 2) | No | |
| definition | lineitem_attr | FK | BIGINT | Yes | lineitem_attr_definition.id |
| definition | import_item | FK | BIGINT | Yes | import_item_attr_definition.id |
| delay | event_definition | | INTERVAL | Yes | |
| delay_field | event_definition | | TEXT | No | |
| deleted | record_entry | | BOOLEAN | Yes | |
| deleted | record_entry | | BOOLEAN | Yes | |
| deleted | call_number | | BOOLEAN | Yes | |
| deleted | usr | | BOOLEAN | Yes | |
| deleted | record_entry | | BOOLEAN | Yes | |
| deleted | asset.copy | | BOOLEAN | Yes | |
| deposit | import_item | | BOOLEAN | No | |
| deposit | copy_transparency | | BOOLEAN | No | |
| deposit | import_item_attr_definition | | TEXT | No | |
| deposit | asset.copy | | BOOLEAN | Yes | |
| deposit_amount | import_item_attr_definition | | TEXT | No | |
| deposit_amount | copy_transparency | | NUMERIC(6, 2) | No | |
| deposit_amount | asset.copy | | NUMERIC(6, 2) | Yes | |
| deposit_amount | import_item | | NUMERIC(8, 2) | No | |
| depth | org_unit_type | | INTEGER | Yes | |
| depth | grp_perm_map | | INTEGER | Yes | |
| depth | usr_perm_map | | INTEGER | Yes | |
| description | authority_attr_definition | | TEXT | No | |
| description | cleanup | | TEXT | No | |
| description | lineitem_generated_attr_definition | | TEXT | Yes | |
| description | lineitem_attr_definition | | TEXT | Yes | |
| description | lineitem_local_attr_definition | | TEXT | Yes | |
| description | hook | | TEXT | No | |
| description | lineitem_marc_attr_definition | | TEXT | Yes | |
| description | lit_form_map | | TEXT | No | |
| description | bib_attr_definition | | TEXT | No | |
| description | circ_modifier | | TEXT | Yes | |
| description | lineitem_usr_attr_definition | | TEXT | Yes | |
| description | survey | | TEXT | Yes | |
| description | session | | TEXT | No | |
| description | audience_map | | TEXT | No | |
| description | lineitem_provider_attr_definition | | TEXT | Yes | |
| description | perm_list | | TEXT | No | |
| description | validator | | TEXT | No | |
| description | reactor | | TEXT | No | |
| description | collector | | TEXT | No | |
| description | i18n_locale | | TEXT | No | |
| description | grp_tree | | TEXT | No | |
| desk_renewal | aged_circulation | | BOOLEAN | Yes | |
| desk_renewal | circulation | | BOOLEAN | Yes | |
| dest | transit_copy | FK | INTEGER | Yes | org_unit.id |
| dest | hold_transit_copy | | INTEGER | Yes | |
| dest_recv_time | hold_transit_copy | | TIMESTAMP | No | |
| dest_recv_time | transit_copy | | TIMESTAMP | No | |
| distance_is_from_owner | hold_matrix_matchpoint | | BOOLEAN | Yes | |
| dob | usr | | TIMESTAMP | No | |
| dow_0_close | hours_of_operation | | TIME | Yes | |
| dow_0_open | hours_of_operation | | TIME | Yes | |
| dow_1_close | hours_of_operation | | TIME | Yes | |
| dow_1_open | hours_of_operation | | TIME | Yes | |
| dow_2_close | hours_of_operation | | TIME | Yes | |
| dow_2_open | hours_of_operation | | TIME | Yes | |
| dow_3_close | hours_of_operation | | TIME | Yes | |
| dow_3_open | hours_of_operation | | TIME | Yes | |
| dow_4_close | hours_of_operation | | TIME | Yes | |
| dow_4_open | hours_of_operation | | TIME | Yes | |
| dow_5_close | hours_of_operation | | TIME | Yes | |
| dow_5_open | hours_of_operation | | TIME | Yes | |
| dow_6_close | hours_of_operation | | TIME | Yes | |
| dow_6_open | hours_of_operation | | TIME | Yes | |
| due_date | aged_circulation | | TIMESTAMP | No | |
| due_date | circulation | | TIMESTAMP | No | |
| dummy_author | asset.copy | | TEXT | No | |
| dummy_title | asset.copy | | TEXT | No | |
| duration | aged_circulation | | INTERVAL | No | |
| duration | circulation | | INTERVAL | No | |
| duration_rule | circ_matrix_matchpoint | | INTEGER | Yes | |
| duration_rule | aged_circulation | | TEXT | Yes | |
| duration_rule | circulation | | TEXT | Yes | |
| editor | purchase_order | | INTEGER | Yes | |
| editor | picklist | FK | INTEGER | Yes | usr.id |
| editor | lineitem | FK | INTEGER | Yes | usr.id |
| editor | record_entry | | INTEGER | Yes | |
| editor | po_note | | INTEGER | Yes | |
| editor | record_note | FK | INTEGER | Yes | usr.id |
| editor | lineitem_note | FK | INTEGER | Yes | usr.id |
| editor | record_entry | | INTEGER | Yes | |
| editor | call_number | FK | BIGINT | Yes | usr.id |
| editor | record_entry | FK | INTEGER | Yes | usr.id |
| editor | asset.copy | FK | BIGINT | Yes | usr.id |
| editor | record_note | | INTEGER | Yes | |
| edit_date | record_entry | | TIMESTAMP | Yes | |
| edit_date | record_entry | | TIMESTAMP | Yes | |
| edit_date | record_note | | TIMESTAMP | Yes | |
| edit_date | asset.copy | | TIMESTAMP | No | |
| edit_date | call_number | | TIMESTAMP | No | |
| edit_date | record_entry | | TIMESTAMP | Yes | |
| edit_date | record_note | | TIMESTAMP | Yes | |
| edit_time | lineitem | | TIMESTAMP | Yes | |
| edit_time | po_note | | TIMESTAMP | Yes | |
| edit_time | picklist | | TIMESTAMP | Yes | |
| edit_time | lineitem_note | | TIMESTAMP | Yes | |
| edit_time | purchase_order | | TIMESTAMP | Yes | |
| effective_date | survey_response | | TIMESTAMP | Yes | |
| eg_bib_id | lineitem | FK | INTEGER | No | record_entry.id |
| eg_copy_id | lineitem_detail | FK | BIGINT | No | asset.copy.id |
| eg_record | bib_match | FK | BIGINT | No | record_entry.id |
| eg_record | authority_match | FK | BIGINT | No | record_entry.id |
| email | usr | | TEXT | No | |
| email | org_unit | | TEXT | No | |
| email | provider_contact | | TEXT | No | |
| email_notify | hold_request | | BOOLEAN | Yes | |
| encumbrance | fund_debit | | BOOLEAN | Yes | |
| enc_level | rec_descriptor | | TEXT | No | |
| end_date | survey | | TIMESTAMP | Yes | |
| end_date | subscription | | DATE | No | |
| end_time | session | | INTEGER | No | |
| enter_time | collections_tracker | | TIMESTAMP | No | |
| error_output | event | FK | BIGINT | No | event_output.id |
| evening_phone | usr | | TEXT | No | |
| event_def | event_params | FK | INTEGER | Yes | event_definition.id |
| event_def | event | FK | INTEGER | No | event_definition.id |
| event_def | environment | FK | INTEGER | Yes | event_definition.id |
| expected_recv_time | lineitem | | TIMESTAMP | No | |
| expire_date | usr | | TIMESTAMP | Yes | |
| expire_month | credit_card_payment | | INTEGER | No | |
| expire_time | hold_request | | TIMESTAMP | No | |
| expire_year | credit_card_payment | | INTEGER | No | |
| extended | rule_circ_duration | | INTERVAL | Yes | |
| facet_field | metabib_field | | BOOLEAN | Yes | |
| fail_time | unfulfilled_hold_list | | TIMESTAMP | Yes | |
| family_name | usr | | TEXT | Yes | |
| field | queued_authority_record_attr | FK | INTEGER | Yes | authority_attr_definition.id |
| field | idl_field_doc | | TEXT | Yes | |
| field | relevance_adjustment | FK | INTEGER | Yes | metabib_field.id |
| field | series_field_entry | | INTEGER | Yes | |
| field | title_field_entry | FK | INTEGER | Yes | metabib_field.id |
| field | keyword_field_entry | FK | INTEGER | Yes | metabib_field.id |
| field | queued_bib_record_attr | FK | INTEGER | Yes | bib_attr_definition.id |
| field | import_bib_trash_fields | | TEXT | Yes | |
| field | author_field_entry | FK | INTEGER | Yes | metabib_field.id |
| field | subject_field_entry | FK | INTEGER | Yes | metabib_field.id |
| field_class | metabib_field | | TEXT | Yes | |
| field_type | bib_match | | TEXT | Yes | |
| fine_interval | circulation | | INTERVAL | Yes | |
| fine_interval | aged_circulation | | INTERVAL | Yes | |
| fine_level | asset.copy | | INTEGER | Yes | |
| fine_level | copy_transparency | | INTEGER | No | |
| fingerprint | metarecord | | TEXT | Yes | |
| fingerprint | record_entry | | TEXT | No | |
| first_given_name | usr | | TEXT | Yes | |
| fm_class | idl_field_doc | | TEXT | Yes | |
| format | z3950_attr | | INTEGER | Yes | |
| format | metabib_field | | TEXT | Yes | |
| formula | distribution_formula_entry | FK | INTEGER | Yes | distribution_formula.id |
| fq_field | i18n_core | | TEXT | Yes | |
| from_currency | exchange_rate | FK | TEXT | Yes | currency_type.code |
| from_org | org_unit_proximity | | INTEGER | No | |
| frozen | hold_request | | BOOLEAN | Yes | |
| fulfillment_lib | hold_request | FK | INTEGER | No | org_unit.id |
| fulfillment_staff | hold_request | FK | INTEGER | No | usr.id |
| fulfillment_time | hold_request | | TIMESTAMP | No | |
| fund | lineitem_detail | FK | INTEGER | No | fund.id |
| fund | fund_debit | FK | INTEGER | Yes | fund.id |
| fund | fund_allocation | FK | INTEGER | Yes | fund.id |
| fund | fund_tag_map | FK | INTEGER | Yes | fund.id |
| funding_source | funding_source_credit | FK | INTEGER | Yes | funding_source.id |
| funding_source | fund_allocation | FK | INTEGER | Yes | funding_source.id, funding_source.id |
| fund_debit | lineitem_detail | FK | INTEGER | No | fund_debit.id |
| generated_coverage | bib_summary | | TEXT | Yes | |
| generated_coverage | index_summary | | TEXT | Yes | |
| generated_coverage | sup_summary | | TEXT | Yes | |
| grantable | usr_object_perm_map | | BOOLEAN | Yes | |
| grantable | grp_perm_map | | BOOLEAN | Yes | |
| grantable | usr_perm_map | | BOOLEAN | Yes | |
| group_field | event_definition | | TEXT | No | |
| grp | circ_matrix_matchpoint | FK | INTEGER | Yes | grp_tree.id |
| grp | grp_perm_map | FK | INTEGER | Yes | grp_tree.id |
| grp | usr_grp_map | FK | INTEGER | Yes | grp_tree.id |
| grp | grp_penalty_threshold | FK | INTEGER | Yes | grp_tree.id |
| high | rule_recuring_fine | | NUMERIC(6, 2) | Yes | |
| hold | hold_copy_map | FK | INTEGER | Yes | hold_request.id |
| hold | hold_notification | FK | INTEGER | Yes | hold_request.id |
| hold | unfulfilled_hold_list | FK | INTEGER | Yes | hold_request.id |
| hold | hold_transit_copy | FK | INTEGER | No | hold_request.id |
| holdable | copy_status | | BOOLEAN | Yes | |
| holdable | asset.copy | | BOOLEAN | Yes | |
| holdable | hold_matrix_matchpoint | | BOOLEAN | Yes | |
| holdable | copy_location | | BOOLEAN | Yes | |
| holdable | copy_transparency | | BOOLEAN | No | |
| holdable | import_item_attr_definition | | TEXT | No | |
| holdable | import_item | | BOOLEAN | No | |
| holdable_formats | hold_request | | TEXT | No | |
| holding_tag | provider | | TEXT | No | |
| holds_address | org_unit | FK | INTEGER | No | org_address.id |
| hold_type | hold_request | | TEXT | Yes | |
| hold_verify | copy_location | | BOOLEAN | Yes | |
| home_ou | usr | FK | INTEGER | Yes | org_unit.id |
| hook | event_definition | FK | TEXT | Yes | hook.key |
| host | z3950_source | | TEXT | Yes | |
| href | uri | | TEXT | Yes | |
| id | fund_allocation | PK | SERIAL | Yes | |
| id | in_house_use | PK | SERIAL | Yes | |
| id | user_bucket_item_note | PK | SERIAL | Yes | |
| id | rule_recuring_fine | PK | SERIAL | Yes | |
| id | survey_response | PK | BIGSERIAL | Yes | |
| id | grocery | PK, FK | BIGSERIAL | Yes | billable_xact.id |
| id | full_rec | PK, FK | BIGSERIAL | Yes | record_entry.id |
| id | user_bucket_item | PK | SERIAL | Yes | |
| id | net_access_level | PK | SERIAL | Yes | |
| id | user_bucket_note | PK | SERIAL | Yes | |
| id | funding_source | PK | SERIAL | Yes | |
| id | record_entry | PK | BIGSERIAL | Yes | |
| id | subscription | PK | SERIAL | Yes | |
| id | copy_status | PK | SERIAL | Yes | |
| id | issuance | PK | SERIAL | Yes | |
| id | non_cat_in_house_use | PK | SERIAL | Yes | |
| id | rule_age_hold_protect | PK | SERIAL | Yes | |
| id | record_note | PK | BIGSERIAL | Yes | |
| id | survey | PK | SERIAL | Yes | |
| id | fund_debit | PK | SERIAL | Yes | |
| id | rec_descriptor | PK, FK | BIGSERIAL | Yes | record_entry.id |
| id | funding_source_credit | PK | SERIAL | Yes | |
| id | survey_answer | PK | SERIAL | Yes | |
| id | binding_unit | PK | SERIAL | Yes | |
| id | fund | PK | SERIAL | Yes | |
| id | survey_question | PK | SERIAL | Yes | |
| id | non_cataloged_circulation | PK | SERIAL | Yes | |
| id | copy_bucket_item_note | PK | SERIAL | Yes | |
| id | org_unit | PK | SERIAL | Yes | |
| id | z3950_attr | PK | SERIAL | Yes | |
| id | record_entry | PK | BIGSERIAL | Yes | |
| id | po_note | PK, FK | SERIAL | Yes | usr.id |
| id | call_number_bucket | PK | SERIAL | Yes | |
| id | bnm_desk_payment | PK, FK | BIGSERIAL | Yes | bnm_payment.id |
| id | copy_bucket_item | PK | SERIAL | Yes | |
| id | copy_bucket | PK | SERIAL | Yes | |
| id | fund_tag | PK | SERIAL | Yes | |
| id | card | PK | SERIAL | Yes | |
| id | org_unit_type | PK | SERIAL | Yes | |
| id | fund_tag_map | PK | SERIAL | Yes | |
| id | copy_bucket_note | PK | SERIAL | Yes | |
| id | lineitem | PK | BIGSERIAL | Yes | |
| id | import_item_attr_definition | PK | BIGSERIAL | Yes | |
| id | cash_payment | PK, FK | BIGSERIAL | Yes | bnm_desk_payment.id |
| id | biblio_record_entry_bucket_item | PK | SERIAL | Yes | |
| id | biblio_record_entry_bucket_note | PK | SERIAL | Yes | |
| id | queue | PK | BIGSERIAL | Yes | |
| id | user_bucket | PK | SERIAL | Yes | |
| id | picklist | PK, FK | SERIAL | Yes | org_unit.id |
| id | biblio_record_entry_bucket_item_note | PK | SERIAL | Yes | |
| id | queued_record | PK | BIGSERIAL | Yes | |
| id | call_number_bucket_item | PK | SERIAL | Yes | |
| id | billing | PK | BIGSERIAL | Yes | |
| id | call_number_bucket_note | PK | SERIAL | Yes | |
| id | bib_attr_definition | PK | SERIAL | Yes | |
| id | biblio_record_entry_bucket | PK | SERIAL | Yes | |
| id | purchase_order | PK, FK | SERIAL | Yes | usr.id |
| id | call_number_bucket_item_note | PK | SERIAL | Yes | |
| id | billable_xact | PK | BIGSERIAL | Yes | |
| id | hours_of_operation | FK | INTEGER | Yes | org_unit.id |
| id | hold_matrix_matchpoint | PK | SERIAL | Yes | |
| id | usr_standing_penalty | | SERIAL | Yes | |
| id | hold_copy_map | PK | SERIAL | Yes | |
| id | circ_matrix_circ_mod_test | PK | SERIAL | Yes | |
| id | transit_copy | PK | SERIAL | Yes | |
| id | circ_matrix_circ_mod_test_map | PK | SERIAL | Yes | |
| id | hold_notification | PK | SERIAL | Yes | |
| id | bib_source | PK | SERIAL | Yes | |
| id | credit_card_payment | PK, FK | BIGSERIAL | Yes | bnm_desk_payment.id |
| id | standing | PK | SERIAL | Yes | |
| id | grp_tree | PK | SERIAL | Yes | |
| id | org_unit_proximity | PK | BIGSERIAL | Yes | |
| id | event_definition | PK | SERIAL | Yes | |
| id | perm_list | PK | SERIAL | Yes | |
| id | org_address | PK | SERIAL | Yes | |
| id | workstation | PK | SERIAL | Yes | |
| id | idl_field_doc | PK | BIGSERIAL | Yes | |
| id | usr_org_unit_opt_in | PK | SERIAL | Yes | |
| id | circ_matrix_matchpoint | PK, FK | SERIAL | Yes | rule_circ_duration.id, rule_recuring_fine.id, rule_max_fine.id |
| id | org_unit_closed | PK | SERIAL | Yes | |
| id | script | PK | SERIAL | Yes | |
| id | collections_tracker | PK | BIGSERIAL | Yes | |
| id | event_params | PK | BIGSERIAL | Yes | |
| id | event_output | PK | BIGSERIAL | Yes | |
| id | hold_transit_copy | PK, FK | SERIAL | Yes | transit_copy.id |
| id | environment | PK | SERIAL | Yes | |
| id | usr_address | PK | SERIAL | Yes | |
| id | org_unit_setting | PK | BIGSERIAL | Yes | |
| id | unfulfilled_hold_list | PK | BIGSERIAL | Yes | |
| id | event | PK | BIGSERIAL | Yes | |
| id | index_summary | PK | SERIAL | Yes | |
| id | provider_contact | PK | SERIAL | Yes | |
| id | org_lasso | PK | SERIAL | Yes | |
| id | record_entry | FK | BIGSERIAL | Yes | bib_source.id, record_entry.id |
| id | aged_circulation | PK, FK | INTEGER | Yes | asset.copy.id |
| id | usr_work_ou_map | PK | SERIAL | Yes | |
| id | relevance_adjustment | PK | SERIAL | Yes | |
| id | sup_summary | PK | SERIAL | Yes | |
| id | bib_summary | PK | SERIAL | Yes | |
| id | rule_max_fine | PK | SERIAL | Yes | |
| id | circulation | FK | SERIAL | Yes | billable_xact.id |
| id | rule_circ_duration | PK | SERIAL | Yes | |
| id | identification_type | PK | SERIAL | Yes | |
| id | record_note | PK | BIGSERIAL | Yes | |
| id | provider_contact_address | PK | SERIAL | Yes | |
| id | provider_address | PK | SERIAL | Yes | |
| id | provider | PK | SERIAL | Yes | |
| id | grp_penalty_threshold | | SERIAL | Yes | |
| id | grp_perm_map | PK | SERIAL | Yes | |
| id | exchange_rate | PK | SERIAL | Yes | |
| id | hold_request | PK | SERIAL | Yes | |
| id | hold_request_cancel_cause | PK | SERIAL | Yes | |
| id | standing_penalty | PK | SERIAL | Yes | |
| id | usr_perm_map | | SERIAL | Yes | |
| id | non_cataloged_type | PK | SERIAL | Yes | |
| id | check_payment | PK, FK | BIGSERIAL | Yes | bnm_desk_payment.id |
| id | provider_holding_subfield_map | PK | SERIAL | Yes | |
| id | usr_grp_map | | SERIAL | Yes | |
| id | usr_object_perm_map | | SERIAL | Yes | |
| id | metabib_field | PK | SERIAL | Yes | |
| id | org_lasso_map | PK | SERIAL | Yes | |
| id | stat_cat_entry | PK | SERIAL | Yes | |
| id | lineitem_provider_attr_definition | | BIGSERIAL | Yes | |
| id | authority_attr_definition | PK | SERIAL | Yes | |
| id | lineitem_usr_attr_definition | | BIGSERIAL | Yes | |
| id | lineitem_provider_attr_definition | PK, FK | BIGINT | Yes | lineitem_attr_definition.id |
| id | import_bib_trash_fields | PK | BIGSERIAL | Yes | |
| id | stat_cat | PK | SERIAL | Yes | |
| id | title_field_entry | PK | BIGSERIAL | Yes | |
| id | bib_match | PK | BIGSERIAL | Yes | |
| id | stat_cat | PK | SERIAL | Yes | |
| id | copy_note | PK, FK | BIGSERIAL | Yes | asset.copy.id |
| id | queued_bib_record | | INTEGER | No | |
| id | lineitem_usr_attr_definition | PK, FK | BIGINT | Yes | lineitem_attr_definition.id |
| id | stat_cat_entry | PK | SERIAL | Yes | |
| id | author_field_entry | PK | BIGSERIAL | Yes | |
| id | bnm_payment | PK, FK | BIGSERIAL | Yes | payment.id |
| id | lineitem_detail | PK | BIGSERIAL | Yes | |
| id | stat_cat_entry_copy_map | PK | BIGSERIAL | Yes | |
| id | series_field_entry | FK | BIGSERIAL | Yes | metabib_field.id |
| id | queued_bib_record_attr | PK | BIGSERIAL | Yes | |
| id | lineitem_generated_attr_definition | | BIGSERIAL | Yes | |
| id | forgive_payment | PK, FK | BIGSERIAL | Yes | bnm_payment.id |
| id | credit_payment | PK, FK | BIGSERIAL | Yes | bnm_payment.id |
| id | lineitem_attr_definition | PK | BIGSERIAL | Yes | |
| id | rec_descriptor | PK | BIGSERIAL | Yes | |
| id | copy_transparency | PK | SERIAL | Yes | |
| id | lineitem_attr | PK | BIGSERIAL | Yes | |
| id | usr | PK | SERIAL | Yes | |
| id | metarecord | PK | BIGSERIAL | Yes | |
| id | usr_setting | PK | BIGSERIAL | Yes | |
| id | copy_transparency_map | PK, FK | BIGSERIAL | Yes | asset.copy.id |
| id | import_item | PK | BIGSERIAL | Yes | |
| id | stat_cat_entry_transparency_map | PK | BIGSERIAL | Yes | |
| id | i18n_core | PK | BIGSERIAL | Yes | |
| id | lineitem_local_attr_definition | PK, FK | BIGINT | Yes | lineitem_attr_definition.id |
| id | billing_type | PK | SERIAL | Yes | |
| id | lineitem_local_attr_definition | | BIGSERIAL | Yes | |
| id | goods_payment | PK, FK | BIGSERIAL | Yes | bnm_payment.id |
| id | work_payment | PK, FK | BIGSERIAL | Yes | bnm_payment.id |
| id | usr_note | PK | BIGSERIAL | Yes | |
| id | metarecord_source_map | PK | BIGSERIAL | Yes | |
| id | distribution_formula | PK | SERIAL | Yes | |
| id | queued_authority_record_attr | PK | BIGSERIAL | Yes | |
| id | distribution_formula_entry | PK | SERIAL | Yes | |
| id | lineitem_marc_attr_definition | PK, FK | BIGINT | Yes | lineitem_attr_definition.id |
| id | queued_authority_record | | INTEGER | No | |
| id | copy_location | PK | SERIAL | Yes | |
| id | call_number | PK | BIGSERIAL | Yes | |
| id | uri_call_number_map | PK | BIGSERIAL | Yes | |
| id | real_full_rec | PK | BIGINT | Yes | |
| id | lineitem_marc_attr_definition | | BIGSERIAL | Yes | |
| id | payment | PK | BIGSERIAL | Yes | |
| id | subject_field_entry | PK | BIGSERIAL | Yes | |
| id | stat_cat_entry_usr_map | PK | BIGSERIAL | Yes | |
| id | authority_match | PK | BIGSERIAL | Yes | |
| id | call_number_note | PK | BIGSERIAL | Yes | |
| id | lineitem_generated_attr_definition | PK, FK | BIGINT | Yes | lineitem_attr_definition.id |
| id | keyword_field_entry | PK | BIGSERIAL | Yes | |
| id | asset.copy | PK | BIGSERIAL | Yes | |
| id | lineitem_note | PK | SERIAL | Yes | |
| id | uri | PK | SERIAL | Yes | |
| ident | lineitem_usr_attr_definition | | BOOLEAN | Yes | |
| ident | lineitem_provider_attr_definition | | BOOLEAN | Yes | |
| ident | lineitem_local_attr_definition | | BOOLEAN | Yes | |
| ident | bib_attr_definition | | BOOLEAN | Yes | |
| ident | lineitem_marc_attr_definition | | BOOLEAN | Yes | |
| ident | lineitem_attr_definition | | BOOLEAN | Yes | |
| ident | lineitem_generated_attr_definition | | BOOLEAN | Yes | |
| ident | authority_attr_definition | | BOOLEAN | Yes | |
| identity_value | i18n_core | | TEXT | Yes | |
| ident_type | usr | FK | INTEGER | Yes | identification_type.id |
| ident_type2 | usr | FK | INTEGER | No | identification_type.id |
| ident_value | usr | | TEXT | No | |
| ident_value2 | usr | | TEXT | No | |
| ill_address | org_unit | FK | INTEGER | No | org_address.id |
| imported_as | queued_bib_record | FK | INTEGER | No | record_entry.id |
| imported_as | queued_authority_record | FK | INTEGER | No | record_entry.id |
| import_time | queued_record | | TIMESTAMP | No | |
| include_frozen_holds | hold_matrix_matchpoint | | BOOLEAN | Yes | |
| ind1 | real_full_rec | | TEXT | No | |
| ind1 | full_rec | | TEXT | No | |
| ind2 | real_full_rec | | TEXT | No | |
| ind2 | full_rec | | TEXT | No | |
| index_vector | keyword_field_entry | | TSVECTOR | Yes | |
| index_vector | author_field_entry | | TSVECTOR | Yes | |
| index_vector | title_field_entry | | TSVECTOR | Yes | |
| index_vector | real_full_rec | | TSVECTOR | Yes | |
| index_vector | subject_field_entry | | TSVECTOR | Yes | |
| index_vector | full_rec | | TSVECTOR | Yes | |
| index_vector | series_field_entry | | TSVECTOR | Yes | |
| install_date | upgrade_log | | TIMESTAMP | Yes | |
| in_house | non_cataloged_type | | BOOLEAN | Yes | |
| in_process | session | | INTEGER | Yes | |
| is_error | event_output | | BOOLEAN | Yes | |
| is_percent | rule_max_fine | | BOOLEAN | Yes | |
| is_renewal | circ_matrix_matchpoint | | BOOLEAN | No | |
| item | biblio_record_entry_bucket_item_note | FK | INTEGER | Yes | biblio_record_entry_bucket_item.id |
| item | user_bucket_item_note | FK | INTEGER | Yes | user_bucket_item.id |
| item | call_number_bucket_item_note | FK | INTEGER | Yes | call_number_bucket_item.id |
| item | in_house_use | FK | BIGINT | Yes | asset.copy.id |
| item | copy_bucket_item_note | FK | INTEGER | Yes | copy_bucket_item.id |
| items_out | circ_matrix_circ_mod_test | | INTEGER | Yes | |
| item_attr_def | bib_queue | FK | BIGINT | No | import_item_attr_definition.id |
| item_circ_ou | hold_matrix_matchpoint | FK | INTEGER | No | org_unit.id |
| item_count | lineitem | | INTEGER | Yes | |
| item_count | distribution_formula_entry | | INTEGER | Yes | |
| item_form | rec_descriptor | | TEXT | No | |
| item_lang | rec_descriptor | | TEXT | No | |
| item_owning_ou | hold_matrix_matchpoint | FK | INTEGER | No | org_unit.id |
| item_type | non_cataloged_circulation | FK | INTEGER | Yes | non_cataloged_type.id |
| item_type | non_cat_in_house_use | FK | BIGINT | Yes | non_cataloged_type.id |
| item_type | rec_descriptor | | TEXT | No | |
| juvenile | usr | | BOOLEAN | Yes | |
| juvenile_flag | hold_matrix_matchpoint | | BOOLEAN | No | |
| juvenile_flag | circ_matrix_matchpoint | | BOOLEAN | No | |
| keep | import_item_attr_definition | | BOOLEAN | Yes | |
| key | event_definition | | TEXT | No | |
| key | hook | PK | TEXT | Yes | |
| label | uri | | TEXT | No | |
| label | environment | | TEXT | No | |
| label | user_bucket_type | | TEXT | Yes | |
| label | binding_unit | | TEXT | Yes | |
| label | z3950_source | | TEXT | Yes | |
| label | biblio_record_entry_bucket_type | | TEXT | Yes | |
| label | currency_type | | TEXT | No | |
| label | call_number_bucket_type | | TEXT | Yes | |
| label | standing_penalty | | TEXT | Yes | |
| label | call_number | | TEXT | Yes | |
| label | hold_request_cancel_cause | | TEXT | No | |
| label | z3950_attr | | TEXT | Yes | |
| label | copy_bucket_type | | TEXT | Yes | |
| label | issuance | | TEXT | No | |
| lasso | org_lasso_map | FK | INTEGER | Yes | org_lasso.id |
| last_xact_id | record_entry | | TEXT | Yes | |
| last_xact_id | record_entry | | TEXT | Yes | |
| last_xact_id | record_entry | | TEXT | Yes | |
| last_xact_id | usr | | TEXT | Yes | |
| lineitem | lineitem_note | FK | INTEGER | Yes | lineitem.id |
| lineitem | lineitem_detail | FK | INTEGER | Yes | lineitem.id |
| lineitem | lineitem_attr | FK | BIGINT | Yes | lineitem.id |
| lit_form | rec_descriptor | | TEXT | No | |
| loan_duration | asset.copy | | INTEGER | Yes | |
| loan_duration | copy_transparency | | INTEGER | No | |
| location | import_item | | INTEGER | No | |
| location | issuance | FK | BIGINT | No | copy_location.id |
| location | distribution_formula_entry | FK | INTEGER | No | copy_location.id |
| location | import_item_attr_definition | | TEXT | No | |
| location | asset.copy | FK | INTEGER | Yes | copy_location.id |
| location | collections_tracker | FK | INTEGER | Yes | org_unit.id |
| location | lineitem_detail | FK | INTEGER | No | copy_location.id |
| logfile | script | | TEXT | Yes | |
| low | rule_recuring_fine | | NUMERIC(6, 2) | Yes | |
| magnetic_media | circ_modifier | | BOOLEAN | Yes | |
| mailing_address | org_unit | FK | INTEGER | No | org_address.id |
| mailing_address | usr | FK | INTEGER | No | usr_address.id |
| marc | lineitem | | TEXT | Yes | |
| marc | record_entry | | TEXT | Yes | |
| marc | record_entry | | TEXT | Yes | |
| marc | record_entry | | TEXT | Yes | |
| marc | queued_record | | TEXT | Yes | |
| marc_code | i18n_locale | FK | TEXT | Yes | language_map.code |
| marc_form | circ_matrix_matchpoint | | TEXT | No | |
| marc_form | hold_matrix_matchpoint | FK | TEXT | No | item_form_map.code |
| marc_type | circ_matrix_matchpoint | FK | TEXT | No | item_type_map.code |
| marc_type | hold_matrix_matchpoint | FK | TEXT | No | item_type_map.code |
| marc_vr_format | hold_matrix_matchpoint | FK | TEXT | No | videorecording_format_map.code |
| marc_vr_format | circ_matrix_matchpoint | FK | TEXT | No | videorecording_format_map.code |
| master_account | usr | | BOOLEAN | Yes | |
| matched_attr | authority_match | FK | INTEGER | No | queued_authority_record_attr.id |
| matched_attr | bib_match | FK | INTEGER | No | queued_bib_record_attr.id |
| matchpoint | circ_matrix_circ_mod_test | FK | INTEGER | Yes | circ_matrix_matchpoint.id |
| max_delay | event_definition | | INTERVAL | No | |
| max_fine | circulation | | NUMERIC(6, 2) | No | |
| max_fine | aged_circulation | | NUMERIC(6, 2) | No | |
| max_fine_rule | circulation | | TEXT | Yes | |
| max_fine_rule | circ_matrix_matchpoint | | INTEGER | Yes | |
| max_fine_rule | aged_circulation | | TEXT | Yes | |
| max_holds | hold_matrix_matchpoint | | INTEGER | No | |
| max_renewals | rule_circ_duration | | INTEGER | Yes | |
| metarecord | metarecord_source_map | | BIGINT | Yes | |
| method | hold_notification | | TEXT | Yes | |
| mods | metarecord | | TEXT | No | |
| module | cleanup | PK | TEXT | Yes | |
| module | reactor | PK | TEXT | Yes | |
| module | collector | PK | TEXT | Yes | |
| module | environment | | TEXT | No | |
| module | event_definition | | TEXT | No | |
| module | validator | PK | TEXT | Yes | |
| multiplier | relevance_adjustment | | NUMERIC | Yes | |
| name | event_definition | | TEXT | Yes | |
| name | org_unit_setting | | TEXT | Yes | |
| name | workstation | | TEXT | Yes | |
| name | circ_modifier | | TEXT | Yes | |
| name | usr_setting | | TEXT | Yes | |
| name | fund | | TEXT | Yes | |
| name | import_item_attr_definition | | TEXT | Yes | |
| name | billing_type | | TEXT | Yes | |
| name | z3950_source | PK | TEXT | Yes | |
| name | rule_recuring_fine | | TEXT | Yes | |
| name | funding_source | | TEXT | Yes | |
| name | org_unit | | TEXT | Yes | |
| name | call_number_bucket | | TEXT | Yes | |
| name | survey | | TEXT | Yes | |
| name | stat_cat | | TEXT | Yes | |
| name | stat_cat | | TEXT | Yes | |
| name | picklist | | TEXT | Yes | |
| name | user_bucket | | TEXT | Yes | |
| name | net_access_level | | TEXT | Yes | |
| name | copy_transparency | | TEXT | Yes | |
| name | rule_age_hold_protect | | TEXT | Yes | |
| name | biblio_record_entry_bucket | | TEXT | Yes | |
| name | queue | | TEXT | Yes | |
| name | copy_status | | TEXT | Yes | |
| name | i18n_locale | | TEXT | Yes | |
| name | metabib_field | | TEXT | Yes | |
| name | xml_transform | PK | TEXT | Yes | |
| name | org_lasso | | TEXT | No | |
| name | copy_bucket | | TEXT | Yes | |
| name | copy_location | | TEXT | Yes | |
| name | grp_tree | | TEXT | Yes | |
| name | fund_tag | | TEXT | Yes | |
| name | provider | | TEXT | Yes | |
| name | standing_penalty | | TEXT | Yes | |
| name | z3950_attr | | TEXT | Yes | |
| name | identification_type | | TEXT | Yes | |
| name | org_unit_type | | TEXT | Yes | |
| name | rule_circ_duration | | TEXT | Yes | |
| name | rule_max_fine | | TEXT | Yes | |
| name | distribution_formula | | TEXT | Yes | |
| name | provider_holding_subfield_map | | TEXT | Yes | |
| name | non_cataloged_type | | TEXT | Yes | |
| name | provider_contact | | TEXT | No | |
| namespace_uri | xml_transform | | TEXT | Yes | |
| net_access_level | usr | FK | INTEGER | Yes | net_access_level.id |
| normal | rule_circ_duration | | INTERVAL | Yes | |
| normal | rule_recuring_fine | | NUMERIC(6, 2) | Yes | |
| note | forgive_payment | | TEXT | No | |
| note | credit_payment | | TEXT | No | |
| note | work_payment | | TEXT | No | |
| note | goods_payment | | TEXT | No | |
| note | billing | | TEXT | No | |
| note | check_payment | | TEXT | No | |
| note | credit_card_payment | | TEXT | No | |
| note | grocery | | TEXT | No | |
| note | bnm_desk_payment | | TEXT | No | |
| note | fund_allocation | | TEXT | No | |
| note | cash_payment | | TEXT | No | |
| note | payment | | TEXT | No | |
| note | funding_source_credit | | TEXT | No | |
| note | lineitem_detail | | TEXT | No | |
| note | bnm_payment | | TEXT | No | |
| note | call_number_bucket_item_note | | TEXT | Yes | |
| note | biblio_record_entry_bucket_item_note | | TEXT | Yes | |
| note | call_number_bucket_note | | TEXT | Yes | |
| note | copy_bucket_note | | TEXT | Yes | |
| note | hold_notification | | TEXT | No | |
| note | biblio_record_entry_bucket_note | | TEXT | Yes | |
| note | user_bucket_item_note | | TEXT | Yes | |
| note | user_bucket_note | | TEXT | Yes | |
| note | usr_standing_penalty | | TEXT | No | |
| note | copy_bucket_item_note | | TEXT | Yes | |
| notify_staff | hold_notification | FK | INTEGER | No | usr.id |
| notify_time | hold_notification | | TIMESTAMP | Yes | |
| num_complete | session | | INTEGER | Yes | |
| object_id | usr_object_perm_map | | TEXT | Yes | |
| object_type | usr_object_perm_map | | TEXT | Yes | |
| opac | survey | | BOOLEAN | Yes | |
| opac_label | org_unit_type | | TEXT | Yes | |
| opac_renewal | aged_circulation | | BOOLEAN | Yes | |
| opac_renewal | circulation | | BOOLEAN | Yes | |
| opac_visible | org_unit | | BOOLEAN | Yes | |
| opac_visible | stat_cat | | BOOLEAN | Yes | |
| opac_visible | import_item_attr_definition | | TEXT | No | |
| opac_visible | stat_cat | | BOOLEAN | Yes | |
| opac_visible | copy_status | | BOOLEAN | Yes | |
| opac_visible | copy_transparency | | BOOLEAN | No | |
| opac_visible | import_item | | BOOLEAN | No | |
| opac_visible | copy_location | | BOOLEAN | Yes | |
| opac_visible | asset.copy | | BOOLEAN | Yes | |
| opt_in_ts | usr_org_unit_opt_in | | TIMESTAMP | Yes | |
| opt_in_ws | usr_org_unit_opt_in | FK | INTEGER | Yes | workstation.id |
| ordering_agency | purchase_order | FK | INTEGER | Yes | org_unit.id |
| org | session | | INTEGER | Yes | |
| org | fund | FK | INTEGER | Yes | org_unit.id |
| org_unit | org_unit_setting | FK | INTEGER | Yes | org_unit.id |
| org_unit | usr_org_unit_opt_in | FK | INTEGER | Yes | org_unit.id |
| org_unit | in_house_use | FK | INTEGER | Yes | org_unit.id |
| org_unit | org_lasso_map | FK | INTEGER | Yes | org_unit.id |
| org_unit | org_unit_closed | FK | INTEGER | Yes | org_unit.id |
| org_unit | usr_standing_penalty | FK | INTEGER | Yes | org_unit.id |
| org_unit | org_address | FK | INTEGER | Yes | org_unit.id |
| org_unit | non_cat_in_house_use | FK | INTEGER | Yes | org_unit.id |
| org_unit | picklist | | INTEGER | Yes | |
| org_unit | grp_penalty_threshold | FK | INTEGER | Yes | org_unit.id |
| org_unit | circ_matrix_matchpoint | FK | INTEGER | Yes | org_unit.id |
| origin_amount | fund_debit | | NUMERIC | Yes | |
| origin_currency_type | fund_debit | FK | TEXT | Yes | currency_type.code |
| other_phone | usr | | TEXT | No | |
| ou_type | org_unit | FK | INTEGER | Yes | org_unit_type.id |
| owner | copy_transparency | FK | INTEGER | Yes | org_unit.id |
| owner | event_definition | FK | INTEGER | Yes | org_unit.id |
| owner | fund_tag | FK | INTEGER | Yes | org_unit.id |
| owner | funding_source | FK | INTEGER | Yes | org_unit.id |
| owner | distribution_formula | FK | INTEGER | Yes | org_unit.id |
| owner | stat_cat | FK | INTEGER | Yes | org_unit.id |
| owner | import_item_attr_definition | FK | INTEGER | Yes | org_unit.id |
| owner | survey | FK | INTEGER | Yes | org_unit.id |
| owner | stat_cat_entry | | INTEGER | Yes | |
| owner | queue | FK | INTEGER | Yes | usr.id |
| owner | import_bib_trash_fields | FK | INTEGER | Yes | org_unit.id |
| owner | purchase_order | FK | INTEGER | Yes | usr.id |
| owner | idl_field_doc | FK | INTEGER | Yes | org_unit.id |
| owner | copy_bucket | FK | INTEGER | Yes | usr.id |
| owner | user_bucket | FK | INTEGER | Yes | usr.id |
| owner | stat_cat | FK | INTEGER | Yes | org_unit.id |
| owner | billing_type | FK | INTEGER | Yes | org_unit.id |
| owner | call_number_bucket | FK | INTEGER | Yes | usr.id |
| owner | picklist | FK | INTEGER | Yes | usr.id |
| owner | provider | FK | INTEGER | Yes | org_unit.id |
| owner | biblio_record_entry_bucket | FK | INTEGER | Yes | usr.id |
| owning_copy | stat_cat_entry_copy_map | FK | CHARACTER(40) | Yes | asset.copy.id |
| owning_lib | lineitem_detail | FK | INTEGER | No | org_unit.id |
| owning_lib | import_item_attr_definition | | TEXT | No | |
| owning_lib | record_entry | | INTEGER | Yes | |
| owning_lib | distribution_formula_entry | | INTEGER | No | |
| owning_lib | import_item | | INTEGER | No | |
| owning_lib | copy_location | FK | INTEGER | Yes | org_unit.id |
| owning_lib | workstation | FK | INTEGER | Yes | org_unit.id |
| owning_lib | non_cataloged_type | FK | INTEGER | Yes | org_unit.id |
| owning_lib | call_number | FK | INTEGER | Yes | org_unit.id |
| owning_transparency | stat_cat_entry_transparency_map | | INTEGER | Yes | |
| param | event_params | | TEXT | Yes | |
| parent | org_unit_type | FK | INTEGER | No | org_unit_type.id |
| parent | grp_tree | FK | INTEGER | No | grp_tree.id |
| parent_ou | org_unit | FK | INTEGER | No | org_unit.id |
| passive | hook | | BOOLEAN | Yes | |
| passwd | usr | | TEXT | Yes | |
| path | environment | | TEXT | No | |
| patron | non_cataloged_circulation | FK | INTEGER | Yes | usr.id |
| payment_ts | credit_card_payment | | TIMESTAMP | Yes | |
| payment_ts | bnm_desk_payment | | TIMESTAMP | Yes | |
| payment_ts | check_payment | | TIMESTAMP | Yes | |
| payment_ts | cash_payment | | TIMESTAMP | Yes | |
| payment_ts | forgive_payment | | TIMESTAMP | Yes | |
| payment_ts | bnm_payment | | TIMESTAMP | Yes | |
| payment_ts | payment | | TIMESTAMP | Yes | |
| payment_ts | goods_payment | | TIMESTAMP | Yes | |
| payment_ts | credit_payment | | TIMESTAMP | Yes | |
| payment_ts | work_payment | | TIMESTAMP | Yes | |
| penalty | grp_penalty_threshold | FK | INTEGER | Yes | standing_penalty.id |
| pending | usr_address | | BOOLEAN | Yes | |
| percent | fund_allocation | | NUMERIC | No | |
| perm | usr_object_perm_map | FK | INTEGER | Yes | perm_list.id |
| perm | grp_perm_map | FK | INTEGER | Yes | perm_list.id |
| perm | usr_perm_map | FK | INTEGER | Yes | perm_list.id |
| perm_interval | grp_tree | | INTERVAL | Yes | |
| persistant_transfer | transit_copy | | BOOLEAN | Yes | |
| persistant_transfer | hold_transit_copy | | BOOLEAN | Yes | |
| phone | provider_contact | | TEXT | No | |
| phone | org_unit | | TEXT | No | |
| phone_notify | hold_request | | TEXT | No | |
| phone_renewal | aged_circulation | | BOOLEAN | Yes | |
| phone_renewal | circulation | | BOOLEAN | Yes | |
| photo_url | usr | | TEXT | No | |
| picklist | lineitem | FK | INTEGER | No | picklist.id |
| pickup_lib | hold_request | FK | INTEGER | Yes | org_unit.id |
| pickup_ou | hold_matrix_matchpoint | FK | INTEGER | No | org_unit.id |
| poll | survey | | BOOLEAN | Yes | |
| port | z3950_source | | INTEGER | Yes | |
| pos | biblio_record_entry_bucket_item | | INTEGER | No | |
| pos | copy_bucket_item | | INTEGER | No | |
| pos | call_number_bucket_item | | INTEGER | No | |
| pos | user_bucket_item | | INTEGER | No | |
| position | distribution_formula_entry | | INTEGER | Yes | |
| post_code | provider_address | | TEXT | Yes | |
| post_code | org_address | | TEXT | Yes | |
| post_code | usr_address | | TEXT | Yes | |
| post_code | provider_contact_address | | TEXT | Yes | |
| prefix | xml_transform | | TEXT | Yes | |
| prefix | usr | | TEXT | No | |
| prev_check_time | hold_request | | TIMESTAMP | No | |
| prev_hop | hold_transit_copy | | INTEGER | No | |
| prev_hop | transit_copy | FK | INTEGER | No | transit_copy.id |
| price | import_item | | NUMERIC(8, 2) | No | |
| price | import_item_attr_definition | | TEXT | No | |
| price | asset.copy | | NUMERIC(8, 2) | No | |
| priv_note | import_item | | TEXT | No | |
| priv_note | import_item_attr_definition | | TEXT | No | |
| priv_note_title | import_item_attr_definition | | TEXT | No | |
| profile | usr | FK | INTEGER | Yes | grp_tree.id |
| provider | provider_address | FK | INTEGER | Yes | provider.id |
| provider | provider_holding_subfield_map | FK | INTEGER | Yes | provider.id |
| provider | provider_contact | FK | INTEGER | Yes | provider.id |
| provider | purchase_order | FK | INTEGER | Yes | provider.id |
| provider | lineitem | FK | INTEGER | No | provider.id |
| provider | lineitem_provider_attr_definition | FK | INTEGER | Yes | provider.id |
| prox | org_unit_proximity | | INTEGER | No | |
| prox | rule_age_hold_protect | | INTEGER | Yes | |
| pub | usr_note | | BOOLEAN | Yes | |
| pub | user_bucket | | BOOLEAN | Yes | |
| pub | copy_note | | BOOLEAN | Yes | |
| pub | call_number_note | | BOOLEAN | Yes | |
| pub | record_note | | BOOLEAN | Yes | |
| pub | copy_bucket | | BOOLEAN | Yes | |
| pub | call_number_bucket | | BOOLEAN | Yes | |
| pub | biblio_record_entry_bucket | | BOOLEAN | Yes | |
| pub_note | import_item | | TEXT | No | |
| pub_note | import_item_attr_definition | | TEXT | No | |
| pub_note_title | import_item_attr_definition | | TEXT | No | |
| pub_status | rec_descriptor | | TEXT | No | |
| purchase_order | lineitem | FK | INTEGER | No | purchase_order.id |
| purchase_order | po_note | FK | INTEGER | Yes | purchase_order.id, usr.id |
| purpose | queued_record | | TEXT | Yes | |
| quality | record_entry | | INTEGER | No | |
| quality | bib_source | | INTEGER | No | |
| question | survey_question | | TEXT | Yes | |
| question | survey_answer | FK | INTEGER | Yes | survey_question.id |
| question | survey_response | FK | INTEGER | Yes | survey_question.id |
| queue | queued_bib_record | | INTEGER | Yes | |
| queue | queued_authority_record | | INTEGER | Yes | |
| queued_record | authority_match | | BIGINT | No | |
| queued_record | bib_match | | BIGINT | No | |
| queue_type | authority_queue | | TEXT | Yes | |
| queue_type | queue | | TEXT | Yes | |
| queue_type | bib_queue | | TEXT | Yes | |
| ratio | exchange_rate | | NUMERIC | Yes | |
| reactor | event_definition | FK | TEXT | Yes | reactor.module |
| reason | org_unit_closed | | TEXT | No | |
| record | queued_bib_record_attr | | BIGINT | Yes | |
| record | import_item | | BIGINT | Yes | |
| record | queued_authority_record_attr | | BIGINT | Yes | |
| record | record_note | | BIGINT | Yes | |
| record | record_note | FK | BIGINT | Yes | record_entry.id, record_entry.id |
| record | rec_descriptor | | BIGINT | No | |
| record | full_rec | | BIGINT | Yes | |
| record_format | z3950_source | | TEXT | Yes | |
| record_status | rec_descriptor | | TEXT | No | |
| recurance_interval | rule_recuring_fine | | INTERVAL | Yes | |
| recuring_fine | aged_circulation | | NUMERIC(6, 2) | No | |
| recuring_fine | circulation | | NUMERIC(6, 2) | No | |
| recuring_fine_rule | circulation | | TEXT | Yes | |
| recuring_fine_rule | aged_circulation | | TEXT | Yes | |
| recurring_fine_rule | circ_matrix_matchpoint | | INTEGER | Yes | |
| recv_time | lineitem_detail | | TIMESTAMP | No | |
| ref | import_item_attr_definition | | TEXT | No | |
| ref | copy_transparency | | BOOLEAN | No | |
| ref | import_item | | BOOLEAN | No | |
| ref | asset.copy | | BOOLEAN | Yes | |
| ref_flag | circ_matrix_matchpoint | | BOOLEAN | No | |
| ref_flag | hold_matrix_matchpoint | | BOOLEAN | No | |
| remove | lineitem_generated_attr_definition | | TEXT | Yes | |
| remove | lineitem_usr_attr_definition | | TEXT | Yes | |
| remove | lineitem_local_attr_definition | | TEXT | Yes | |
| remove | bib_attr_definition | | TEXT | Yes | |
| remove | authority_attr_definition | | TEXT | Yes | |
| remove | lineitem_provider_attr_definition | | TEXT | Yes | |
| remove | lineitem_marc_attr_definition | | TEXT | Yes | |
| remove | lineitem_attr_definition | | TEXT | Yes | |
| renewal_remaining | circulation | | INTEGER | Yes | |
| renewal_remaining | aged_circulation | | INTEGER | Yes | |
| replaces | usr_address | FK | INTEGER | No | usr_address.id |
| requestor | hold_request | FK | INTEGER | Yes | usr.id |
| requestor | script | | INTEGER | Yes | |
| requestor_grp | hold_matrix_matchpoint | FK | INTEGER | Yes | grp_tree.id |
| request_lib | hold_request | FK | INTEGER | Yes | org_unit.id |
| request_ou | hold_matrix_matchpoint | FK | INTEGER | No | org_unit.id |
| request_time | hold_request | | TIMESTAMP | Yes | |
| required | survey | | BOOLEAN | Yes | |
| response_group_id | survey_response | | INTEGER | No | |
| return_time | hold_request | | TIMESTAMP | No | |
| role | provider_contact | | TEXT | No | |
| run_time | event | | TIMESTAMP WITH TIME ZONE | Yes | |
| script_test | circ_matrix_matchpoint | | TEXT | No | |
| search_field | metabib_field | | BOOLEAN | Yes | |
| second_given_name | usr | | TEXT | No | |
| selection_depth | hold_request | | INTEGER | Yes | |
| selection_ou | hold_request | | INTEGER | Yes | |
| selector | lineitem | FK | INTEGER | Yes | usr.id |
| session | script | | TEXT | Yes | |
| set_date | usr_standing_penalty | | TIMESTAMP | No | |
| shortname | org_unit | | TEXT | Yes | |
| shrt | rule_circ_duration | | INTERVAL | Yes | |
| sip2_media_type | circ_modifier | | TEXT | Yes | |
| skip_count | distribution_formula | | INTEGER | Yes | |
| source | series_field_entry | | BIGINT | Yes | |
| source | record_entry | | INTEGER | No | |
| source | transit_copy | FK | INTEGER | Yes | org_unit.id |
| source | z3950_attr | FK | TEXT | Yes | z3950_source.name, z3950_source.name |
| source | hold_transit_copy | | INTEGER | Yes | |
| source | record_entry | | INTEGER | No | |
| source | record_entry | | INTEGER | No | |
| source | bib_source | | TEXT | Yes | |
| source_label | lineitem | | TEXT | No | |
| source_send_time | hold_transit_copy | | TIMESTAMP | No | |
| source_send_time | transit_copy | | TIMESTAMP | No | |
| staff | in_house_use | FK | INTEGER | Yes | usr.id |
| staff | non_cat_in_house_use | FK | INTEGER | Yes | usr.id |
| staff | non_cataloged_circulation | FK | INTEGER | Yes | usr.id |
| staff | usr_standing_penalty | FK | INTEGER | No | usr.id |
| staff | usr_org_unit_opt_in | FK | INTEGER | Yes | usr.id |
| standing | usr | FK | INTEGER | Yes | standing.id, standing.id |
| standing_penalty | usr_standing_penalty | FK | INTEGER | Yes | standing_penalty.id |
| start_date | survey | | TIMESTAMP | Yes | |
| start_date | subscription | | DATE | Yes | |
| start_time | event | | TIMESTAMP WITH TIME ZONE | No | |
| start_time | session | | INTEGER | No | |
| state | purchase_order | | TEXT | Yes | |
| state | provider_address | | TEXT | Yes | |
| state | event | | TEXT | Yes | |
| state | provider_contact_address | | TEXT | Yes | |
| state | lineitem | | TEXT | Yes | |
| state | org_address | | TEXT | Yes | |
| state | usr_address | | TEXT | Yes | |
| status | asset.copy | | INTEGER | Yes | |
| status | import_item | | INTEGER | No | |
| status | import_item_attr_definition | | TEXT | No | |
| stat_cat | stat_cat_entry_usr_map | FK | INTEGER | Yes | stat_cat.id |
| stat_cat | stat_cat_entry | FK | INTEGER | Yes | stat_cat.id |
| stat_cat | stat_cat_entry_copy_map | FK | INTEGER | Yes | stat_cat.id |
| stat_cat | stat_cat_entry_transparency_map | | INTEGER | Yes | |
| stat_cat | stat_cat_entry | FK | INTEGER | Yes | stat_cat.id, org_unit.id |
| stat_cat_entry | stat_cat_entry_transparency_map | | INTEGER | Yes | |
| stat_cat_entry | stat_cat_entry_copy_map | FK | INTEGER | Yes | stat_cat_entry.id |
| stat_cat_entry | stat_cat_entry_usr_map | | TEXT | Yes | |
| stop_blocked_user | hold_matrix_matchpoint | | BOOLEAN | Yes | |
| stop_date | usr_standing_penalty | | TIMESTAMP | No | |
| stop_fines | aged_circulation | | TEXT | No | |
| stop_fines | circulation | | TEXT | No | |
| stop_fines_time | circulation | | TIMESTAMP | No | |
| stop_fines_time | aged_circulation | | TIMESTAMP | No | |
| street1 | org_address | | TEXT | Yes | |
| street1 | provider_contact_address | | TEXT | Yes | |
| street1 | usr_address | | TEXT | Yes | |
| street1 | provider_address | | TEXT | Yes | |
| street2 | usr_address | | TEXT | No | |
| street2 | org_address | | TEXT | No | |
| street2 | provider_address | | TEXT | No | |
| street2 | provider_contact_address | | TEXT | No | |
| string | i18n_core | | TEXT | Yes | |
| string | idl_field_doc | | TEXT | Yes | |
| subfield | full_rec | | TEXT | No | |
| subfield | provider_holding_subfield_map | | TEXT | Yes | |
| subfield | real_full_rec | | TEXT | No | |
| subscription | issuance | FK | INTEGER | Yes | subscription.id |
| subscription | index_summary | FK | INTEGER | Yes | subscription.id |
| subscription | sup_summary | FK | INTEGER | Yes | subscription.id |
| subscription | bib_summary | FK | INTEGER | Yes | subscription.id |
| subscription | binding_unit | FK | INTEGER | Yes | subscription.id |
| suffix | usr | | TEXT | No | |
| super_user | usr | | BOOLEAN | Yes | |
| survey | survey_question | FK | INTEGER | Yes | survey.id |
| survey | survey_response | FK | INTEGER | Yes | survey.id |
| tag | full_rec | | CHARACTER(3) | Yes | |
| tag | fund_tag_map | FK | INTEGER | No | fund_tag.id |
| tag | real_full_rec | | CHARACTER(3) | Yes | |
| tag | import_item_attr_definition | | TEXT | Yes | |
| target | hold_request | | BIGINT | Yes | |
| target | event | | BIGINT | Yes | |
| target_biblio_record_entry | biblio_record_entry_bucket_item | FK | INTEGER | Yes | record_entry.id |
| target_call_number | call_number_bucket_item | FK | INTEGER | Yes | call_number.id |
| target_copy | copy_bucket_item | FK | INTEGER | Yes | asset.copy.id |
| target_copy | circulation | FK | BIGINT | Yes | asset.copy.id |
| target_copy | hold_transit_copy | FK | BIGINT | Yes | asset.copy.id |
| target_copy | hold_copy_map | FK | BIGINT | Yes | asset.copy.id |
| target_copy | transit_copy | FK | BIGINT | Yes | asset.copy.id |
| target_copy | issuance | FK | BIGINT | No | asset.copy.id |
| target_user | user_bucket_item | FK | INTEGER | Yes | usr.id |
| target_usr | stat_cat_entry_usr_map | FK | INTEGER | Yes | usr.id |
| tcn_source | record_entry | | TEXT | Yes | |
| tcn_value | record_entry | | TEXT | Yes | |
| template | event_definition | | TEXT | No | |
| template_output | event | FK | BIGINT | No | event_output.id |
| textual_holdings | bib_summary | | TEXT | No | |
| textual_holdings | index_summary | | TEXT | No | |
| textual_holdings | sup_summary | | TEXT | No | |
| thaw_date | hold_request | | TIMESTAMP | No | |
| threshold | grp_penalty_threshold | | NUMERIC(8, 2) | Yes | |
| time_delta | script | | INTEGER | Yes | |
| title | usr_note | | TEXT | Yes | |
| title | call_number_note | | TEXT | Yes | |
| title | copy_note | | TEXT | Yes | |
| to_currency | exchange_rate | FK | TEXT | Yes | currency_type.code |
| to_org | org_unit_proximity | | INTEGER | No | |
| transcendant | bib_source | | BOOLEAN | Yes | |
| transit_range | hold_matrix_matchpoint | FK | INTEGER | No | org_unit_type.id |
| translation | i18n_core | FK | TEXT | Yes | i18n_locale.code |
| transmission_format | z3950_source | | TEXT | Yes | |
| transparency | copy_transparency_map | FK | INTEGER | Yes | copy_transparency.id |
| truncation | z3950_attr | | INTEGER | Yes | |
| type_mat | rec_descriptor | | TEXT | No | |
| unrecovered | grocery | | BOOLEAN | No | |
| unrecovered | billable_xact | | BOOLEAN | No | |
| unrecovered | circulation | | BOOLEAN | No | |
| unrecovered | aged_circulation | | BOOLEAN | No | |
| update_process | event | | INTEGER | No | |
| update_time | event | | TIMESTAMP WITH TIME ZONE | No | |
| uri | subscription | FK | INTEGER | No | uri.id |
| uri | uri_call_number_map | FK | INTEGER | Yes | uri.id |
| usergroup | grp_tree | | BOOLEAN | Yes | |
| user_home_ou | hold_matrix_matchpoint | FK | INTEGER | No | org_unit.id |
| use_restriction | uri | | TEXT | No | |
| use_time | in_house_use | | TIMESTAMP | Yes | |
| use_time | non_cat_in_house_use | | TIMESTAMP | Yes | |
| usr | hold_request | FK | INTEGER | Yes | usr.id |
| usr | card | FK | INTEGER | Yes | usr.id |
| usr | usr_note | FK | BIGINT | Yes | usr.id |
| usr | usr_setting | FK | INTEGER | Yes | usr.id |
| usr | lineitem_usr_attr_definition | FK | INTEGER | Yes | usr.id |
| usr | usr_org_unit_opt_in | FK | INTEGER | Yes | usr.id |
| usr | usr_perm_map | FK | INTEGER | Yes | usr.id |
| usr | usr_object_perm_map | FK | INTEGER | Yes | usr.id |
| usr | usr_standing_penalty | FK | INTEGER | Yes | usr.id |
| usr | usr_address | FK | INTEGER | Yes | usr.id |
| usr | collections_tracker | FK | INTEGER | Yes | usr.id |
| usr | usr_grp_map | FK | INTEGER | Yes | usr.id |
| usr | grocery | | INTEGER | Yes | |
| usr | usr_work_ou_map | FK | INTEGER | Yes | usr.id |
| usr | survey_response | FK | INTEGER | No | usr.id |
| usr | circulation | FK | INTEGER | No | usr.id |
| usr | billable_xact | FK | INTEGER | Yes | usr.id |
| usrgroup | usr | | SERIAL | Yes | |
| usrname | usr | | TEXT | Yes | |
| usr_age_lower_bound | circ_matrix_matchpoint | | INTERVAL | No | |
| usr_age_upper_bound | circ_matrix_matchpoint | | INTERVAL | No | |
| usr_birth_year | aged_circulation | | INTEGER | No | |
| usr_grp | hold_matrix_matchpoint | FK | INTEGER | No | grp_tree.id |
| usr_home_ou | aged_circulation | | INTEGER | Yes | |
| usr_post_code | aged_circulation | | TEXT | No | |
| usr_profile | aged_circulation | | INTEGER | Yes | |
| usr_summary | survey | | BOOLEAN | Yes | |
| valid | provider_contact_address | | BOOLEAN | Yes | |
| valid | provider_address | | BOOLEAN | Yes | |
| valid | org_address | | BOOLEAN | Yes | |
| valid | usr_address | | BOOLEAN | Yes | |
| validator | event_definition | FK | TEXT | Yes | validator.module |
| value | item_form_map | | TEXT | Yes | |
| value | language_map | | TEXT | Yes | |
| value | audience_map | | TEXT | Yes | |
| value | real_full_rec | | TEXT | Yes | |
| value | keyword_field_entry | | TEXT | Yes | |
| value | subject_field_entry | | TEXT | Yes | |
| value | lit_form_map | | TEXT | Yes | |
| value | title_field_entry | | TEXT | Yes | |
| value | record_note | | TEXT | Yes | |
| value | lineitem_note | | TEXT | Yes | |
| value | call_number_note | | TEXT | Yes | |
| value | record_note | | TEXT | Yes | |
| value | author_field_entry | | TEXT | Yes | |
| value | item_type_map | | TEXT | Yes | |
| value | stat_cat_entry | | TEXT | Yes | |
| value | bib_level_map | | TEXT | Yes | |
| value | org_unit_setting | | TEXT | Yes | |
| value | usr_note | | TEXT | Yes | |
| value | usr_setting | | TEXT | Yes | |
| value | copy_note | | TEXT | Yes | |
| value | videorecording_format_map | | TEXT | Yes | |
| value | stat_cat_entry | | TEXT | Yes | |
| value | series_field_entry | | TEXT | Yes | |
| value | standing | | TEXT | Yes | |
| value | full_rec | | TEXT | Yes | |
| value | event_params | | TEXT | Yes | |
| value | po_note | | TEXT | Yes | |
| version | upgrade_log | PK | TEXT | Yes | |
| voided | bnm_desk_payment | | BOOLEAN | Yes | |
| voided | billing | | BOOLEAN | Yes | |
| voided | credit_card_payment | | BOOLEAN | Yes | |
| voided | work_payment | | BOOLEAN | Yes | |
| voided | payment | | BOOLEAN | Yes | |
| voided | forgive_payment | | BOOLEAN | Yes | |
| voided | bnm_payment | | BOOLEAN | Yes | |
| voided | cash_payment | | BOOLEAN | Yes | |
| voided | goods_payment | | BOOLEAN | Yes | |
| voided | credit_payment | | BOOLEAN | Yes | |
| voided | check_payment | | BOOLEAN | Yes | |
| voider | billing | | INTEGER | No | |
| void_time | billing | | TIMESTAMP | No | |
| vr_format | rec_descriptor | | TEXT | No | |
| weight | metabib_field | | INTEGER | Yes | |
| within_city_limits | usr_address | | BOOLEAN | Yes | |
| workstation | script | | TEXT | Yes | |
| work_ou | usr_work_ou_map | FK | INTEGER | Yes | org_unit.id |
| xact | check_payment | PK, FK | BIGINT | Yes | bnm_desk_payment.xact |
| xact | payment | FK | BIGINT | Yes | billable_xact.id |
| xact | billing | FK | BIGINT | Yes | billable_xact.id |
| xact | workstation | FK | BIGINT | Yes | bnm_desk_payment.xact |
| xact | credit_card_payment | PK, FK | BIGINT | Yes | bnm_desk_payment.xact |
| xact | bnm_payment | PK | BIGINT | Yes | |
| xact | goods_payment | PK, FK | BIGINT | Yes | bnm_payment.xact |
| xact | cash_payment | PK, FK | BIGINT | Yes | bnm_desk_payment.xact |
| xact | bnm_desk_payment | PK, FK | BIGINT | Yes | bnm_payment.xact |
| xact | credit_payment | PK, FK | BIGINT | Yes | bnm_payment.xact |
| xact | work_payment | PK, FK | BIGINT | Yes | bnm_payment.xact |
| xact | forgive_payment | PK, FK | BIGINT | Yes | bnm_payment.xact |
| xact_finish | grocery | | TIMESTAMP | No | |
| xact_finish | billable_xact | | TIMESTAMP | No | |
| xact_finish | circulation | | TIMESTAMP | No | |
| xact_finish | aged_circulation | | TIMESTAMP | No | |
| xact_start | billable_xact | | TIMESTAMP | Yes | |
| xact_start | aged_circulation | | TIMESTAMP | Yes | |
| xact_start | grocery | | TIMESTAMP | Yes | |
| xact_start | circulation | | TIMESTAMP | Yes | |
| xfer_destination | fund_debit | FK | INTEGER | No | fund.id, currency_type.code |
| xpath | bib_attr_definition | | TEXT | Yes | |
| xpath | lineitem_generated_attr_definition | | TEXT | Yes | |
| xpath | lineitem_provider_attr_definition | | TEXT | Yes | |
| xpath | lineitem_marc_attr_definition | | TEXT | Yes | |
| xpath | authority_attr_definition | | TEXT | Yes | |
| xpath | metabib_field | | TEXT | Yes | |
| xslt | xml_transform | | TEXT | Yes | |
| year | fund | | INTEGER | Yes | |