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