Welcome | Get started | Dive into Lino | Contribute | Reference
Lino Noi database structure¶
This document describes the database structure.
This is a tested document. 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())
...
- 57 plugins
- 107 models
- 5 user types
- 377 views
- 22 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())
...
57 apps: lino, staticfiles, about, jinja, bootstrap3, extjs, channels, linod, printing, system, contenttypes, gfks, help, office, xl, countries, contacts, social_django, users, noi, cal, calview, excerpts, memo, comments, changes, tickets, summaries, checkdata, working, lists, notify, uploads, export_excel, tinymce, smtpd, weasyprint, appypod, dashboard, userstats, groups, products, ledger, vat, sales, storage, invoicing, subscriptions, pages, publisher, rest_framework, restful, addresses, phones, google, search, sessions.
107 models:
================================== =================================== ========= =======
Name Default table #fields #rows
---------------------------------- ----------------------------------- --------- -------
addresses.Address addresses.Addresses 16 54
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 252
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 107
countries.Country countries.Countries 6 9
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 4 0
invoicing.Item invoicing.Items 9 1
invoicing.Plan invoicing.Plans 8 1
invoicing.SalesRule invoicing.SalesRules 3 0
invoicing.Tariff invoicing.Tariffs 8 0
ledger.Account ledger.Accounts 18 20
ledger.AccountingPeriod ledger.AccountingPeriods 7 39
ledger.FiscalYear ledger.FiscalYears 5 9
ledger.Journal ledger.Journals 27 4
ledger.LedgerInfo ledger.LedgerInfoTable 2 0
ledger.MatchRule ledger.MatchRules 3 0
ledger.Movement ledger.Movements 11 406
ledger.PaymentTerm ledger.PaymentTerms 11 8
ledger.Voucher ledger.AllVouchers 8 263
linod.Job linod.Jobs 4 0
linod.JobRule linod.JobRules 21 6
lists.List lists.Lists 7 8
lists.ListType lists.ListTypes 4 3
lists.Member lists.Members 5 82
memo.Mention memo.Mentions 5 0
notify.Message notify.Messages 11 421
notify.Subscription notify.SubscriptionTable 7 ...
pages.Node pages.Nodes 18 22
phones.ContactDetail phones.ContactDetails 8 5
products.Category products.Categories 15 0
products.PriceRule products.PriceRules 4 1
products.Product products.Products 20 8
sales.InvoiceItem sales.InvoiceItems 16 427
sales.PaperType sales.PaperTypes 5 2
sales.VatProductInvoice sales.Invoices 27 203
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 7 5
storage.Movement storage.Movements 10 55
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 16 6
tickets.Ticket tickets.Tickets 30 116
tickets.TicketType tickets.TicketTypes 5 3
tinymce.TextFieldTemplate tinymce.TextFieldTemplates 5 2
uploads.Upload uploads.Uploads 13 0
uploads.UploadType uploads.UploadTypes 8 1
uploads.Volume uploads.Volumes 5 0
users.Authority users.Authorities 3 0
users.User users.AllUsers 25 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 16 2384
working.SessionType working.SessionTypes 4 1
working.SiteSummary working.SiteSummaries 9 18
working.UserSummary working.UserSummaries 7 252
================================== =================================== ========= =======