Auto-generated from your schema. View as JSON
Web: Cookie-based sessions (automatic via login form)
API/Native: POST /api/_auth/token with {"email", "password"} → returns {"token"}
Usage: Authorization: Bearer {token}
| Field | Type | Notes |
|---|---|---|
| id | INTEGER | primary key, auto-increment |
| observation_id | INTEGER | |
| item_label | TEXT | required |
| is_checked | INTEGER | default: 0 |
| timestamp_seconds | INTEGER | |
| note | TEXT | |
| user_id | INTEGER | |
| created_at | DATETIME | default: CURRENT_TIMESTAMP |
| updated_at | DATETIME | default: CURRENT_TIMESTAMP |
| Field | Type | Notes |
|---|---|---|
| id | INTEGER | primary key, auto-increment |
| observation_id | INTEGER | |
| content | TEXT | required |
| timestamp_seconds | INTEGER | |
| user_id | INTEGER | |
| created_at | DATETIME | default: CURRENT_TIMESTAMP |
| updated_at | DATETIME | default: CURRENT_TIMESTAMP |
| Field | Type | Notes |
|---|---|---|
| id | INTEGER | primary key, auto-increment |
| observation_id | INTEGER | |
| domain | TEXT | required |
| score | REAL | default: 0 |
| evidence | TEXT | |
| ai_suggestion | TEXT | |
| user_id | INTEGER | |
| created_at | DATETIME | default: CURRENT_TIMESTAMP |
| updated_at | DATETIME | default: CURRENT_TIMESTAMP |
| Field | Type | Notes |
|---|---|---|
| id | INTEGER | primary key, auto-increment |
| teacher_name | TEXT | required |
| teacher_email | TEXT | |
| school | TEXT | |
| subject | TEXT | |
| grade_level | TEXT | |
| scheduled_at | DATETIME | |
| started_at | DATETIME | |
| ended_at | DATETIME | |
| status | TEXT | default: 'scheduled' |
| daily_room_name | TEXT | |
| daily_room_url | TEXT | |
| recording_url | TEXT | |
| transcript | TEXT | |
| ai_summary | TEXT | |
| ai_evaluation | TEXT | |
| notes | TEXT | |
| user_id | INTEGER | |
| created_at | DATETIME | default: CURRENT_TIMESTAMP |
| updated_at | DATETIME | default: CURRENT_TIMESTAMP |
| deleted_at | DATETIME |
| Field | Type | Notes |
|---|---|---|
| id | INTEGER | primary key, auto-increment |
| name | TEXT | required |
| description | TEXT | |
| sort_order | INTEGER | default: 0 |
| user_id | INTEGER | |
| created_at | DATETIME | default: CURRENT_TIMESTAMP |
| updated_at | DATETIME | default: CURRENT_TIMESTAMP |
| Field | Type | Notes |
|---|---|---|
| id | INTEGER | primary key, auto-increment |
| domain_id | INTEGER | |
| label | TEXT | required |
| description | TEXT | |
| sort_order | INTEGER | default: 0 |
| user_id | INTEGER | |
| created_at | DATETIME | default: CURRENT_TIMESTAMP |
| updated_at | DATETIME | default: CURRENT_TIMESTAMP |