Content Comparison

-- Get study event names (Visit names)
SELECT study_event.name FROM study_event
    INNER JOIN study ON study.study_meta_data_id = study_event.study_meta_data_id
  WHERE study.id = <study id>
  
-- Get EcochEpoch and cohort names  
SELECT epoch.name AS epochName, cohort.name AS cohortName FROM cohort
    INNER JOIN epoch ON epoch.id = cohort.epoch_id
  WHERE epoch.study_id = <study id>
    
 -- Get study information    
 SELECT study.name, study.protocol_name, org.time_zone_id AS orgTz, study_site.location_oid, site.time_zone_id AS siteTz FROM study
      INNER JOIN org ON org.id = study.org_id
      LEFT JOIN study_site ON study_site.study_id = study.id
      INNER JOIN site ON site.id = study_site.site_id
    WHERE study.id <study id>
  
 -- Get measurements   
 SELECT measurement_unit.symbol FROM measurement_unit
        INNER JOIN study ON study.study_meta_data_id = measurement_unit.study_meta_data_id
      WHERE study.id = <study id>