Project: Okul Database · Hub: Okul Database — Reference

Okul Database — Reference

All lookup/enum data needed to decode IDs in the main tables.

Reference Notes

ref-sectors — sectors table: Devlet (1) / Özel (2)
ref-school-types — schools_types: Anaokulu/İlkokul/Ortaokul/Lise (1-4)
ref-lead-stages — Pipedrive stage_id, approved_status_id, lead_pool_form_status
ref-interaction-values — school_answered_deal_status, deal_cause_of_reason, interaction reason/result/type
ref-payment-statuses — payments.status, agreement_type, checkout.status
ref-media-roles — media_types and media_roles polymorphic mapping
ref-services-facilities — services, facilities, activities, shifts, learning_languages, fee_types
ref-roles-permissions — system roles, permissions, customer_user titles/roles
ref-configs — configs table structure and all type namespaces
ref-locations — Turkish province/district hierarchy
ref-badges — school badge types (most-commented, most-contacted, most-viewed)