PROFILE_CONDITION_MODIFIER

Description

Table for storing modifiers for profile conditions.

Columns

Column Name Data Type Description
ID bigint(20)

NOT NULL

Primary key for the table.
CAPTION longtext

NOT NULL

Caption for the modifier.
MODIFIER_ID varchar(255)

NOT NULL

Modifier ID for the modifier.
NAME varchar(255)

NOT NULL

Name of the modifier.
DOMAIN_MAPPING_PROFILE_CONDI_0 bigint(20)

NOT NULL

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

DEFAULT NULL

Foreign key referencing the ID column in the PROFILE_CONDITION_MODIFIER table.
MODIFIERS_HJORDER int(11)

DEFAULT NULL

Order of the modifier.

Foreign Key Relationships

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