mpi_relxtsk
The mpi_relxtsk table stored relationship task information.
- Expanded name
- Relationship types
- Table category
- Relationship
- Purpose
- This runtime data table stores information about relationships that have an associated task. Tasks are created when relationships compare above specified thresholds.
- Cross-reference
- Not applicable.
| Attribute | Description |
|---|---|
| caudrecno | Creation of this particular record, from mpi_audhead |
| maudrecno | Last time the record value was modified, from mpi_audhead |
| tskrecno | Relationship task record number; assigned from mpi_seqgen |
| tsktypeno | Identifies the task type, from mpi_tsktype |
| tskstatno | Task workflow status, from mpi_tskstat. |
| usrrecno | Unique user ID number from mpi_usrhead |
| reltypeno | Numeric value from the relationship type |
| side | Indicates which side of the relationship link that the associated entrecno applies; supports searching for relationship links by entrecno |
| recno | Record number |
mpi_relxtsk SQL:
create table mpi_relxtsk
(
caudrecno bigint NOT NULL,
maudrecno bigint NOT NULL,
tskrecno bigint NOT NULL,
tsktypeno smallint NOT NULL,
tskstatno smallint NOT NULL,
usrrecno smallint NOT NULL,
reltypeno int NOT NULL,
side nchar(1) NOT NULL
recno bigint NOT NULL
)
CREATE UNIQUE INDEX mpi_relxtsk0 ON mpi_relxtsk (tsktypeno,reltypeno,recno,tskrecno)
CREATE UNIQUE INDEX mpi_relxtsk1 ON mpi_relxtsk (recno,tskstatno)