Welcome | Get started | Dive into Lino | Contribute | Topics | Reference | More
Lino Noi database structure¶
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.noi1e.settings.demo')
>>> from lino.api.doctest import *
Complexity factors¶
>>> print(analyzer.show_complexity_factors())
...
- 60 plugins
- 111 models
- 5 user types
- 385 views
- 26 dialog actions
Dependencies¶
>>> dd.is_installed('products')
True
>>> dd.plugins.tickets
lino_noi.lib.tickets (extends_models=['Ticket', 'Site'], needs_plugins=['lino_xl.lib.excerpts', 'lino.modlib.comments', 'lino.modlib.changes', 'lino_noi.lib.noi'])
>>> dd.plugins.working
lino_xl.lib.working (needs_plugins=['lino.modlib.summaries', 'lino.modlib.checkdata'])
The database models¶
>>> from lino.utils.diag import analyzer
>>> print(analyzer.show_db_overview())
...
60 apps: lino, about, jinja, bootstrap3, extjs, printing, system, contenttypes, gfks, help, office, xl, countries, contacts, social_django, users, noi, cal, calview, topics, excerpts, memo, comments, changes, tickets, nicknames, summaries, channels, daphne, linod, checkdata, working, lists, notify, uploads, export_excel, tinymce, smtpd, weasyprint, appypod, dashboard, userstats, groups, products, ledger, vat, trading, storage, invoicing, subscriptions, publisher, pages, rest_framework, restful, addresses, phones, google, search, staticfiles, sessions.
111 models:
================================== =================================== ========= =======
Name Default table #fields #rows
---------------------------------- ----------------------------------- --------- -------
addresses.Address addresses.Addresses 16 108
cal.Calendar cal.Calendars 8 1
cal.EntryRepeater cal.EntryRepeaterTable 17 0
cal.Event cal.Events 29 113
cal.EventPolicy cal.EventPolicies 20 6
cal.EventType cal.EventTypes 24 4
cal.Guest cal.Guests 6 0
cal.GuestRole cal.GuestRoles 5 0
cal.RecurrentEvent cal.RecurrentEvents 22 15
cal.RemoteCalendar cal.RemoteCalendars 7 0
cal.Room cal.Rooms 10 0
cal.Subscription cal.Subscriptions 4 0
cal.Task cal.Tasks 16 0
calview.DailyPlannerRow calview.DailyPlannerRows 7 2
changes.Change changes.Changes 10 0
checkdata.Message checkdata.Messages 6 0
comments.Comment comments.Comments 12 336
comments.CommentType comments.CommentTypes 4 0
comments.Reaction comments.Reactions 6 0
contacts.Company contacts.Companies 26 13
contacts.CompanyType contacts.CompanyTypes 7 16
contacts.Partner contacts.Partners 24 82
contacts.Person contacts.Persons 31 69
contacts.Role contacts.Roles 4 8
contacts.RoleType contacts.RoleTypes 5 5
contenttypes.ContentType gfks.ContentTypes 3 111
countries.Country countries.Countries 6 10
countries.Place countries.Places 9 80
dashboard.Widget dashboard.Widgets 5 0
excerpts.Excerpt excerpts.Excerpts 11 3
excerpts.ExcerptType excerpts.ExcerptTypes 17 6
google.CalendarSubscription google.CalendarSubscriptionTable 6 0
google.CalendarSyncToken google.CalendarSyncTokenTable 6 0
google.Contact google.Contacts 5 0
google.ContactSyncToken google.ContactSyncTokenTable 6 0
google.DeletedContact google.DeletedContacts 3 0
google.DeletedEntry google.DeletedEntries 5 0
google.EventSyncToken google.EventSyncTokenTable 7 0
google.FailedForeignItem google.FailedForeignItemTable 4 0
google.SyncSummary google.SyncSummaries 5 0
groups.Group groups.Groups 7 3
groups.Membership groups.Memberships 4 7
invoicing.FollowUpRule invoicing.FollowUpRules 5 4
invoicing.Item invoicing.Items 10 1
invoicing.Plan invoicing.Plans 8 1
invoicing.SalesRule invoicing.SalesRules 3 0
invoicing.Tariff invoicing.Tariffs 8 0
invoicing.Task invoicing.Tasks 27 3
ledger.Account ledger.Accounts 18 20
ledger.AccountingPeriod ledger.AccountingPeriods 7 39
ledger.FiscalYear ledger.FiscalYears 5 9
ledger.Journal ledger.Journals 26 4
ledger.LedgerInfo ledger.LedgerInfoTable 2 0
ledger.MatchRule ledger.MatchRules 3 0
ledger.Movement ledger.Movements 11 136
ledger.PaymentTerm ledger.PaymentTerms 11 8
ledger.Voucher ledger.AllVouchers 8 128
linod.SystemTask linod.SystemTasks 23 9
lists.List lists.Lists 7 8
lists.ListType lists.ListTypes 4 3
lists.Member lists.Members 5 82
memo.Mention memo.Mentions 5 0
nicknames.Naming nicknames.Namings 4 21
notify.Message notify.Messages 11 421
notify.Subscription notify.SubscriptionTable 7 0
pages.Page pages.Pages 14 72
phones.ContactDetail phones.ContactDetails 8 5
products.Category products.Categories 15 0
products.PriceRule products.PriceRules 4 0
products.Product products.Products 22 10
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
storage.Component storage.Components 4 3
storage.DeliveryItem storage.DeliveryItems 8 1264
storage.DeliveryNote storage.DeliveryNotes 14 55
storage.Filler storage.Fillers 6 5
storage.Movement storage.Movements 10 115
storage.Provision storage.Provisions 5 5
storage.TransferRule storage.TransferRules 5 2
subscriptions.Subscription subscriptions.Subscriptions 20 5
subscriptions.SubscriptionItem subscriptions.SubscriptionItems 8 15
subscriptions.SubscriptionPeriod subscriptions.SubscriptionPeriods 5 10
system.SiteConfig system.SiteConfigs 10 1
tickets.CheckListItem tickets.CheckListItems 4 0
tickets.Site tickets.Sites 13 6
tickets.Ticket tickets.Tickets 31 116
tickets.TicketType tickets.TicketTypes 5 3
tinymce.TextFieldTemplate tinymce.TextFieldTemplates 5 2
topics.Interest topics.Interests 4 0
topics.Tag topics.Tags 4 117
topics.Topic topics.Topics 4 5
trading.InvoiceItem trading.InvoiceItems 15 157
trading.PaperType trading.PaperTypes 5 2
trading.VatProductInvoice trading.Invoices 27 68
uploads.Upload uploads.Uploads 12 0
uploads.UploadType uploads.UploadTypes 8 1
uploads.Volume uploads.Volumes 5 0
users.Authority users.Authorities 3 0
users.User users.AllUsers 26 7
userstats.UserStat userstats.UserStats 4 36
vat.InvoiceItem vat.InvoiceItemTable 9 0
vat.VatAccountInvoice vat.Invoices 20 0
working.ServiceReport working.ServiceReports 10 0
working.Session working.Sessions 15 2384
working.SessionType working.SessionTypes 4 1
working.SiteSummary working.SiteSummaries 9 18
working.UserSummary working.UserSummaries 7 1092
================================== =================================== ========= =======