schema

Jump to bottom

Cole Zemel edited this page May 29, 2020 · 12 revisions

This is the current database schema.

ER Diagram

Note: Whenever you run docker-compose exec api rake db:migrate this diagram generates as backend/docs/erd.svg.

Question: is the Schema Information in the models auto-generated? E.g. should Position have an instructor_id?

Minimal set of API calls to be able to create an Assignment

Create Session
Create Position
Create Applicant
Create Assignment

Notes:

We don't need Application, PositionDataForAd, PositionDataForMatching,
Instructor could be empty/nil for Position
If ContractTemplate can be nil in Position, then we don't need to create it