PROFILE_CONDITION_TEMPLATE

Description

Table for storing templates of profile conditions.

Columns

Column Name Data Type Description
ID bigint(20)

NOT NULL

Primary key for the table.
PROFILE varchar(255)

DEFAULT NULL

Profile for the template.
FEEDS_SELECTOR_FEEDS_OR_PROF_0 bigint(20) '

DEFAULT NULL

Foreign key referencing the ID column in the FEEDS_SELECTOR table.
ANALYTICS_BASED bit(1)

NOT NULL

Flag indicating if the template is analytics-based.
CAPTION longtext

NOT NULL

Caption for the template.
CONDITION_TEMPLATE_ID varchar(255)

DEFAULT NULL

Template ID for the template.
NAME varchar(255)

NOT NULL

Name of the template.
DOMAIN_MAPPING_PROFILE_CONDI_1 bigint(20)

DEFAULT NULL

Foreign key referencing the ID column in the PROFILE_CONDITION_MODIFIER table.
TARGET_METRIC_SEGMENT_PROFIL_0 bigint(20)

DEFAULT NULL

Foreign key referencing the ID column in the TARGET_METRIC_SEGMENT table.
CONDITION_KIND varchar(255)

NOT NULL

Kind of condition for the template.

Foreign Key Relationships

  • FOREIGN KEY ( TARGET_METRIC_SEGMENT_PROFIL_0 ) REFERENCES TARGET_METRIC_SEGMENT (

ID ): Establishes a foreign key relationship with the TARGET_METRIC_SEGMENT table.

  • FOREIGN KEY ( FEEDS_SELECTOR_FEEDS_OR_PROF_0 ) REFERENCES FEEDS_SELECTOR ( ID ): Establishes a foreign key relationship with the FEEDS_SELECTOR table.