The WorkZone data model

The WorkZone data model consists three central registers, which are defined in the Data Dictionary. All Create-Read-Update-Delete operations are executed at the register level. A register itself consists of a number of database tables.

Each table is assigned one of the following roles in the register:

• Main table (Mandatory)
• Parent table
• Child table
• Extension table

A table consists of a number of columns (fields) and can be a member of many different registers and have different roles in each register. A table column can specify a domain and the content of a column can be a Foreign Key in another register.

The results of queries is a list of register records, not table rows, even if the query contains search criteria on a child table.

For example, querying a case (Register 1) with a specific party (Register 2) will result in a list of Files and each File, all parties will be returned, regardless of whether or not they match the query parameters.