/
HD Data model details
HD Data model details
- Allison Powers
Owned by Allison Powers
Jun 16, 2021
Analytics
Loading data...
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 |
, multiple selections available,