...
| Column | Type | Notes |
|---|---|---|
| id | uuid | Self-explanatory |
| person_id | uuid | Pointer to the person to whom the plan applies (as opposed to the author). Formal FK to |
| owner_id | uuid | Pointer to the person who is ultimately responsible for all edits to this plan. Formal FK to person.id. Immutable. A change in ownership should result in a copy of the plan, i.e. the equivalent of a "Save As..." operation. We are avoiding use of the audit fields for tracking this for at least two reasons... we want to refactor that implementation at the Java level (SSP-479) and API usage by automated systems potentially muddies the semantics of audit fields. |
| name | varchar | User-supplied moniker for the plan. Except for the "Is Active" checkbox, everything else spec'd in the /wiki/spaces/SSP/pages/103986449 is deferred. |
| object_status | int | a |
| {audit-fields} | -- | Standard SSP edit audit fields. created_by must equal modified_by. I.e. if a plan is edited by a non-originating user, that is a "Save As..." actionDo not use these for business rules related to ownership/authorship changes. |
map_plan_course - Plays detail to map_plan_course's detail.
...