Database structure of Lino Prima¶
This document describes the database structure.
A tested document¶
This is a tested document. The following instructions are used for initialization:
>>> import lino
>>> lino.startup('lino_prima.projects.prima1.settings')
>>> from lino.api.doctest import *
>>> from lino.utils.diag import analyzer
>>> analyzer.show_db_overview()
...
27 plugins: lino, printing, system, users, prima, periods, school, projects, ratings, cert, uploads, contenttypes, gfks, office, linod, checkdata, summaries, jinja, bulma, weasyprint, export_excel, memo, help, about, react, staticfiles, sessions.
38 models:
========================== =========================== ========= =======
Name Default table #fields #rows
-------------------------- --------------------------- --------- -------
cert.CertElement cert.CertElements 5 48
cert.CertSection cert.CertSections 13 14
cert.CertTemplate cert.CertTemplates 3 2
cert.Certificate cert.Certificates 11 672
cert.ElementResponse cert.AllElementResponses 6 6912
cert.SectionResponse cert.AllSectionResponses 9 2016
checkdata.Message checkdata.Messages 6 0
contenttypes.ContentType gfks.ContentTypes 3 38
linod.SystemTask linod.SystemTasks 25 2
memo.Mention memo.Mentions 5 0
periods.StoredPeriod periods.StoredPeriods 8 4
periods.StoredYear periods.StoredYears 5 7
projects.Project projects.Projects 17 80
projects.ProjectSection projects.ProjectSections 5 4
projects.ProjectTemplate projects.ProjectTemplates 7 5
ratings.Challenge ratings.Challenges 6 57
ratings.ChallengeRating ratings.ChallengeRatings 9 852
ratings.Exam ratings.Exams 8 30
ratings.ExamResponse ratings.ExamResponses 4 180
ratings.FinalChallenge ratings.FinalChallenges 5 17
ratings.FinalExam ratings.FinalExams 3 34
ratings.FinalRating ratings.FinalRatings 9 408
ratings.RatingsSummary ratings.RatingsSummaries 7 0
school.Cast school.Casts 4 84
school.Course school.AllCourses 6 174
school.Enrolment school.Enrolments 5 336
school.Grade school.Grades 7 7
school.Group school.AllGroups 8 28
school.Role school.Roles 3 6
school.Skill school.Skills 6 24
school.Subject school.Subjects 8 10
sessions.Session users.Sessions 3 ...
system.SiteConfig system.SiteConfigs 3 1
uploads.Upload uploads.Uploads 12 8
uploads.UploadType uploads.UploadTypes 7 0
uploads.Volume uploads.Volumes 4 2
users.Authority users.Authorities 3 0
users.User users.AllUsers 20 156
========================== =========================== ========= =======