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.
| 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)