Table types
When you define a table, you must specify the kind of table it is. Operations and Regulations supports these table types:
| Table type | Description |
|---|---|
| Attachment Link Table | Defines a table that will be used to link attachments to records in a selected table. |
| Code Table | Defines a table that will store identification codes used to validate data, such as contact type codes, street suffix codes, or pay type codes.
Operations and Regulations automatically adds eight columns to a code table: ADDBY, ADDDTTM, CODE, DESCRIPT, EFFDATE, EXPDATE, MODBY, and MODDTTM. |
| Link Table | Defines a linking table for many-to-many relationships between two other tables.
Operations and Regulations automatically adds four columns to a link table: ADDBY, ADDDTTM, MODBY, and MODDTTM. |
| Table | Defines a standard database table.
Operations and Regulations automatically adds five columns to a standard table: ADDBY, ADDDTTM, MODBY, MODDTTM, and a primary key column that is named after the table name, such as MYTABLEKEY. |
| View | Used to create a business object that will interact with a view in your database. The Schema Manager doesn't create the actual view, so you must create it in your database application manually.
Note: Views are not supported in multi-tenant environments.
|