class CareplusReport

Schema Information

Table name: careplus_reports

id              :bigint           not null, primary key
academic_year   :integer          not null
csv_data        :text
csv_filename    :text
csv_removed_at  :datetime
date_from       :date             not null
date_to         :date             not null
programme_types :enum             not null, is an Array
scheduled_at    :datetime         not null
sent_at         :datetime
status          :integer          default("pending"), not null
created_at      :datetime         not null
updated_at      :datetime         not null
team_id         :bigint           not null

Indexes

index_careplus_reports_on_programme_types            (programme_types) USING gin
index_careplus_reports_on_status_and_scheduled_at    (status,scheduled_at)
index_careplus_reports_on_team_id                    (team_id)
index_careplus_reports_on_team_id_and_academic_year  (team_id,academic_year)

Foreign Keys

fk_rails_...  (team_id => teams.id)