<database>.DBTables

This file contains details of the tables in this database, including the table type.

Each line in the file contains a comma separated list of values that define a single table:

TEXT

<table_name>, <type>, <distinction>, <parent>, <responses>, <empty_code>

The values are as follows:

Entry

Description

<table_name>

The table name.

<type>

The table type, which can be one of the following:

F	Flat table.	Flat tables are stored as a text file, with each line in the file representing a row in the table.
H	Hierarchical table.	Hierarchical tables are stored as a text file, with each line representing a row belong to the hierarchical table or another table.
A	Abstract table.	Abstract tables are extracted from a hierarchical text file and do not have their own distinction string. They are derived from concrete tables and can have columns shared by these tables.
C	Concrete table.	Concrete tables help to define an abstract table.
M	Multi-response table.	Multi-response tables capture data where there is more than one possible response to a given question. The rows in the multi-response table are stored in one line belonging to a parent table's row.

<distinction>

(Optional) The distinction string for the table.

<parent>

(Optional) The parent table.

<responses>

(Optional) The maximum number of responses. Only applies to multi-response tables.

<empty_code>

(Optional) An empty code (other than NULL) used for multi-response tables to define an empty response.

For example:

Household.DBTables

TEXT

Pets,H,T,People
Houses,H,H
Rooms,H,R,Houses
People,H,P,Houses
Cars,H,C,People
Computers,H,M,People
CPU Type,F
Num Windows,F