NIPO Fieldwork System Database Tables and Fields

NIPO Fieldwork System Version 1.14

NIPO Fieldwork System Database Tables and Fields

This section lists the default NIPO Fieldwork System database tables and fields created using a clean installation of the NIPO Fieldwork System. This default database contains all tables and fields required by the NIPO Fieldwork System. Using the default table and field names makes it easier to automatically link the services with the database and is highly recommended, but table and field names may be changed to better suit the needs of your company.

Note that any name change to one of the tables and fields listed in this section may require configuration changes in one or more service (the NIPO CATI / Web Master, the NIPO FMS server and the NIPO Web Server).

When using different names than the provided default, take into account the following limitations:

Names in custom table and field names should not contain spaces.
Names in custom table and field names should not use SQL-specific keywords (GROUP, SELECT, BY, ORDER, WHERE, USER, KEY).

Note that some tables and fields are optional and may be omitted if not configured. For all tables and fields a brief description of the contents and function is given.

All tables use primary keys for lookup. Some tables use a primary key that is set up on multiple fields. In this section, primary key fields are marked with .