# CollectiveAccess v1.1 datamodel # # This file defines the relational datamodel used by the application. # # "tables" below lists all of the tables in the application datamodel that have # a likenamed model-class (an application class inheriting from either BaseModel or its subclasses). # ** DO NOT list tables that for whatever reason do not have a corresponding model class ** # # "relationships" below lists all of the relationships between tables in the datamodel, using # the format ". = .". The listed relationships are used to verify # relational integrity, generate full-text indices across tables and populate user interface elements # that incorporate data from more than one table. In general, you should explicitly list # all relationships here unless you know why you shouldn't. tables = { "ca_acl" = 1, "ca_application_vars" = 2, "ca_attribute_values" = 3, "ca_attributes" = 4, "ca_change_log" = 5, "ca_change_log_subjects" = 6, "ca_representation_annotations_x_entities" = 7, "ca_representation_annotations_x_objects" = 8, "ca_representation_annotations_x_occurrences" = 9, "ca_representation_annotations_x_places" = 10, "ca_representation_annotations_x_vocabulary_terms" = 11, "ca_collection_labels" = 12, "ca_collections" = 13, "ca_collections_x_collections" = 14, "ca_collections_x_vocabulary_terms" = 15, "ca_data_import_events" = 17, "ca_data_import_items" = 18, "ca_entities" = 20, "ca_entities_x_collections" = 21, "ca_entities_x_occurrences" = 22, "ca_entities_x_places" = 23, "ca_entities_x_vocabulary_terms" = 24, "ca_entity_labels" = 25, "ca_entities_x_entities" = 26, #"ca_eventlog" = 27, "ca_groups_x_roles" = 30, "ca_ips" = 31, "ca_list_item_labels" = 32, "ca_list_items" = 33, "ca_list_items_x_list_items" = 34, "ca_list_labels" = 35, "ca_lists" = 36, "ca_locales" = 37, "ca_object_lot_events" = 38, "ca_object_lot_events_x_storage_locations" = 39, "ca_object_lot_labels" = 40, "ca_metadata_element_labels" = 41, "ca_metadata_elements" = 42, "ca_metadata_type_restrictions" = 43, "ca_multipart_idno_sequences" = 44, "ca_object_events" = 45, "ca_object_events_x_entities" = 46, "ca_object_events_x_occurrences" = 47, "ca_object_events_x_places" = 48, "ca_object_events_x_storage_locations" = 49, "ca_object_labels" = 50, "ca_object_lots" = 51, "ca_object_lots_x_collections" = 52, "ca_object_lots_x_entities" = 53, "ca_object_lots_x_occurrences" = 54, "ca_object_lots_x_places" = 55, "ca_object_representations" = 56, "ca_objects" = 57, "ca_objects_x_collections" = 58, "ca_objects_x_entities" = 59, "ca_objects_x_object_representations" = 61, "ca_objects_x_objects" = 62, "ca_objects_x_occurrences" = 63, "ca_objects_x_places" = 64, "ca_objects_x_vocabulary_terms" = 65, "ca_occurrence_labels" = 66, "ca_occurrences" = 67, "ca_occurrences_x_collections" = 68, "ca_occurrences_x_occurrences" = 69, "ca_occurrences_x_vocabulary_terms" = 70, "ca_place_labels" = 71, "ca_places" = 72, "ca_places_x_collections" = 73, "ca_places_x_occurrences" = 74, "ca_places_x_places" = 75, "ca_places_x_vocabulary_terms" = 76, "ca_relationship_relationships" = 77, "ca_relationship_type_labels" = 78, "ca_relationship_types" = 79, "ca_representation_annotations" = 82, "ca_representation_annotation_labels" = 83, "ca_object_representations_x_entities" = 85, "ca_object_representations_x_occurrences" = 86, "ca_object_representations_x_places" = 87, "ca_storage_location_labels" = 88, "ca_storage_locations" = 89, "ca_task_queue" = 90, "ca_user_groups" = 91, "ca_user_roles" = 92, "ca_users" = 94, "ca_users_x_groups" = 95, "ca_users_x_roles" = 96, "ca_editor_ui_bundle_placements" = 97, "ca_editor_ui_labels" = 98, "ca_editor_ui_screen_labels" = 99, "ca_editor_ui_screens" = 100, "ca_editor_uis" = 101, "ca_editor_uis_x_user_groups" = 102, "ca_sets" = 103, "ca_set_labels" = 104, "ca_set_items" = 105, "ca_set_item_labels" = 106, "ca_sets_x_user_groups" = 107, "ca_object_representation_labels" = 108, "ca_item_comments" = 109, "ca_item_tags" = 110, "ca_items_x_tags" = 111, "ca_item_views" = 112, "ca_object_event_labels" = 113, "ca_object_lots_x_vocabulary_terms" = 115, "ca_object_representations_x_vocabulary_terms" = 116, "ca_object_events_x_vocabulary_terms" = 117, "ca_object_lot_events_x_vocabulary_terms" = 118, "ca_objects_x_storage_locations" = 119, "ca_object_lots_x_storage_locations" = 120, "ca_search_forms" = 121, "ca_search_form_labels" = 122, "ca_object_representation_multifiles" = 123, "ca_bundle_displays" = 124, "ca_bundle_display_placements" = 125, "ca_bundle_display_labels" = 126, "ca_bundle_displays_x_user_groups" = 127, "ca_bundle_mappings" = 128, "ca_bundle_mapping_labels" = 129, "ca_bundle_mapping_groups" = 130, "ca_editor_ui_screen_type_restrictions" = 131, "ca_collections_x_storage_locations" = 132, "ca_loans" = 133, "ca_loan_labels" = 134, "ca_loans_x_objects" = 135, "ca_loans_x_entities" = 136, "ca_movements" = 137, "ca_movement_labels" = 138, "ca_movements_x_objects" = 139, "ca_movements_x_object_lots" = 140, "ca_movements_x_entities" = 141, "ca_object_lot_event_labels" = 142, "ca_loans_x_movements" = 143, "ca_watch_list" = 144, "ca_user_notes" = 145, "ca_data_import_event_log" = 146, "ca_search_forms_x_user_groups" = 147, "ca_search_forms_x_users" = 148, "ca_bundle_displays_x_users" = 149, "ca_sets_x_users" = 150, "ca_editor_uis_x_users" = 151, "ca_search_form_placements" = 152, "ca_tours" = 153, "ca_tour_labels" = 154, "ca_tour_stops" = 155, "ca_tour_stop_labels" = 156, "ca_tour_stops_x_objects" = 157, "ca_tour_stops_x_entities" = 158, "ca_tour_stops_x_places" = 159, "ca_tour_stops_x_occurrences" = 160, "ca_tour_stops_x_collections" = 161, "ca_tour_stops_x_vocabulary_terms" = 162, "ca_tour_stops_x_tour_stops" = 163, "ca_bookmark_folders" = 164, "ca_bookmarks" = 165, "ca_commerce_transactions" = 166, "ca_commerce_communications" = 167, "ca_commerce_orders" = 169, "ca_commerce_order_items" = 170, "ca_commerce_fulfillment_events" = 171, "ca_object_representations_x_collections" = 172, "ca_object_representations_x_storage_locations" = 173, "ca_object_representations_x_object_representations" = 174, "ca_bundle_mapping_rules" = 175, "ca_bundle_mapping_group_labels" = 176, "ca_entities_x_storage_locations" = 177, "ca_loans_x_collections" = 178, "ca_loans_x_object_lots" = 179, "ca_loans_x_occurrences" = 180, "ca_loans_x_places" = 181, "ca_loans_x_storage_locations" = 182, "ca_loans_x_vocabulary_terms" = 183, "ca_loans_x_loans" = 184, "ca_movements_x_collections" = 185, "ca_movements_x_occurrences" = 186, "ca_movements_x_places" = 187, "ca_movements_x_storage_locations" = 188, "ca_movements_x_vocabulary_terms" = 189, "ca_movements_x_movements" = 190, "ca_places_x_storage_locations" = 191, "ca_occurrences_x_storage_locations" = 192, "ca_storage_locations_x_vocabulary_terms" = 193, "ca_storage_locations_x_storage_locations" = 194 } relationships = [ "ca_acl.group_id = ca_user_groups.group_id", "ca_acl.user_id = ca_users.user_id", "ca_attributes.element_id = ca_metadata_elements.element_id", "ca_attributes.attribute_id = ca_attribute_values.attribute_id", "ca_attribute_values.element_id = ca_metadata_elements.element_id", "ca_attributes.locale_id = ca_locales.locale_id 1000", "ca_attribute_values.item_id = ca_list_items.item_id", "ca_change_log_subjects.log_id = ca_change_log.log_id", "ca_representation_annotations_x_entities.entity_id = ca_entities.entity_id", "ca_representation_annotations_x_entities.type_id = ca_relationship_types.type_id", "ca_representation_annotations_x_entities.annotation_id = ca_representation_annotations.annotation_id", "ca_representation_annotations_x_objects.annotation_id = ca_representation_annotations.annotation_id", "ca_representation_annotations_x_objects.object_id = ca_objects.object_id", "ca_representation_annotations_x_objects.type_id = ca_relationship_types.type_id", "ca_representation_annotations_x_occurrences.annotation_id = ca_representation_annotations.annotation_id", "ca_representation_annotations_x_occurrences.type_id = ca_relationship_types.type_id", "ca_representation_annotations_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_representation_annotations_x_places.type_id = ca_relationship_types.type_id", "ca_representation_annotations_x_places.place_id = ca_places.place_id", "ca_representation_annotations_x_places.annotation_id = ca_representation_annotations.annotation_id", "ca_representation_annotations_x_vocabulary_terms.annotation_id = ca_representation_annotations.annotation_id", "ca_representation_annotations_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_representation_annotations_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_collection_labels.locale_id = ca_locales.locale_id 1000", "ca_collection_labels.type_id = ca_list_items.item_id 500", "ca_collection_labels.collection_id = ca_collections.collection_id", "ca_collections.locale_id = ca_locales.locale_id 1000", "ca_collections.type_id = ca_list_items.item_id 500", "ca_collections.source_id = ca_list_items.item_id 500", "ca_collections_x_collections.collection_left_id = ca_collections.collection_id", "ca_collections_x_collections.collection_right_id = ca_collections.collection_id", "ca_collections_x_collections.type_id = ca_relationship_types.type_id", "ca_collections_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_collections_x_vocabulary_terms.collection_id = ca_collections.collection_id", "ca_collections_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_collections_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_collections_x_storage_locations.collection_id = ca_collections.collection_id", "ca_collections_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_places_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_places_x_storage_locations.collection_id = ca_places.place_id", "ca_places_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_occurrences_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_occurrences_x_storage_locations.occurrence_id = ca_occurrences.occurrence_id", "ca_occurrences_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_data_import_events.user_id = ca_users.user_id", "ca_data_import_items.event_id = ca_data_import_events.event_id", "ca_data_import_event_log.event_id = ca_data_import_events.event_id", "ca_data_import_event_log.item_id = ca_data_import_items.item_id", "ca_entities.locale_id = ca_locales.locale_id 1000", "ca_entities.source_id = ca_list_items.item_id 500", "ca_entities.type_id = ca_list_items.item_id 500", "ca_entities_x_collections.collection_id = ca_collections.collection_id", "ca_entities_x_collections.entity_id = ca_entities.entity_id", "ca_entities_x_collections.type_id = ca_relationship_types.type_id", "ca_entities_x_occurrences.entity_id = ca_entities.entity_id", "ca_entities_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_entities_x_occurrences.type_id = ca_relationship_types.type_id", "ca_entities_x_places.entity_id = ca_entities.entity_id", "ca_entities_x_places.place_id = ca_places.place_id", "ca_entities_x_places.type_id = ca_relationship_types.type_id", "ca_entities_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_entities_x_vocabulary_terms.entity_id = ca_entities.entity_id", "ca_entities_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_entity_labels.locale_id = ca_locales.locale_id 1000", "ca_entity_labels.entity_id = ca_entities.entity_id", "ca_entity_labels.type_id = ca_list_items.item_id 500", "ca_entities_x_entities.entity_left_id = ca_entities.entity_id", "ca_entities_x_entities.entity_right_id = ca_entities.entity_id", "ca_entities_x_entities.type_id = ca_relationship_types.type_id", "ca_groups_x_roles.group_id = ca_user_groups.group_id", "ca_groups_x_roles.role_id = ca_user_roles.role_id", "ca_ips.user_id = ca_users.user_id", "ca_list_item_labels.item_id = ca_list_items.item_id 500", "ca_list_item_labels.locale_id = ca_locales.locale_id 1000", "ca_list_item_labels.type_id = ca_list_items.item_id 500", "ca_list_items.list_id = ca_lists.list_id", # "ca_list_items.type_id = ca_list_items.item_id 500", "ca_list_items_x_list_items.type_id = ca_relationship_types.type_id", "ca_list_items_x_list_items.term_left_id = ca_list_items.item_id", "ca_list_items_x_list_items.term_right_id = ca_list_items.item_id", "ca_list_labels.list_id = ca_lists.list_id", "ca_list_labels.locale_id = ca_locales.locale_id", "ca_object_lot_events.lot_id = ca_object_lots.lot_id", "ca_object_lot_events.type_id = ca_list_items.item_id 500", "ca_object_lot_events_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_object_lot_events_x_storage_locations.event_id = ca_object_lot_events.event_id", "ca_object_lot_events_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_object_lot_labels.lot_id = ca_object_lots.lot_id", "ca_object_lot_labels.locale_id = ca_locales.locale_id 1000", "ca_object_lot_labels.type_id = ca_list_items.item_id 500", "ca_metadata_element_labels.element_id = ca_metadata_elements.element_id", "ca_metadata_element_labels.locale_id = ca_locales.locale_id 1000", "ca_metadata_elements.list_id = ca_lists.list_id", "ca_metadata_type_restrictions.element_id = ca_metadata_elements.element_id", "ca_object_events.type_id = ca_list_items.item_id 500", "ca_object_events_x_entities.event_id = ca_object_events.event_id", "ca_object_events_x_entities.entity_id = ca_entities.entity_id", "ca_object_events_x_entities.type_id = ca_relationship_types.type_id", "ca_object_events_x_occurrences.event_id = ca_object_events.event_id", "ca_object_events_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_object_events_x_occurrences.type_id = ca_relationship_types.type_id", "ca_object_events_x_places.event_id = ca_object_events.event_id", "ca_object_events_x_places.place_id = ca_places.place_id", "ca_object_events_x_places.type_id = ca_relationship_types.type_id", "ca_object_events_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_object_events_x_storage_locations.event_id = ca_object_events.event_id", "ca_object_events_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_object_labels.locale_id = ca_locales.locale_id 1000", "ca_object_labels.type_id = ca_list_items.item_id 500", "ca_object_labels.object_id = ca_objects.object_id", "ca_object_event_labels.locale_id = ca_locales.locale_id 1000", "ca_object_event_labels.type_id = ca_list_items.item_id 500", "ca_object_event_labels.event_id = ca_object_events.event_id", "ca_object_lots.type_id = ca_list_items.item_id 500", "ca_object_lots.lot_status_id = ca_list_items.item_id 500", "ca_object_lots_x_collections.collection_id = ca_collections.collection_id", "ca_object_lots_x_collections.type_id = ca_relationship_types.type_id", "ca_object_lots_x_collections.lot_id = ca_object_lots.lot_id", "ca_object_lots_x_entities.entity_id = ca_entities.entity_id", "ca_object_lots_x_entities.lot_id = ca_object_lots.lot_id", "ca_object_lots_x_entities.type_id = ca_relationship_types.type_id", "ca_object_lots_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_object_lots_x_occurrences.lot_id = ca_object_lots.lot_id", "ca_object_lots_x_occurrences.type_id = ca_relationship_types.type_id", "ca_object_lots_x_places.type_id = ca_relationship_types.type_id", "ca_object_lots_x_places.place_id = ca_places.place_id", "ca_object_lots_x_places.lot_id = ca_object_lots.lot_id", "ca_object_representations.locale_id = ca_locales.locale_id 1000", "ca_object_representations.type_id = ca_list_items.item_id 500", "ca_object_representations.representation_id = ca_object_representation_labels.representation_id", "ca_object_representation_labels.locale_id = ca_locales.locale_id 1000", "ca_object_representation_labels.type_id = ca_list_items.item_id 500", "ca_object_representation_multifiles.representation_id = ca_object_representations.representation_id", "ca_objects.lot_id = ca_object_lots.lot_id", "ca_objects.locale_id = ca_locales.locale_id 1000", "ca_objects.source_id = ca_list_items.item_id 500", "ca_objects.type_id = ca_list_items.item_id 500", "ca_objects.acquisition_type_id = ca_list_items.item_id 500", "ca_objects.item_status_id = ca_list_items.item_id 500", "ca_objects_x_collections.object_id = ca_objects.object_id", "ca_objects_x_collections.collection_id = ca_collections.collection_id", "ca_objects_x_collections.type_id = ca_relationship_types.type_id", "ca_objects_x_entities.entity_id = ca_entities.entity_id", "ca_objects_x_entities.object_id = ca_objects.object_id", "ca_objects_x_entities.type_id = ca_relationship_types.type_id", "ca_objects_x_object_representations.object_id = ca_objects.object_id", "ca_objects_x_object_representations.representation_id = ca_object_representations.representation_id", "ca_objects_x_objects.object_left_id = ca_objects.object_id", "ca_objects_x_objects.object_right_id = ca_objects.object_id", "ca_objects_x_objects.type_id = ca_relationship_types.type_id", "ca_objects_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_objects_x_occurrences.object_id = ca_objects.object_id", "ca_objects_x_occurrences.type_id = ca_relationship_types.type_id", "ca_objects_x_places.place_id = ca_places.place_id", "ca_objects_x_places.object_id = ca_objects.object_id", "ca_objects_x_places.type_id = ca_relationship_types.type_id", "ca_objects_x_vocabulary_terms.object_id = ca_objects.object_id", "ca_objects_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_objects_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_occurrence_labels.locale_id = ca_locales.locale_id 1000", "ca_occurrence_labels.type_id = ca_list_items.item_id 500", "ca_occurrence_labels.occurrence_id = ca_occurrences.occurrence_id", "ca_occurrences.locale_id = ca_locales.locale_id 1000", "ca_occurrences.type_id = ca_list_items.item_id 500", "ca_occurrences.source_id = ca_list_items.item_id 500", "ca_occurrences_x_collections.occurrence_id = ca_occurrences.occurrence_id", "ca_occurrences_x_collections.collection_id = ca_collections.collection_id", "ca_occurrences_x_collections.type_id = ca_relationship_types.type_id", "ca_occurrences_x_occurrences.occurrence_left_id = ca_occurrences.occurrence_id", "ca_occurrences_x_occurrences.occurrence_right_id = ca_occurrences.occurrence_id", "ca_occurrences_x_occurrences.type_id = ca_relationship_types.type_id", "ca_occurrences_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_occurrences_x_vocabulary_terms.occurrence_id = ca_occurrences.occurrence_id", "ca_occurrences_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_place_labels.place_id = ca_places.place_id", "ca_place_labels.locale_id = ca_locales.locale_id 1000", "ca_place_labels.type_id = ca_list_items.item_id 500", "ca_places.hierarchy_id = ca_list_items.item_id 500", "ca_places.locale_id = ca_locales.locale_id 1000", "ca_places.source_id = ca_list_items.item_id 500", "ca_places.type_id = ca_list_items.item_id 500", "ca_places_x_collections.collection_id = ca_collections.collection_id", "ca_places_x_collections.place_id = ca_places.place_id", "ca_places_x_collections.type_id = ca_relationship_types.type_id", "ca_places_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_places_x_occurrences.place_id = ca_places.place_id", "ca_places_x_occurrences.type_id = ca_relationship_types.type_id", "ca_places_x_places.place_left_id = ca_places.place_id", "ca_places_x_places.place_right_id = ca_places.place_id", "ca_places_x_places.type_id = ca_relationship_types.type_id", "ca_places_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_places_x_vocabulary_terms.place_id = ca_places.place_id", "ca_places_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_relationship_relationships.type_id = ca_relationship_types.type_id", "ca_relationship_type_labels.type_id = ca_relationship_types.type_id", "ca_relationship_type_labels.locale_id = ca_locales.locale_id 1000", "ca_representation_annotations.user_id = ca_users.user_id", "ca_representation_annotations.representation_id = ca_object_representations.representation_id", "ca_representation_annotation_labels.annotation_id = ca_representation_annotations.annotation_id", "ca_representation_annotation_labels.locale_id = ca_locales.locale_id 1000", "ca_representation_annotation_labels.type_id = ca_list_items.item_id 500", "ca_representation_annotations.representation_id = ca_object_representations.representation_id", "ca_representation_annotations.locale_id = ca_locales.locale_id 1000", "ca_object_representations_x_entities.representation_id = ca_object_representations.representation_id", "ca_object_representations_x_entities.entity_id = ca_entities.entity_id", "ca_object_representations_x_entities.type_id = ca_relationship_types.type_id", "ca_object_representations_x_occurrences.representation_id = ca_object_representations.representation_id", "ca_object_representations_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_object_representations_x_occurrences.type_id = ca_relationship_types.type_id", "ca_object_representations_x_places.representation_id = ca_object_representations.representation_id", "ca_object_representations_x_places.place_id = ca_places.place_id", "ca_object_representations_x_places.type_id = ca_relationship_types.type_id", "ca_object_representations_x_collections.representation_id = ca_object_representations.representation_id", "ca_object_representations_x_collections.collection_id = ca_collections.collection_id", "ca_object_representations_x_collections.type_id = ca_relationship_types.type_id", "ca_object_representations_x_storage_locations.representation_id = ca_object_representations.representation_id", "ca_object_representations_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_object_representations_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_object_representations_x_object_representations.representation_left_id = ca_object_representations.representation_id", "ca_object_representations_x_object_representations.representation_right_id = ca_object_representations.ca_object_representations", "ca_object_representations_x_object_representations.type_id = ca_relationship_types.type_id", "ca_storage_location_labels.location_id = ca_storage_locations.location_id", "ca_storage_location_labels.locale_id = ca_locales.locale_id 1000", "ca_storage_location_labels.type_id = ca_list_items.item_id 500", "ca_storage_locations.type_id = ca_list_items.item_id 500", "ca_users_x_groups.user_id = ca_users.user_id", "ca_users_x_groups.group_id = ca_user_groups.group_id", "ca_users_x_roles.user_id = ca_users.user_id", "ca_users_x_roles.role_id = ca_user_roles.role_id", "ca_editor_uis.user_id = ca_users.user_id", "ca_editor_ui_labels.ui_id = ca_editor_uis.ui_id", "ca_editor_ui_labels.locale_id = ca_locales.locale_id 1000", "ca_editor_uis_x_user_groups.ui_id = ca_editor_uis.ui_id", "ca_editor_uis_x_user_groups.group_id = ca_user_groups.group_id", "ca_editor_uis.ui_id = ca_editor_uis_x_users.ui_id", "ca_editor_uis_x_users.user_id = ca_users.user_id", "ca_editor_ui_screens.ui_id = ca_editor_uis.ui_id", "ca_editor_ui_screen_labels.screen_id = ca_editor_ui_screens.screen_id", "ca_editor_ui_screen_labels.locale_id = ca_locales.locale_id 1000", "ca_editor_ui_bundle_placements.screen_id = ca_editor_ui_screens.screen_id", "ca_editor_ui_screen_type_restrictions.screen_id = ca_editor_ui_screens.screen_id", "ca_sets.set_id = ca_set_labels.set_id", "ca_sets.user_id = ca_users.user_id", "ca_set_labels.locale_id = ca_locales.locale_id 1000", "ca_set_items.set_id = ca_sets.set_id", "ca_set_item_labels.item_id = ca_set_items.item_id", "ca_set_item_labels.locale_id = ca_locales.locale_id 1000", "ca_sets.set_id = ca_sets_x_user_groups.set_id", "ca_sets_x_user_groups.group_id = ca_user_groups.group_id", "ca_sets.set_id = ca_sets_x_users.set_id", "ca_sets_x_users.user_id = ca_users.user_id", "ca_item_comments.user_id = ca_users.user_id", "ca_item_comments.locale_id = ca_locales.locale_id", "ca_item_tags.tag_id = ca_items_x_tags.tag_id", "ca_item_tags.locale_id = ca_locales.locale_id", "ca_items_x_tags.user_id = ca_users.user_id", "ca_item_views.user_id = ca_users.user_id", "ca_item_views.locale_id = ca_locales.locale_id", "ca_object_lots_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_object_lots_x_vocabulary_terms.lot_id = ca_object_lots.lot_id", "ca_object_lots_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_object_representations_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_object_representations_x_vocabulary_terms.representation_id = ca_object_representations.representation_id", "ca_object_representations_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_object_events_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_object_events_x_vocabulary_terms.event_id = ca_object_events.event_id", "ca_object_events_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_object_lot_events_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_object_lot_events_x_vocabulary_terms.event_id = ca_object_lot_events.event_id", "ca_object_lot_events_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_objects_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_objects_x_storage_locations.object_id = ca_objects.object_id", "ca_objects_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_entities_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_entities_x_storage_locations.entity_id = ca_entities.entity_id", "ca_entities_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_object_lots_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_object_lots_x_storage_locations.lot_id = ca_object_lots.lot_id", "ca_object_lots_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_object_lots_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_storage_locations_x_vocabulary_terms.location_id = ca_storage_locations.location_id", "ca_storage_locations_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_storage_locations_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_storage_locations_x_storage_locations.location_left_id = ca_storage_locations.location_id", "ca_storage_locations_x_storage_locations.location_right_id = ca_storage_locations.location_id", "ca_storage_locations_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_search_forms.form_id = ca_search_form_labels.form_id", "ca_search_forms.user_id = ca_users.user_id", "ca_search_form_labels.locale_id = ca_locales.locale_id", "ca_search_form_placements.form_id = ca_search_forms.form_id", "ca_search_forms_x_user_groups.form_id = ca_search_forms.form_id", "ca_search_forms_x_user_groups.group_id = ca_user_groups.group_id", "ca_search_forms_x_users.form_id = ca_search_forms.form_id", "ca_search_forms_x_users.user_id = ca_users.user_id", "ca_bundle_displays.display_id = ca_bundle_display_labels.display_id", "ca_bundle_displays.display_id = ca_bundle_displays_x_user_groups.display_id", "ca_user_groups.group_id = ca_bundle_displays_x_user_groups.group_id", "ca_bundle_displays.display_id = ca_bundle_displays_x_users.display_id", "ca_users.user_id = ca_bundle_displays_x_users.user_id", "ca_bundle_display_labels.locale_id = ca_locales.locale_id", "ca_bundle_displays.user_id = ca_users.user_id", "ca_bundle_displays.display_id = ca_bundle_display_placements.display_id", "ca_bundle_mappings.mapping_id = ca_bundle_mapping_labels.mapping_id", "ca_bundle_mappings.mapping_id = ca_bundle_mapping_groups.mapping_id", "ca_bundle_mapping_groups.group_id = ca_bundle_mapping_rules.group_id", "ca_bundle_mapping_groups.group_id = ca_bundle_mapping_group_labels.group_id", "ca_bundle_mapping_labels.locale_id = ca_locales.locale_id", "ca_bundle_mapping_group_labels.locale_id = ca_locales.locale_id", "ca_loan_labels.locale_id = ca_locales.locale_id 1000", "ca_loan_labels.type_id = ca_list_items.item_id 500", "ca_loan_labels.loan_id = ca_loans.loan_id", "ca_loans.locale_id = ca_locales.locale_id 1000", "ca_loans.type_id = ca_list_items.item_id 500", "ca_loans_x_objects.object_id = ca_objects.object_id", "ca_loans_x_objects.loan_id = ca_loans.loan_id", "ca_loans_x_objects.type_id = ca_relationship_types.type_id", "ca_loans_x_entities.entity_id = ca_entities.entity_id", "ca_loans_x_entities.loan_id = ca_loans.loan_id", "ca_loans_x_entities.type_id = ca_relationship_types.type_id", "ca_loans_x_movements.movement_id = ca_movements.movement_id", "ca_loans_x_movements.loan_id = ca_loans.loan_id", "ca_loans_x_movements.type_id = ca_relationship_types.type_id", "ca_movement_labels.locale_id = ca_locales.locale_id 1000", "ca_movement_labels.type_id = ca_list_items.item_id 500", "ca_movement_labels.movement_id = ca_movements.movement_id", "ca_movements.locale_id = ca_locales.locale_id 1000", "ca_movements.type_id = ca_list_items.item_id 500", "ca_movements_x_objects.object_id = ca_objects.object_id", "ca_movements_x_objects.movement_id = ca_movements.movement_id", "ca_movements_x_objects.type_id = ca_relationship_types.type_id", "ca_movements_x_object_lots.lot_id = ca_object_lots.lot_id", "ca_movements_x_object_lots.movement_id = ca_movements.movement_id", "ca_movements_x_object_lots.type_id = ca_relationship_types.type_id", "ca_movements_x_entities.entity_id = ca_entities.entity_id", "ca_movements_x_entities.movement_id = ca_movements.movement_id", "ca_movements_x_entities.type_id = ca_relationship_types.type_id", "ca_movements_x_collections.collection_id = ca_collections.collection_id", "ca_movements_x_collections.movement_id = ca_movements.movement_id", "ca_movements_x_collections.type_id = ca_relationship_types.type_id", "ca_movements_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_movements_x_occurrences.movement_id = ca_movements.movement_id", "ca_movements_x_occurrences.type_id = ca_relationship_types.type_id", "ca_movements_x_places.place_id = ca_places.place_id", "ca_movements_x_places.movement_id = ca_movements.movement_id", "ca_movements_x_places.type_id = ca_relationship_types.type_id", "ca_movements_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_movements_x_storage_locations.movement_id = ca_movements.movement_id", "ca_movements_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_movements_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_movements_x_vocabulary_terms.movement_id = ca_movements.movement_id", "ca_movements_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_movements_x_movements.movement_left_id = ca_movements.movement_id", "ca_movements_x_movements.movement_right_id = ca_movements.movement_id", "ca_movements_x_movements.type_id = ca_relationship_types.type_id", "ca_loans_x_collections.collection_id = ca_collections.collection_id", "ca_loans_x_collections.loan_id = ca_loans.loan_id", "ca_loans_x_collections.type_id = ca_relationship_types.type_id", "ca_loans_x_object_lots.lot_id = ca_object_lots.lot_id", "ca_loans_x_object_lots.loan_id = ca_loans.loan_id", "ca_loans_x_object_lots.type_id = ca_relationship_types.type_id", "ca_loans_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_loans_x_occurrences.loan_id = ca_loans.loan_id", "ca_loans_x_occurrences.type_id = ca_relationship_types.type_id", "ca_loans_x_places.place_id = ca_places.place_id", "ca_loans_x_places.loan_id = ca_loans.loan_id", "ca_loans_x_places.type_id = ca_relationship_types.type_id", "ca_loans_x_storage_locations.location_id = ca_storage_locations.location_id", "ca_loans_x_storage_locations.loan_id = ca_loans.loan_id", "ca_loans_x_storage_locations.type_id = ca_relationship_types.type_id", "ca_loans_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_loans_x_vocabulary_terms.loan_id = ca_loans.loan_id", "ca_loans_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_loans_x_loans.loan_left_id = ca_loans.loan_id", "ca_loans_x_loans.loan_right_id = ca_loans.loan_id", "ca_loans_x_loans.type_id = ca_relationship_types.type_id", "ca_tour_labels.locale_id = ca_locales.locale_id 1000", "ca_tour_labels.tour_id = ca_tours.tour_id", "ca_tours.user_id = ca_users.user_id", "ca_tours.type_id = ca_list_items.item_id 500", "ca_tour_stop_labels.locale_id = ca_locales.locale_id 1000", "ca_tour_stop_labels.stop_id = ca_tour_stops.stop_id", "ca_tour_stops.tour_id = ca_tours.tour_id", "ca_tour_stops.type_id = ca_list_items.item_id 500", "ca_tour_stops_x_objects.object_id = ca_objects.object_id", "ca_tour_stops_x_objects.stop_id = ca_tour_stops.stop_id", "ca_tour_stops_x_objects.type_id = ca_relationship_types.type_id", "ca_tour_stops_x_entities.entity_id = ca_entities.entity_id", "ca_tour_stops_x_entities.stop_id = ca_tour_stops.stop_id", "ca_tour_stops_x_entities.type_id = ca_relationship_types.type_id", "ca_tour_stops_x_places.place_id = ca_places.place_id", "ca_tour_stops_x_places.stop_id = ca_tour_stops.stop_id", "ca_tour_stops_x_places.type_id = ca_relationship_types.type_id", "ca_tour_stops_x_occurrences.occurrence_id = ca_occurrences.occurrence_id", "ca_tour_stops_x_occurrences.stop_id = ca_tour_stops.stop_id", "ca_tour_stops_x_occurrences.type_id = ca_relationship_types.type_id", "ca_tour_stops_x_collections.collection_id = ca_collections.collection_id", "ca_tour_stops_x_collections.stop_id = ca_tour_stops.stop_id", "ca_tour_stops_x_collections.type_id = ca_relationship_types.type_id", "ca_tour_stops_x_vocabulary_terms.item_id = ca_list_items.item_id", "ca_tour_stops_x_vocabulary_terms.stop_id = ca_tour_stops.stop_id", "ca_tour_stops_x_vocabulary_terms.type_id = ca_relationship_types.type_id", "ca_tour_stops_x_tour_stops.stop_left_id = ca_tour_stops.stop_id", "ca_tour_stops_x_tour_stops.stop_right_id = ca_tour_stops.stop_id", "ca_tour_stops_x_tour_stops.type_id = ca_relationship_types.type_id", "ca_watch_list.user_id = ca_users.user_id", "ca_user_notes.user_id = ca_users.user_id", "ca_bookmark_folders.user_id = ca_users.user_id", "ca_bookmark_folders.folder_id = ca_bookmarks.folder_id", "ca_commerce_transactions.user_id = ca_users.user_id", "ca_commerce_communications.transaction_id = ca_commerce_transactions.transaction_id", "ca_commerce_communications.set_id = ca_sets.set_id", "ca_commerce_orders.transaction_id = ca_commerce_transactions.transaction_id", "ca_commerce_order_items.order_id = ca_commerce_orders.order_id", "ca_commerce_order_items.object_id = ca_objects.object_id", "ca_commerce_fulfillment_events.order_id = ca_commerce_orders.order_id", "ca_commerce_fulfillment_events.item_id = ca_commerce_order_items.item_id" ]