Release Set Normalized

release_set_normalized is a view that aggregates release_set with family, family_availability, product, and product_group

 SELECT release_set.id,
    release_set.release_date,
    release_set.family_id,
    family.name AS family_name,
    family_availability.name AS family_availability,
    family.download_page_section_heading,
    family.download_page_order,
    release_set.product_id,
    product.name AS product_name,
    product.trademark_name,
    product.sort_order AS product_sort_order,
    product.binary_folder,
    product.readme_folder,
    product.readme_handle,
    product_group.name AS product_group_name,
    product_group.sort_order AS product_group_sort_order,
    release_set.binary_filename,
    release_set.readme_filename,
    release_set.binary_changed,
    release_set.readme_changed,
    release_set.version
   FROM downloads.release_set
     LEFT JOIN downloads.family ON family.id = release_set.family_id
     LEFT JOIN downloads.family_availability ON family_availability.id = family.availability_id
     LEFT JOIN downloads.product ON product.id = release_set.product_id
     LEFT JOIN downloads.product_group ON product_group.id = product.product_group_id

This normalized view drives the process of creating the product.json file used to list downloads.