mpi_entnote_xx

The mpi_entnote table is used to store entity notes.

Expanded name: Entity notes
Table category: Entity-to-member relationship
Purpose: This table provides an area for entity notes. A table is created for each entity type you have configured in your MDM database (for example, id - Identity or hh - Household).
Cross-reference: This table references mpi_memhead through memrecno, mpi_audhead through caudrecno and maudrecno, and mpi_usrhead through cusrrecno and musrrecno.

Table 1. mpi_entnote_xx Attribute Descriptions
Attribute	Description
memrecno	Unique member record number from mpi_memhead
caudrecno	Creation of this particular record, from mpi_audhead
maudrecno	Modification of this particular record, from mpi_audhead
cusrrecno	Current user record
musrrecno	Modified user record
thenote	The text of the note

mpi_entnote SQL:

CREATE TABLE mpi_entnote_xx
(
memrecno   bigint		NOT NULL,
caudrecno  bigint		NOT NULL,
maudrecno  bigint		NOT NULL,
cusrrecno  int			NOT NULL,
musrrecno  int			NOT NULL,
thenote    nvarchar(255)	NOT NULL
)
CREATE UNIQUE INDEX mpi_entnote_xx1 ON mpi_entnote_xx (memrecno, caudrecno)