...
| Column | Type | Notes |
|---|---|---|
| course_code | varchar | Pointer to external_course.course_code |
| term_code | varchar | Pointer to external_term.term_code |
Phase 1 External Data Model Notes
...
| Column | Type | Notes |
|---|---|---|
| id | uuid | Self-explanatory |
| plan_id | uuid | Pointer to the plan which owns this course-term binding. Formal FK to map_plan.id |
| person_id | uuid | Pointer to the person to whom the plan applies (as opposed to the author). Formal FK to person.id. Must always match map_plan.person_id for a given plan_id. This is a denormalization for performance. |
| term_code | varchar | Pointer to the term in which the course is planned. Informal FK to external_term.term_code. Integrators are strongly encouraged to use term_codes with business meaning, e.g. FA12 not 1234. This seems common enough that taking a copy of the term name/title is not necessary. |
| course_code | varchar | Pointer to the course being planned. Informal FK to external_course.course_code. Recall that this is a potentially opaque value, not something like "MAT101". |
| formatted_course | varchar | Copy of external_course.formatted_course. Should be something like "MAT101". Needed to produce a useful plan export should external data go missing. |
| course_title | varchar | Copy of external_course.title. Needed to produce a useful plan export should external data go missing. |
| course_description | varchar | Copy of external_course.description. Needed to produce a useful plan export should external data go missing. |
| credit_hours | varchar | Copy of external_course.min_credit_hours (per email from Jason). |
| is_dev | bool | Copy of external_course.is_dev. Needed to produce useful plan export should external data go missing. |
| order_in_term | int | Ordinal representing desired on-screen position relative to other map_plan_course records in the same plan and term. Ascending order. |
| {audit-fields} | -- | Standard stuff |
...
| Column | Type | Notes |
|---|---|---|
| id | uuid | Standard |
| plan_id | uuid | Pointer to map_plan.id. Formal FK. Required. |
| term_code | varchar | Pointer to external_term.term_code. Informal FK. Required |
| student_notes | varchar | Collected via UI text field. See /wiki/spaces/SSP/pages/103986445 |
| contact_notes | varchar | Collected via UI text field. See /wiki/spaces/SSP/pages/103986445 |
| is_important | boolean | Collected via UI checkbox. See /wiki/spaces/SSP/pages/103986445 |
| {audit-fields} | -- | Standard |
...