Database diagram - rubyforgood/casa Wiki

Table of Contents generated with DocToc

This was generated on 18 December 2021 and it will be out of date as soon as the next db migration is written. You can generate another one at dbdiagram.io by pasting db/schema.rb into the site

1/2

1/2 DB Diagram

2/2

right click and open image in new tab for a higher resolution 2/2 DB Diagram

This image was restyled from https://dbdiagram.io

https://app.quickdatabasediagrams.com/#/ WIP

# Modify this code to update the DB schema diagram.
# To reset the sample schema, replace everything with
# two dots ('..' - without quotes).
#################
# Examples I'm not yet willing to delete
#################
# Table documentation comment 1 (try the PDF/RTF export)
#Product as p # Table documentation comment 2
#------------
#ProductID PK int
# Field documentation comment 1
# Field documentation comment 2 
#Name varchar(200) UNIQUE
#Price money

#OrderStatus as os
#----
#OrderStatusID PK int
#Name UNIQUE string

casa_cases
-
id PK bigint
case_number string 
transition_aged_youth boolean
created_at datetime
updated_at datetime
casa_org_id bigint
birth_month_year_youth datetime NULL
court_date datetime
court_report_due_date datetime
hearing_type_id bigint
active boolean
judge_id bigint
court_report_submitted_at datetime
court_report_status integer
slug string
date_in_care datetime

casa_cases_emancipation_options
-
id PK int
casa_case_id int FK >- casa_cases.id
emancipation_option_id bigint FK >- emancipation_options.id

emancipation_options
-
id PK bigint
emancipation_category_id bigint 
name UNIQUE string
created_at datetime
updated_at datetime

active_storage_attachments
-
name string
record_type string
record_id bigint
blob_id bigint
created_at datetime

active_storage_blobs
-
key string
filename string
content_type string
metadata text
byte_size bigint
checksum string
created_at datetime
service_name string

active_storage_variant_records
-
blob_id bigint
variation_digest string

additional_expenses
-
case_contact_id bigint
other_expense_amount decimal
other_expenses_describe string
created_at datetime
updated_at datetime

addresses
-
content string
user_id bigint
created_at datetime
updated_at datetime

all_casa_admins
-
email string
encrypted_password string
reset_password_token string
reset_password_sent_at datetime
created_at datetime
updated_at datetime
invitation_token string
invitation_created_at datetime
invitation_sent_at datetime
invitation_accepted_at datetime
invitation_limit integer
invited_by_id integer
invited_by_type string

casa_case_contact_types
-
contact_type_id bigint
casa_case_id bigint
created_at datetime
updated_at datetime

casa_case_emancipation_categories
-
casa_case_id bigint
emancipation_category_id bigint
created_at datetime
updated_at datetime

casa_orgs
-
name string
created_at datetime
updated_at datetime
display_name string
address string
footer_links string
slug string
show_driving_reimbursement boolean
show_fund_request boolean
twilio_phone_number string
twilio_account_sid string
twilio_api_key_sid string
twilio_api_key_secret string

case_assignments
-
casa_case_id bigint
volunteer_id bigint
active boolean
created_at datetime
updated_at datetime
hide_old_contacts boolean

case_contact_contact_types
-
case_contact_id bigint
contact_type_id bigint
created_at datetime
updated_at datetime

case_contacts
-
creator_id bigint
casa_case_id bigint
duration_minutes integer
occurred_at datetime
created_at datetime
updated_at datetime
contact_made boolean
medium_type string
miles_driven integer
want_driving_reimbursement boolean
notes string
deleted_at datetime
reimbursement_complete boolean

case_court_orders
-
casa_case_id bigint
created_at datetime
updated_at datetime
implementation_status integer
court_date_id bigint
text string

checklist_items
-
hearing_type_id integer
description text
category string
mandatory boolean
created_at datetime
updated_at datetime

contact_type_groups
-
casa_org_id bigint
name string
created_at datetime
updated_at datetime
active boolean

contact_types
-
contact_type_group_id bigint
name string
created_at datetime
updated_at datetime
active boolean

court_dates
-
date datetime
casa_case_id bigint
created_at datetime
updated_at datetime
hearing_type_id bigint
judge_id bigint

delayed_jobs
-
priority integer
attempts integer
handler text
last_error text
run_at datetime
locked_at datetime
failed_at datetime
locked_by string
queue string
created_at datetime
updated_at datetime

emancipation_categories
-
name string
mutually_exclusive boolean
created_at datetime
updated_at datetime

feature_flags
-
name string
enabled boolean
created_at datetime
updated_at datetime

followups
-
case_contact_id bigint
creator_id bigint
status integer
created_at datetime
updated_at datetime
note text

fund_requests
-
submitter_email text
youth_name text
payment_amount text
deadline text
request_purpose text
payee_name text
requested_by_and_relationship text
other_funding_source_sought text
impact text
extra_information text
timestamps text

healths
-
latest_deploy_time datetime
singleton_guard integer
created_at datetime
updated_at datetime

hearing_types
-
casa_org_id bigint
name string
active boolean
checklist_updated_date string

judges
-
casa_org_id bigint
created_at datetime
updated_at datetime
active boolean
name string

languages
-
name string
casa_org_id bigint
created_at datetime
updated_at datetime

languages_users
-
language_id bigint
user_id bigint

learning_hours
-
user_id bigint
learning_type integer
name string
duration_minutes integer
duration_hours integer
occurred_at datetime
created_at datetime
updated_at datetime

mileage_rates
-
amount decimal
effective_date date
is_active boolean
user_id bigint
created_at datetime
updated_at datetime
casa_org_id bigint

notes
-
content string
creator_id bigint
notable_type string
notable_id bigint
created_at datetime
updated_at datetime

notifications
-
recipient_type string
recipient_id bigint
type string
params jsonb
read_at datetime
created_at datetime
updated_at datetime

other_duties
-
creator_id bigint
creator_type string
occurred_at datetime
duration_minutes bigint
notes text
created_at datetime
updated_at datetime

patch_note_groups
-
value string
created_at datetime
updated_at datetime

patch_note_types
-
name string
created_at datetime
updated_at datetime

patch_notes
-
note text
patch_note_type_id bigint
patch_note_group_id bigint
created_at datetime
updated_at datetime

preference_sets
-
user_id bigint
case_volunteer_columns jsonb
created_at datetime
updated_at datetime

sent_emails
-
user_id bigint
casa_org_id bigint
mailer_type string
category string
sent_address string
created_at datetime
updated_at datetime

sms_notification_events
-
name string
user_type string
created_at datetime
updated_at datetime

supervisor_volunteers
-
supervisor_id bigint
volunteer_id bigint
created_at datetime
updated_at datetime
is_active boolean

task_records
-
version string

user_reminder_times
-
user_id bigint
reminder_sent datetime
created_at datetime
updated_at datetime
case_contact_types datetime

user_sms_notification_events
-
user_id bigint
sms_notification_event_id bigint
created_at datetime
updated_at datetime

users
-
email string
encrypted_password string
reset_password_token string
reset_password_sent_at datetime
created_at datetime
updated_at datetime
casa_org_id bigint
display_name string
invitation_token string
invitation_created_at datetime
invitation_sent_at datetime
invitation_accepted_at datetime
invitation_limit integer
invited_by_type string
invited_by_id bigint
invitations_count integer
type string
active boolean
sign_in_count integer
current_sign_in_at datetime
last_sign_in_at datetime
current_sign_in_ip string
last_sign_in_ip string
phone_number string
receive_sms_notifications boolean
receive_email_notifications boolean