HD Data model details
Table relationships
Table 1 | Table 2 | Key Field | Join Type |
|---|---|---|---|
HD Item | Alma Items | Barcode | Outer |
Alma Items | Alma Holdings | Holding ID | Outer |
Alma Holdings | Alma Bibs | MMSID | Outer |
HD Item | HD Tray | Tray ID | Inner |
HD Tray | HD Location | Location ID | Inner |
HD Item | HD History Last | Barcode | Inner |
HD History Last | HD History All | Barcode + Sequence | Outer |
HD Item | HD History Last | Barcode | Outer |