Cisco Alma
Alma builds critical SIS tooling that significantly improves school operations and empowers educators to foster better student outcomes.
About
Table | Key | Read | Create | Update | Delete |
|---|---|---|---|---|---|
classes | id |  |  | | |
classes_teachers | id | | | | |
courses | id | | | | |
district | id | | | | |
households | id | | | | |
households_contact_address | id | | | | |
grade_levels | id | | | | |
grading_periods | id | | | | |
parents | id | | | | |
parents_contact_addresses | id | | | | |
parents_contact_phones | id | | | | |
schools | id | | | | |
school_years | id | | | | |
staff | id | | | | |
staff_contact_addresses | id | | | | |
staff_contact_email | id | | | | |
staff_contact_phones | id | | | | |
students | id | | | | |
students_contact_addresses | id | | | | |
students_contact_email | id | | | | |
students_contact_phones | id | | | | |
students_enrollment | id | | | | |
students_programs | id | | | | |
subjects | id | | | | |
user_roles | id | | | | |
Referencing Table | Foreign Key | Parent table | Primary Key |
|---|---|---|---|
classes_teachers | class_id | classes | id |
classes | schoolyearID | school_years | id |
courses | schoolyearID | school_years | id |
grade_levels | schoolyearID | school_years | id |
grading_periods | schoolyearID | school_years | id |
parents_contact_addresses | school_id | schools | id |
parents_contact_email | school_id | schools | id |
parents_contact_phones | school_id | schools | id |
schools | districtID | district | id |
staff | school_id | schools | id |
staff | districtID | district | id |
staff | roleID | user_roles | id |
staff_contact_addresses | school_id | schools | id |
staff_contact_email | school_id | schools | id |
staff_contact_phone | school_id | schools | id |
students | school_id | schools | id |
students | districtID | district | id |
students_contact_addresses | school_id | schools | id |
students_contact_email | school_id | schools | id |
students_contact_phones | school_id | schools | id |
students_enrollment | schoolID | schools | id |
Please refer to vendor documentation