CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
The META_CLASS table stores information about the class of actions available in Infor CRM. Currently, this table contains records for the ListView, Email, ShowView, File, Tools, Print, and other classes.
Table Relationships
The META_CLASS table has a (Zero or One) to (Many) relationship with the META_CLASSFUNCTION table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
CLASSID (PK) |
STANDARDID(12) |
NOT NULL |
META_CLASS_PK (CA) |
|
CLASSNAME |
varchar(64) |
NULLS |
|
|
DESCRIPTIONID |
STANDARDID(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|