Alias: MBM#

(P2K_AM_BOOKMARKS)

Unique Keys: Function (MFN_ID) + User (MUS_ID) + BOOKMARK_NAME

ERD: ERD-AM20

User can mark a row in a function to return to.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MFN_IDNumber(10)IDYlink to P2K_AM_FUNCTIONS
MUS_IDNumber(10)IDYlink to P2K_AM_USERS
BOOKMARK_NAMEVarchar2(30)VARCHAR30Y
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
REFERENCE_IDNumber(10)NUMBER10
USAGE_COUNTERNumber(10)NUMBER10

User Fields: Not Allowed
Audit Logging: Not Allowed