Page History

...

• alma_ous
  • metadata:
    
    • name           – uid
    • type             – MOUS, GOUS, SOUS
    • project_code (nullable, if we have a parent_ous_id)
    • NOTE: calibration status handled by non-null link below:
  • structure:
    • alma_ous_id    (Primary Key, sequence generated)
    • parent_ous_id (nullable, if we have a project code)calibration_id   (nullable, foreign key link to calibration table entry, if it's been released)

Note that we don't carry any calibration status information in this structure.  That can be found by querying the calibrations table.  For functionality sake, we should build a view in order to simplify indexing. 

(Move this to a new page) Product Structure Generalization:

...