Database structure of Lino CMS¶

This document describes the database structure.

This page is a tested document and the following instructions are used for initialization:

>>> import lino
>>> lino.startup('lino_book.projects.cms1.settings')
>>> from lino.api.doctest import *

>>> from lino.utils.diag import analyzer
>>> print(analyzer.show_db_overview())
... 
30 apps: lino, about, jinja, bootstrap3, publisher, printing, system, react, cms, social_django, users, office, xl, countries, contacts, linod, contenttypes, gfks, topics, pages, uploads, albums, sources, blogs, memo, comments, help, checkdata, staticfiles, sessions.
37 models:
============================== ================================ ========= =======
 Name                           Default table                    #fields   #rows
------------------------------ -------------------------------- --------- -------
 albums.Album                   albums.Albums                    5         12
 blogs.Entry                    blogs.Entries                    13        5
 blogs.EntryType                blogs.EntryTypes                 6         0
 checkdata.Message              checkdata.Messages               6         0
 comments.Comment               comments.Comments                12        108
 comments.CommentType           comments.CommentTypes            4         0
 comments.Reaction              comments.Reactions               6         0
 contacts.Company               contacts.Companies               22        12
 contacts.CompanyType           contacts.CompanyTypes            7         16
 contacts.Partner               contacts.Partners                20        81
 contacts.Person                contacts.Persons                 27        69
 contacts.Role                  contacts.Roles                   4         3
 contacts.RoleType              contacts.RoleTypes               5         5
 contenttypes.ContentType       gfks.ContentTypes                3         37
 countries.Country              countries.Countries              6         10
 countries.Place                countries.Places                 9         81
 help.SiteContact               help.SiteContacts                8         3
 linod.SystemTask               linod.SystemTasks                23        2
 memo.Mention                   memo.Mentions                    5         49
 pages.Page                     pages.Pages                      14        73
 sessions.Session               users.Sessions                   3         ...
 social_django.Association      social_django.AssociationTable   7         0
 social_django.Code             social_django.CodeTable          5         0
 social_django.Nonce            social_django.NonceTable         4         0
 social_django.Partial          social_django.PartialTable       6         0
 social_django.UserSocialAuth   users.SocialAuths                7         0
 sources.Author                 sources.Authors                  10        5
 sources.License                sources.Licenses                 4         2
 sources.Source                 sources.Sources                  9         6
 system.SiteConfig              system.SiteConfigs               5         1
 topics.Interest                topics.Interests                 6         0
 topics.Topic                   topics.Topics                    8         0
 uploads.Upload                 uploads.Uploads                  14        18
 uploads.UploadType             uploads.UploadTypes              8         0
 uploads.Volume                 uploads.Volumes                  5         1
 users.Authority                users.Authorities                3         0
 users.User                     users.AllUsers                   22        3
============================== ================================ ========= =======