Table types
Table types define the
basic function of a table. Infor Public Sector classifies the
tables in its database by table type. When you define a table, you must specify the kind of
table it is. Infor Public Sector provides these table
types:
| Table type | Description |
|---|---|
| Attachment Link Table | Defines a table that will be used to link attachments from the attachment catalog 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 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. Note that the Schema Manager doesn't create the actual view, so you must create it in your database application manually. |