Database structure of Lino PrestoΒΆ
This document describes the database structure.
This document is part of the Lino test suite and has been tested using
doctest. You can re-play the instructions on this page in the demo
project, either interactively in a Django shell session or
by writing a script and run it using run. Read also the
general documentation about Doctests in Lino. The following
instructions are used for initialization:
>>> import lino
>>> lino.startup('lino_presto.projects.noereth.settings.doctests')
>>> from lino.api.doctest import *
>>> from lino.utils.diag import analyzer
>>> print(analyzer.show_db_overview())
...
43 apps: lino, staticfiles, about, jinja, bootstrap3, extjs, printing, system, users, office, xl, countries, contacts, contenttypes, gfks, checkdata, cal, weasyprint, uploads, ledger, orders, dashboard, calview, clients, households, addresses, phones, humanlinks, topics, healthcare, products, memo, excerpts, vat, sales, invoicing, sepa, notes, appypod, export_excel, tinymce, presto, sessions.
80 models:
=========================== ============================ ========= =======
Name Default table #fields #rows
--------------------------- ---------------------------- --------- -------
addresses.Address addresses.Addresses 16 145
cal.Calendar cal.Calendars 6 1
cal.Event cal.OneEvent 24 1206
cal.EventPolicy cal.EventPolicies 20 6
cal.EventType cal.EventTypes 23 8
cal.Guest cal.Guests 6 1204
cal.GuestRole cal.GuestRoles 5 2
cal.RecurrentEvent cal.RecurrentEvents 22 16
cal.RemoteCalendar cal.RemoteCalendars 7 0
cal.Room cal.AllRooms 13 6
cal.Subscription cal.Subscriptions 4 0
cal.Task cal.Tasks 19 0
calview.DailyPlannerRow calview.DailyPlannerRows 7 2
checkdata.Problem checkdata.Problems 6 329
clients.ClientContact clients.ClientContacts 7 0
clients.ClientContactType clients.ClientContactTypes 5 5
contacts.Company contacts.Companies 30 31
contacts.CompanyType contacts.CompanyTypes 7 14
contacts.Membership contacts.Memberships 4 30
contacts.Partner contacts.Partners 28 151
contacts.Person contacts.Persons 35 106
contacts.Role contacts.Roles 4 4
contacts.RoleType contacts.RoleTypes 5 5
contacts.Worker contacts.Workers 38 9
contenttypes.ContentType gfks.ContentTypes 3 80
countries.Country countries.Countries 6 8
countries.Place countries.Places 9 78
dashboard.Widget dashboard.Widgets 5 0
excerpts.Excerpt excerpts.Excerpts 12 0
excerpts.ExcerptType excerpts.ExcerptTypes 17 7
gfks.HelpText gfks.HelpTexts 4 2
healthcare.Plan healthcare.Plans 4 5
healthcare.Rule healthcare.Rules 6 0
healthcare.Situation healthcare.Situations 6 0
households.Household households.Households 30 14
households.Member households.Members 14 57
households.Type households.Types 4 6
humanlinks.Link humanlinks.Links 4 56
invoicing.Area invoicing.Areas 6 3
invoicing.Item invoicing.Items 9 0
invoicing.Plan invoicing.Plans 8 1
invoicing.SalesRule invoicing.SalesRules 3 17
invoicing.Tariff invoicing.Tariffs 7 2
ledger.Account ledger.Accounts 18 27
ledger.AccountingPeriod ledger.AccountingPeriods 7 3
ledger.FiscalYear ledger.FiscalYears 5 11
ledger.Journal ledger.Journals 26 8
ledger.LedgerInfo ledger.LedgerInfoTable 2 0
ledger.MatchRule ledger.MatchRules 3 0
ledger.Movement ledger.Movements 12 58
ledger.PaymentTerm ledger.PaymentTerms 11 8
ledger.Voucher ledger.AllVouchers 8 143
notes.EventType notes.EventTypes 8 1
notes.Note notes.Notes 17 100
notes.NoteType notes.NoteTypes 11 3
orders.Enrolment orders.Enrolments 5 136
orders.Order orders.Orders 32 114
orders.OrderItem orders.OrderItems 6 114
phones.ContactDetail phones.ContactDetails 7 15
presto.Client presto.Clients 43 65
presto.LifeMode presto.LifeModes 4 6
products.PriceRule products.PriceRules 5 12
products.Product products.Products 14 8
products.ProductCat products.ProductCats 6 2
sales.InvoiceItem sales.InvoiceItems 15 72
sales.PaperType sales.PaperTypes 5 3
sales.VatProductInvoice sales.Invoices 27 29
sepa.Account sepa.Accounts 6 17
sessions.Session sessions.SessionTable 3 ...
system.SiteConfig system.SiteConfigs 10 1
tinymce.TextFieldTemplate tinymce.TextFieldTemplates 5 2
topics.Interest topics.Interests 6 0
topics.Topic topics.Topics 8 3
uploads.Upload uploads.Uploads 11 0
uploads.UploadType uploads.UploadTypes 8 1
uploads.Volume uploads.Volumes 5 0
users.Authority users.Authorities 3 0
users.User users.AllUsers 18 4
vat.InvoiceItem vat.InvoiceItemTable 9 0
vat.VatAccountInvoice vat.Invoices 20 0
=========================== ============================ ========= =======