class ImportantNotice

Schema Information

Table name: important_notices

id                       :bigint           not null, primary key
dismissed_at             :datetime
recorded_at              :datetime         not null
type                     :integer          not null
created_at               :datetime         not null
updated_at               :datetime         not null
dismissed_by_user_id     :bigint
patient_id               :bigint           not null
school_move_log_entry_id :bigint
team_id                  :bigint           not null
vaccination_record_id    :bigint

Indexes

index_important_notices_on_dismissed_by_user_id             (dismissed_by_user_id)
index_important_notices_on_patient_id                       (patient_id)
index_important_notices_on_school_move_log_entry_id         (school_move_log_entry_id)
index_important_notices_on_team_id                          (team_id)
index_important_notices_on_vaccination_record_id            (vaccination_record_id)
index_notices_on_patient_and_type_and_recorded_at_and_team  (patient_id,type,recorded_at,team_id) UNIQUE

Foreign Keys

fk_rails_...  (dismissed_by_user_id => users.id)
fk_rails_...  (patient_id => patients.id)
fk_rails_...  (school_move_log_entry_id => school_move_log_entries.id)
fk_rails_...  (team_id => teams.id)
fk_rails_...  (vaccination_record_id => vaccination_records.id)