class Vaccine

Schema Information

Table name: vaccines

id                  :bigint           not null, primary key
brand               :text             not null
contains_gelatine   :boolean          not null
discontinued        :boolean          default(FALSE), not null
disease_types       :enum             default([]), not null, is an Array
dose_volume_ml      :decimal(, )      not null
manufacturer        :text             not null
method              :integer          not null
nivs_name           :string
programme_type      :enum             not null
side_effects        :integer          default([]), not null, is an Array
snomed_product_code :string           not null
snomed_product_term :string           not null
upload_name         :text             not null
created_at          :datetime         not null
updated_at          :datetime         not null

Indexes

index_vaccines_on_manufacturer_and_brand  (manufacturer,brand) UNIQUE
index_vaccines_on_programme_type          (programme_type)
index_vaccines_on_snomed_product_code     (snomed_product_code) UNIQUE
index_vaccines_on_snomed_product_term     (snomed_product_term) UNIQUE
index_vaccines_on_upload_name             (upload_name) UNIQUE