CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
The PROCEDURECONTRIBUTOR table stores information about individuals who have contributed details, steps, or similar information, to Infor CRM procedures.
table relationships
The PROCEDURECONTRIBUTOR table has a (Many) to (Zero or One) relationship with the PROCEDURES table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
PROCEDURECONTRIBUTORID (PK) |
STANDARDID(12) |
NOT NULL |
PROCEDURECONTRIBUTORID_PK (CA) |
|
PROCEDUREID(FK) |
STANDARDID(12) |
NOT NULL |
PROCEDURECONTRIBUTOR_CONTRIBUTORSECCODEID (IE) |
|
STANDARDID(12) |
NOT NULL |
PROCEDURECONTRIBUTOR_PROCEDUREID (IE) |
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
PHONE |
varchar(32) |
NULLS |
|
|
|
varchar(128) |
NULLS |
|