The mpi_srcattr table is reserved for source-to-attribute association for future functionality.

Expanded name
Source Attribute
Table category
Defines srcrecno-to-attrrecno mapping for future functions.
This table cross-references mpi_srchead through srcrecno and mpi_segattr through attrecno.
Table 1. mpi_srcattr Attribute Descriptions
Attribute Description
caudrecno Creation of this particular record, from mpi_audhead
maudrecno Last time the record value was modified, from mpi_audhead
recstat Record status; A(ctive) or I(nactive)
srcrecno Associated source, from mpi_srchead
attrrecno Attribute record number

mpi_srcattr SQL:

CREATE TABLE mpi_srcattr
caudrecno  bigint	NOT NULL,
maudrecno  bigint	NOT NULL,
recstat    nchar(1)	NOT NULL,
srcrecno   int		NOT NULL,
attrrecno  smallint	NOT NULL,
CREATE UNIQUE INDEX mpi_srcattr1 ON mpi_srcattr (srcrecno, attrrecno)