socorro product_versions schema

gistfile1.txt

# Pastebin 61oIMnsy
breakpad=> \d product_versions
                                   Table "public.product_versions"
       Column       |      Type       |                          Modifiers
--------------------+-----------------+--------------------------------------------------------------
 product_version_id | integer         | not null default nextval('product_version_id_seq'::regclass)
 product_name       | citext          | not null
 major_version      | major_version   | not null
 release_version    | citext          | not null
 version_string     | citext          | not null
 beta_number        | integer         |
 version_sort       | text            | not null default 0
 build_date         | date            | not null
 sunset_date        | date            | not null
 featured_version   | boolean         | not null default false
 build_type         | citext          | not null default 'release'::citext
 has_builds         | boolean         | default false
 is_rapid_beta      | boolean         | default false
 rapid_beta_id      | integer         |
 build_type_enum    | build_type_enum |
 version_build      | text            |
Indexes:
    "product_versions_pkey" PRIMARY KEY, btree (product_version_id)
    "product_version_unique_beta" UNIQUE, btree (product_name, release_version, beta_number) WHERE beta_number IS NOT NULL
    "product_version_version_key" UNIQUE CONSTRAINT, btree (product_name, version_string)
    "product_versions_major_version" btree (major_version)
    "product_versions_product_name" btree (product_name)
    "product_versions_version_sort" btree (version_sort)
Foreign-key constraints:
    "product_versions_product_name_fkey" FOREIGN KEY (product_name) REFERENCES products(product_name)
    "product_versions_rapid_beta_id_fkey" FOREIGN KEY (rapid_beta_id) REFERENCES product_versions(product_version_id)
Referenced by:
    TABLE "product_version_builds" CONSTRAINT "product_version_builds_product_version_id_fkey" FOREIGN KEY (product_version_id) REFERENCES product_versions(product_version_id) ON DELETE CASCADE
    TABLE "product_versions" CONSTRAINT "product_versions_rapid_beta_id_fkey" FOREIGN KEY (rapid_beta_id) REFERENCES product_versions(product_version_id)