/
datamodel.conf
663 lines (636 loc) · 36.6 KB
/
datamodel.conf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
# 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 "<table1>.<field1> = <table2>.<field2>". 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,
"ca_commerce_communications_read_log" = 195,
"ca_commerce_order_items_x_object_representations" = 196,
"ca_editor_ui_bundle_placement_type_restrictions" = 197,
"ca_editor_ui_type_restrictions" = 198,
"ca_object_lots_x_object_representations" = 199,
"ca_loans_x_object_representations" = 200,
"ca_movements_x_object_representations" = 201,
}
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.place_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_users.entity_id = ca_entities.entity_id 1050",
"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_object_representations.representation_id = ca_object_representations.representation_id",
"ca_object_lots_x_object_representations.type_id = ca_relationship_types.type_id",
"ca_object_lots_x_object_representations.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.representation_id",
"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_editor_ui_type_restrictions.ui_id = ca_editor_uis.ui_id",
"ca_editor_ui_type_restrictions.type_id = ca_list_items.item_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.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.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_movements_x_object_representations.representation_id = ca_object_representations.representation_id",
"ca_movements_x_object_representations.movement_id = ca_movements.movement_id",
"ca_movements_x_object_representations.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_loans_x_object_representations.representation_id = ca_object_representations.representation_id",
"ca_loans_x_object_representations.loan_id = ca_loans.loan_id",
"ca_loans_x_object_representations.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_transactions.set_id = ca_sets.set_id",
"ca_commerce_communications.from_user_id = ca_users.user_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_order_items.item_id = ca_commerce_order_items_x_object_representations.item_id",
"ca_commerce_order_items_x_object_representations.representation_id = ca_object_representations.representation_id",
"ca_commerce_fulfillment_events.order_id = ca_commerce_orders.order_id",
"ca_commerce_fulfillment_events.item_id = ca_commerce_order_items.item_id",
]