Project: Okul Database · Hub: Okul Database — Reference
Reference: School Feature Lookup Tables
services (School Services)
Used in school_services pivot table. services.school_type_id restricts which school types can have this service.
| id | name |
|---|---|
| 2 | Güvenlik (Security) |
| 3 | Rehberlik (Counseling/Guidance) |
| 5 | Yaz Okulu (Summer School) |
| 6 | Servis (School Bus) |
| 14 | Hafta sonu Eğitim (Weekend Education) |
| 17 | Organik Beslenme (Organic Nutrition) |
| 19 | Oyun Grubu (Play Group) |
| 20 | Anne-Çocuk Oyun Grubu (Parent-Child Play Group) |
| 21 | Dini Eğitim (Religious Education) |
facilities (School Facilities)
Used in school_facilities pivot table.
| id | name | English |
|---|---|---|
| 1 | Uyku Odası | Sleeping room |
| 2 | Yemekhane | Cafeteria |
| 3 | Havuz | Swimming pool |
| 4 | Bilgisayar Laboratuvarı | Computer lab |
| 5 | Kapalı Spor Salonu | Indoor sports hall |
| 6 | Futbol Sahası | Football field |
| 7 | Konferans Salonu | Conference hall |
| 8 | Laboratuvar | Science lab |
| 13 | Sanat Atölyesi | Art studio |
| 14 | Kantin | Canteen |
| 15 | Kütüphane | Library |
| 16 | Müzik Odası | Music room |
| 17 | Oyun Alanı | Playground |
| 18 | Revir | Nurse’s office |
| 19 | Bahçe | Garden |
| 20 | Lojman | Staff housing |
| 21 | Akıllı Tahta | Smart board |
| 22 | Hayvanat Bahçesi | Zoo / animal farm |
| 23 | Sera | Greenhouse |
| 24 | 3D Odası | 3D room |
| 25 | Mutfak Atölyesi | Kitchen workshop |
| 26 | Spor Alanı | Sports field |
| 27 | Kum Havuzu | Sand pool |
activities_types (Activity Types)
| id | type |
|---|---|
| 1 | Sportif & Sanatsal (Sports & Arts) |
| 2 | Savunma Sanatları (Martial Arts) |
| 3 | Kulüpler & Etkinlikler (Clubs & Events) |
learning_languages (Languages of Instruction)
Used in school_learning_languages pivot and high_school_points.learning_language_id.
| id | name |
|---|---|
| 7 | Çince (Chinese) |
| 8 | Fransızca (French) |
| 9 | Almanca (German) |
| 10 | İngilizce (English) |
| 11 | İspanyolca (Spanish) |
| 12 | Arapça (Arabic) |
| 13 | İbranice (Hebrew) |
| 15 | İtalyanca (Italian) |
| 16 | Rusça (Russian) |
| 17 | Ermenice (Armenian) |
| 18 | Japonca (Japanese) |
| 20 | Ukraynaca (Ukrainian) |
| 21 | Türkçe (Turkish) |
shifts (School Shifts)
Used in school_shifts pivot and discounts.shift.
| id | name |
|---|---|
| 1 | Tam Gün (Full day) |
| 2 | Yarım Gün (Half day) |
| 3 | Sabah (Morning) |
| 4 | Öğleden Sonra (Afternoon) |
fee_types (Fee/Tuition Types)
Used in school_fees.fee_type_id.
| id | name |
|---|---|
| 1 | Yıllık Ücret (Annual Fee) |
| 2 | Aylık Ücret (Monthly Fee) |
| 3 | Kayıt Ücreti (Registration Fee) |
| 4 | Servis Ücreti (Bus Fee) |
| 5 | Yemek Ücreti (Meal Fee) |
Related
- domain-schools — Schools domain
- table-school-filters — Aggregated service/facility flags