class NotifyLogEntry

Schema Information

Table name: notify_log_entries

id              :bigint           not null, primary key
body            :text
delivery_status :integer          default("sending"), not null
purpose         :integer          not null
recipient       :string           not null
subject         :text
type            :integer          not null
created_at      :datetime         not null
consent_form_id :bigint
delivery_id     :uuid
parent_id       :bigint
patient_id      :bigint
sent_by_user_id :bigint
template_id     :uuid             not null

Indexes

index_notify_log_entries_on_consent_form_id  (consent_form_id)
index_notify_log_entries_on_delivery_id      (delivery_id)
index_notify_log_entries_on_parent_id        (parent_id)
index_notify_log_entries_on_patient_id       (patient_id)
index_notify_log_entries_on_sent_by_user_id  (sent_by_user_id)

Foreign Keys

fk_rails_...  (consent_form_id => consent_forms.id)
fk_rails_...  (parent_id => parents.id) ON DELETE => nullify
fk_rails_...  (patient_id => patients.id) ON DELETE => cascade
fk_rails_...  (sent_by_user_id => users.id)