Senzing v4 Schema Changes

Tables Changed

  • LIB_FEAT.FEAT_HASH: new type varchar (was char)

  • LIB_FEAT.ANONYMIZED: new type varchar (was char)

  • SYS_HW_CHECK.FEAT_HASH: new type varchar (was char)

  • SYS_HW_CHECK.ANONYMIZED: new type varchar (was char)

  • RES_RELATE.IS_DISCLOSED: new type byte (was number)

  • RES_RELATE.IS_AMBIGUOUS: new type byte (was number)

  • SYS_EVAL_QUEUE.MSG_ID: No longer an identity column

Tables Removed

  • LIB_FEAT_HKEY: No longer required

  • DSRC_RECORD_HKEY: No longer required

  • OBS_ENT_SKEY: No longer required

  • OBS_FEAT_EKEY: No longer required

  • RES_ENT_RKEY: No longer required

  • RES_FEAT_LKEY: No longer required

Fields Added

  • RES_FEAT_EKEY.OBS_ENT_CNT: (BIGINT)

Fields Removed

LIB_UTYPE.UTYPE_DESC: No longer required

DSRC_RECORD.ETYPE_ID: No longer required

DSRC_RECORD.OBS_ENT_HASH: No longer required

OBS_ENT.ETYPE_ID: No longer required

OBS_ENT.ENT_SRC_DESC: No longer required

OBS_ENT.FROM_LENS_ID: No longer required

OBS_ENT.FROM_RES_ENT_ID: No longer required

OBS_ENT.FIRST_SEEN_DT: No longer required

OBS_ENT.LAST_SEEN_DT: No longer required

OBS_ENT.NODE_NAME: No longer required

RES_ENT.LENS_ID: No longer required

RES_ENT.ECLASS_ID: No longer required

RES_ENT.INTEREST_LEVEL: No longer required

RES_ENT.CONFUSION_LEVEL: No longer required

RES_ENT.NUM_OBS_ENT: No longer required

RES_ENT.FIRST_SEEN_DT: No longer required

RES_ENT.LAST_SEEN_DT: No longer required

RES_ENT.NODE_NAME: No longer required

RES_ENT_OKEY.LENS_ID: No longer required

RES_ENT_OKEY.ER_ID: No longer required

RES_FEAT_EKEY.ECLASS_ID: No longer required

RES_FEAT_EKEY.LENS_ID: No longer required

RES_FEAT_EKEY.FIRST_SEEN_DT: No longer required

RES_FEAT_EKEY.LAST_SEEN_DT: No longer required

RES_FEAT_STAT.LENS_ID: No longer required

RES_FEAT_STAT.ECLASS_ID: No longer required

RES_RELATE.LENS_ID: No longer required

RES_RELATE.REL_STRENGTH: No longer required

RES_RELATE.REL_STATUS: No longer required

RES_RELATE.INTEREST_LEVEL: No longer required

RES_RELATE.CONFUSION_LEVEL: No longer required

RES_RELATE.LAST_ER_ID: No longer required

RES_RELATE.LAST_REF_SCORE: No longer required

RES_RELATE.FIRST_SEEN_DT: No longer required

RES_RELATE.LAST_SEEN_DT: No longer required

RES_REL_EKEY.LENS_ID: No longer required

SYS_SEQUENCE.SCATTER: No longer required

SYS_EVAL_QUEUE.LENS_CODE: No longer required

SYS_EVAL_QUEUE.ETYPE_CODE: No longer required