Top

Issues

Database Tables

Database Tables

User

Field	Field Type	Special
user_id	Unique ID	Required, autogenerated
first_name	Text	Required
email	Text	Required
email_verified_at	Timestamp
image_url	Text
role	Text	Required, either “staff” or “admin”
last_name	Text	Required

Paras Assigned to Case Managers

Field	Field Type	Special
para_id	Unique ID	Reference to 'user'
case_manager_id	Unique ID	Reference to 'user'

Account

Field	Field Type	Special
account_id	Unique ID	Required, autogenerated
user_id	Unique ID	Reference to “user”
provider_name	Text	Required
provider_account_id	Text	Required, unique combination with provider_name
session_state	Text
scope	Text
token_type	Text
id_token	Text
expires_at	Integer
refresh_token	Text

Session

Field	Field Type	Special
session_token	Text	Required, Unique
session_id	Unique ID	Required, autogenerated
expires_at	Timestamp	Required
user_id	Text	Required, reference to “user”

Student

Field	Field Type	Special
last_name	Text	Required
first_name	Text	Required
student_id	Unique ID	Required, autogenerated
email	Text	Required
assigned_case_manager_id	Timestamp	References “user”
grade	Integer

File

Field	Field Type	Special
file_id	Unique ID	Required, autogenerated
name	Text	Required
created_at	Timestamp	Required, autogenerated
ext_s3_path	Text	Required, either “staff” or “admin”
content_type	Text	Required
uploaded_by_user_id	Text	Required

Iep

Field	Field Type	Special
iep_id	Unique ID	Required, autogenerated
student_id	Unique ID	References “student”
case_manager_id	Unique ID	References “user”
created_at	Timestamp	Required, autogenerated
end_date	Date	Required
start_date	Date	Required

Goal

Field	Field Type	Special
category	Text	Required, either 'writing', 'reading', 'math', or 'other'
description	Text	Required
goal_id	Unique ID	Required, autogenerated
iep_id	Unique ID	References “iep”
created_at	Timestamp	Required, autogenerated

Subgoal

Field	Field Type	Special
instructions	Text	Required
setup	Text	Required
description	Text	Required
subgoal_id	Unique ID	Required, autogenerated
goal_id	Unique ID	References “goal”
materials	Text	Required
status	Text	Either “In Progress” or “Complete”
current_level	Integer	To be calculated as trial data is collected, never input by the user (between 0 and 100)
attempts_per_trial	Integer	How many questions to administer in a single sitting
metric_name	Text	Required
number_of_trials	Integer
created_at	Timestamp	Required, autogenerated
baseline_level	Integer	Required (between 0 and 100)
target_level	Integer	Required (between 0 and 100)

Task

Field	Field Type	Special
assignee_id	Unique ID	References “user”
seen	True/False	Required, default false
subgoal_id	Unique ID	References “subgoal”
due_date	Timestamp
trial_count	Integer
task_id	Unique ID	Required, autogenerated

Trial Data

Field	Field Type	Special
notes	Text
submitted	True/False	Required, default false
unsuccess	Integer	Required
success	Integer	Required
created_by_user_id	Unique ID	References “user”
created_at	Timestamp	Required, autogenerated
task_id	Unique ID	References “task”
trial_data_id	Unique ID	Required, autogenerated

Trial Data File

Field	Field Type	Special
trial_file_id	Unique ID	Required, autogenerated
created_at	Timestamp	Required, autogenerated
file_id	Unique ID	References “file”
trial_data_id	Unique ID	References “trial_data”