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 40
cert.CertSection cert.CertSections 12 8
cert.CertTemplate cert.CertTemplates 4 2
cert.Certificate cert.Certificates 11 672
cert.ElementResponse cert.AllElementResponses 6 5760
cert.SectionResponse cert.AllSectionResponses 9 1344
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 81
projects.ProjectSection projects.ProjectSections 5 4
projects.ProjectTemplate projects.ProjectTemplates 7 5
ratings.Challenge ratings.Challenges 6 347
ratings.ChallengeRating ratings.ChallengeRatings 9 4524
ratings.Exam ratings.Exams 8 110
ratings.ExamResponse ratings.ExamResponses 4 1104
ratings.FinalChallenge ratings.FinalChallenges 5 17
ratings.FinalExam ratings.FinalExams 3 34
ratings.FinalRating ratings.FinalRatings 9 408
ratings.RatingsSummary ratings.RatingsSummaries 7 2735
school.Cast school.Casts 4 84
school.Course school.AllCourses 6 141
school.Enrolment school.Enrolments 5 336
school.Grade school.Grades 7 7
school.Group school.AllGroups 10 28
school.Role school.Roles 3 6
school.Skill school.Skills 6 34
school.Subject school.Subjects 8 12
sessions.Session users.Sessions 3 ...
system.SiteConfig system.SiteConfigs 3 1
uploads.Upload uploads.Uploads 12 18
uploads.UploadType uploads.UploadTypes 7 0
uploads.Volume uploads.Volumes 4 3
users.Authority users.Authorities 3 0
users.User users.AllUsers 20 156
========================== =========================== ========= =======