Project: Okul Database · Hub: Okul Database — Reference
Reference: sectors Table
Used in schools.sector_id and school_filters.sector_id.
Values
| id | name | slug | Description |
|---|---|---|---|
| 1 | Devlet | devlet | Public / state-funded schools |
| 2 | Özel | ozel | Private schools |
Usage in Queries
-- Always join or filter like this:
WHERE sector_id = 2 -- Private schools only
WHERE sector_id = 1 -- Public schools only
-- If you need the name without joining:
-- school_filters.sector_name already contains it (denormalized)Related
- ref-school-types — school_type_id values
- table-school-filters — sector_id + sector_name (denormalized)
- table-schools — schools.sector_id FK