| id |
Integer |
No description |
| uid |
UUID |
Public identifier used in API routes and URLs. |
| submitter_user_id |
Integer |
The authenticated user who filled in the form. |
| organization_id |
Integer |
The organization on whose behalf the application was submitted. |
| observatory_id |
Integer (Optional) |
Existing observatory the telescope would join; null when the application describes a new site (the common case). |
| status |
Enum(submitted, under_review, accepted, scheduled, provisioning, onboarded, deferred) |
No description |
| payload |
JSONB |
The survey answers, opaque to the schema by design. |
| reviewer_notes |
String(Unbounded) (Optional) |
Staff-only review notes; never returned to submitters. |
| created_on |
DateTime |
No description |
| updated_on |
DateTime |
No description |