Senzing v4 Schema Changes

Column Type Changes

Table.Column	v4 Type	v3 Type
LIB_FEAT.FEAT_HASH	varchar	char
LIB_FEAT.ANONYMIZED	varchar	char
SYS_HW_CHECK.FEAT_HASH	varchar	char
SYS_HW_CHECK.ANONYMIZED	varchar	char
RES_RELATE.IS_DISCLOSED	byte	number
RES_RELATE.IS_AMBIGUOUS	byte	number

Column Behavior Changes

Table.Column	Change
SYS_EVAL_QUEUE.MSG_ID	No longer an identity column

Tables Removed

Table
LIB_FEAT_HKEY
DSRC_RECORD_HKEY
OBS_ENT_SKEY
OBS_FEAT_EKEY
RES_ENT_RKEY
RES_FEAT_LKEY

Fields Added

Table.Column	Type
RES_FEAT_EKEY.OBS_ENT_CNT	BIGINT

Fields Removed

Table	Removed Fields
LIB_UTYPE	UTYPE_DESC
DSRC_RECORD	ETYPE_ID, OBS_ENT_HASH
OBS_ENT	ETYPE_ID, ENT_SRC_DESC, FROM_LENS_ID, FROM_RES_ENT_ID, FIRST_SEEN_DT, LAST_SEEN_DT, NODE_NAME
RES_ENT	LENS_ID, ECLASS_ID, INTEREST_LEVEL, CONFUSION_LEVEL, NUM_OBS_ENT, FIRST_SEEN_DT, LAST_SEEN_DT, NODE_NAME
RES_ENT_OKEY	LENS_ID, ER_ID
RES_FEAT_EKEY	ECLASS_ID, LENS_ID, FIRST_SEEN_DT, LAST_SEEN_DT
RES_FEAT_STAT	LENS_ID, ECLASS_ID
RES_RELATE	LENS_ID, REL_STRENGTH, REL_STATUS, INTEREST_LEVEL, CONFUSION_LEVEL, LAST_ER_ID, LAST_REF_SCORE, FIRST_SEEN_DT, LAST_SEEN_DT
RES_REL_EKEY	LENS_ID
SYS_SEQUENCE	SCATTER
SYS_EVAL_QUEUE	LENS_CODE, ETYPE_CODE