Each node type (primary or mixin) corresponds to a table.
Each column in the table corresponds to a property defined in or inherited by that node type (including properties inherited from either primary or mixin node types). Modeling residual properties as columns is optional (see below).
Each row corresponds to a node in the workspace.
Note that because of the hierarchical structure of node type definitions, nodes will appear in more than just one table. For example, querying the nt:base table will show all nodes in the workspace, but that table will be limited to the columns corresponding to the properties defined by nt:base: jcr:primaryType and jcr:mixinTypes.
Child node relationships are not recorded in the database view.