mpi_srcattr

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

Expanded name
Source Attribute
Table category
Metadata
Purpose
Defines srcrecno-to-attrrecno mapping for future functions.
Cross-reference
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)