Southwind database in demo apps

Not all tables from Southwind database are used in Lianja demo apps – explicit in section attributes. They can be set in code too.

Lianja sections visualize the tables.

These are relations between sections/tables in demo apps (explicit in section attributes):

demoappsrelations2

The table explanation:

  • # of the relationship
  • name of demo app
  • page name
  • section name
  • section type
  • section to which is related
  • 4 columns for: table1.field1 = table2.field2

Number like (12) shows in which section this relationship is used, from the table below.

The sign || on one side of the connection line shows “1-to-many” relationship (will be a grid).

 

southwind_notused

Some tables are virtual tables and some are auxiliary like help or uistates tables.