class Team

Schema Information

Table name: teams

id                              :bigint           not null, primary key
careplus_namespace              :string
careplus_password               :string
careplus_staff_code             :string
careplus_staff_type             :string
careplus_username               :string
careplus_venue_code             :string
days_before_consent_reminders   :integer          default(7), not null
days_before_consent_requests    :integer          default(21), not null
email                           :string
name                            :text             not null
national_reporting_cut_off_date :date
phone                           :string
phone_instructions              :string
privacy_notice_url              :string
privacy_policy_url              :string
programme_types                 :enum             not null, is an Array
type                            :integer          not null
workgroup                       :string           not null
created_at                      :datetime         not null
updated_at                      :datetime         not null
organisation_id                 :bigint           not null
reply_to_id                     :uuid

Indexes

index_teams_on_name             (name) UNIQUE
index_teams_on_organisation_id  (organisation_id)
index_teams_on_programme_types  (programme_types) USING gin
index_teams_on_workgroup        (workgroup) UNIQUE

Foreign Keys

fk_rails_...  (organisation_id => organisations.id)