Table types
When you define a table, you must specify the kind of table it is. Infor 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.
Infor 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.
Infor Operations and Regulations automatically adds four columns to a link table: ADDBY, ADDDTTM, MODBY, and MODDTTM. |
| Table | Defines a standard database table.
Infor 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.
|