API Documentation

Auto-generated from your schema. View as JSON

Authentication

Web: Cookie-based sessions (automatic via login form)

API/Native: POST /api/_auth/token with {"email", "password"} → returns {"token"}

Usage: Authorization: Bearer {token}

observation_checklist

FieldTypeNotes
idINTEGERprimary key, auto-increment
observation_idINTEGER
item_labelTEXTrequired
is_checkedINTEGERdefault: 0
timestamp_secondsINTEGER
noteTEXT
user_idINTEGER
created_atDATETIMEdefault: CURRENT_TIMESTAMP
updated_atDATETIMEdefault: CURRENT_TIMESTAMP
GET/api/observation_checklist— List all
GET/api/observation_checklist/{id}— Get one
POST/api/observation_checklist— Create
PATCH/api/observation_checklist/{id}— Update
DELETE/api/observation_checklist/{id}— Delete

observation_notes

FieldTypeNotes
idINTEGERprimary key, auto-increment
observation_idINTEGER
contentTEXTrequired
timestamp_secondsINTEGER
user_idINTEGER
created_atDATETIMEdefault: CURRENT_TIMESTAMP
updated_atDATETIMEdefault: CURRENT_TIMESTAMP
GET/api/observation_notes— List all
GET/api/observation_notes/{id}— Get one
POST/api/observation_notes— Create
PATCH/api/observation_notes/{id}— Update
DELETE/api/observation_notes/{id}— Delete

observation_scores

FieldTypeNotes
idINTEGERprimary key, auto-increment
observation_idINTEGER
domainTEXTrequired
scoreREALdefault: 0
evidenceTEXT
ai_suggestionTEXT
user_idINTEGER
created_atDATETIMEdefault: CURRENT_TIMESTAMP
updated_atDATETIMEdefault: CURRENT_TIMESTAMP
GET/api/observation_scores— List all
GET/api/observation_scores/{id}— Get one
POST/api/observation_scores— Create
PATCH/api/observation_scores/{id}— Update
DELETE/api/observation_scores/{id}— Delete

observations

FieldTypeNotes
idINTEGERprimary key, auto-increment
teacher_nameTEXTrequired
teacher_emailTEXT
schoolTEXT
subjectTEXT
grade_levelTEXT
scheduled_atDATETIME
started_atDATETIME
ended_atDATETIME
statusTEXTdefault: 'scheduled'
daily_room_nameTEXT
daily_room_urlTEXT
recording_urlTEXT
transcriptTEXT
ai_summaryTEXT
ai_evaluationTEXT
notesTEXT
user_idINTEGER
created_atDATETIMEdefault: CURRENT_TIMESTAMP
updated_atDATETIMEdefault: CURRENT_TIMESTAMP
deleted_atDATETIME
GET/api/observations— List all
GET/api/observations/{id}— Get one
POST/api/observations— Create
PATCH/api/observations/{id}— Update
DELETE/api/observations/{id}— Delete

rubric_domains

FieldTypeNotes
idINTEGERprimary key, auto-increment
nameTEXTrequired
descriptionTEXT
sort_orderINTEGERdefault: 0
user_idINTEGER
created_atDATETIMEdefault: CURRENT_TIMESTAMP
updated_atDATETIMEdefault: CURRENT_TIMESTAMP
GET/api/rubric_domains— List all
GET/api/rubric_domains/{id}— Get one
POST/api/rubric_domains— Create
PATCH/api/rubric_domains/{id}— Update
DELETE/api/rubric_domains/{id}— Delete

rubric_items

FieldTypeNotes
idINTEGERprimary key, auto-increment
domain_idINTEGER
labelTEXTrequired
descriptionTEXT
sort_orderINTEGERdefault: 0
user_idINTEGER
created_atDATETIMEdefault: CURRENT_TIMESTAMP
updated_atDATETIMEdefault: CURRENT_TIMESTAMP
GET/api/rubric_items— List all
GET/api/rubric_items/{id}— Get one
POST/api/rubric_items— Create
PATCH/api/rubric_items/{id}— Update
DELETE/api/rubric_items/{id}— Delete