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):
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).
Some tables are virtual tables and some are auxiliary like help or uistates tables.