Database finalization

[tmaxmax]

There are a few additional features required to finish the database schema:

• [x] Teacher role request table
• [x] Teacher-student association requests table
• [x] name column on bookmarks table
• [x] email column on users_all table
• [x] enum tables:
  • [x] work_type
  • [x] work_status
  • [x] teacher_student_associations_status
  • [x] teacher_request_status
  • [x] user_role

Hasura also requires some configuration:

• [x] Configure Hasura roles

  • [x] Create teacher role
  • [x] Create student role
  • [x] Create anonymous role

  Tables, views, and functions to configure permissions on:

  • [x] authors
  • [x] bookmarks
  • [x] characterizations
  • [x] characters
  • [x] counties
  • [x] essays
  • [x] schools
  • [x] students
  • [x] teacher_requests
  • [x] teacher_student_associations
  • [x] teachers
  • [x] titles
  • [x] users
  • [x] users_all
  • [x] work_summaries
  • [x] works

• [x] Configure Hasura authorization

  • [x] JWT config
  • [x] Test roles with authorization
  • [x] Auth0 login rule
  • [x] Pass X-Hasura-User-Id as a string
  • [x] Development configuration
  • [x] Document setup

Additional files have to be created, also:

• [x] SQL schema creation/migration files
• [x] Hasura configuration files
• [x] SQL metadata insertion queries (work done in eseuri-metadata-preprocess)