Table: AMS_DM_TARGETS_B

Product:	AMS - Marketing
Description:	Target column definitions for data mining models.
Implementation/DBA Data:	AMS.AMS_DM_TARGETS_B

Primary Key: AMS_DM_TARGETS_B_PK

1. TARGET_ID

Primary Key: AMS_DM_TARGETS_B_UK1

1. MODEL_TYPE
2. SOURCE_FIELD_ID
3. TARGET_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMS_DM_TARGETS_B		AMS_LIST_SRC_TYPES	AMS_DM_TARGETS_B.DATA_SOURCE_ID
AMS_DM_TARGETS_B		AMS_LIST_SRC_FIELDS	AMS_DM_TARGETS_B.SOURCE_FIELD_ID
AMS_DM_TARGETS_B		AMS_LIST_SRC_TYPES	AMS_DM_TARGETS_B.TARGET_SOURCE_ID
AMS_DM_MODELS_ALL_B		AMS_DM_TARGETS_B	AMS_DM_MODELS_ALL_B.TARGET_ID
AMS_DM_TARGETS_TL		AMS_DM_TARGETS_B	AMS_DM_TARGETS_TL.TARGET_ID
AMS_DM_TARGET_SOURCES		AMS_DM_TARGETS_B	AMS_DM_TARGET_SOURCES.TARGET_ID
AMS_DM_TARGET_VALUES_B		AMS_DM_TARGETS_B	AMS_DM_TARGET_VALUES_B.TARGET_ID