Data Model and Database - Kosudo/nextSIS GitHub Wiki

General Notes

  • [Scope] (Data-model-scope)
  • [Spelling] (Data-model-spelling)
  • [Normalisation] (Data-model-normalisation)
  • [Composite Primary Keys] (Data-model-composite-primary-keys)
  • [Pluralisation] (Data-model-pluralisation)
  • [Capitalisation and Naming Conventions] (Database-capitalisation-naming-conventions)
  • [x_ Prefixes] (Database-'x_'-prefixes)
  • [Technical Implementation] (Database-technical-implementation)

Tables

These are draft designs and are subject to change.

  • language
  • [person] (Database-table-person)
  • person_course
  • person_gender
  • person_role
  • person_school
  • person_title
  • role
  • [school] (Database-table-school)
  • school_course