The mpi_entnote table is used to store entity notes.

Expanded name
Entity notes
Table category
Entity-to-member relationship
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).
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)