catalogue   metadata   harmonization

foreign key (declared, ON DELETE CASCADE)

logical join on study_id — subsystem federation, no constraint

derivation — log promote / project → served (not an FK)

PK · FK · header chip = lifecycle band · drag headers · drag bg to pan · scroll to zoom