Domain Glossary
Domain Glossary — Term → Code Map
Section titled “Domain Glossary — Term → Code Map”Business meanings are LOCKED in plans/scope/001-mvp.md §1 (source of truth).
This file maps each domain term to its canonical code identifier so naming
stays consistent. Use these exact identifiers in DB, service, and API code.
| Term (domain / UI) | Code identifier (table / column / enum) |
|---|---|
| Sesi | lesson_sessions table; status = session_status enum |
| Siswa | a users row with user_type = 'SISWA' |
| Tutor | a users row with user_type = 'TUTOR' |
| Tingkat | tingkats table |
| Segmentasi | segmentasis table |
| Kategori | kategoris table (organizational grouping — NOT a pricing axis) |
| Subject | subjects table |
| SubjectLevel | subject_levels table (optional child of a Subject) |
| Golongan | golongans table (tutor tier; GOL_1 highest) |
| Tahun Ajaran | academic_years table (Jul–Jun cycle) |
| Tagihan | student_settlements (monthly student invoice); per-sesi rate = student_pricing_matrix.amount_idr |
| Honorarium | tutor_settlements (tutor payout — siswa NEVER sees); per-sesi rate = tutor_pricing_matrix.amount_idr |
| Jadwal tetap | schedules table (recurring template) |
| Slot | tutor availability window (tutor_slots, iter 2+) |
| mode_surcharge | lesson_sessions.mode_surcharge_idr (per-sesi escape hatch) |
| Billing period | billing_periods table |
Naming conventions tied to the glossary
Section titled “Naming conventions tied to the glossary”- Tables
snake_case, plural. Columnssnake_case. (Seedb-conventions.md.) - Bilingual fields use
_id/_ensuffixes for Indonesian / English:label_id/label_en,name_id/name_en,description_id/description_en. ⚠️_idhere means Indonesian, not a foreign key. FK columns are<entity>_id(e.g.subject_id). Disambiguate by context: a bilingual text pair vs a uuid FK. - Permission keys are 3-segment
<domain>:<entity>:<action>[_self](seeschema.md). - Audit
actionisentity:verb(e.g.subject:create) — distinct from permission keys.
Full business definitions: plans/scope/001-mvp.md §1.