EFFECTIVE_DAY

Description

This table stores effective days.

Columns

Column Name Data Type Description
ID bigint The unique identifier for the effective day.
DAY_OF_WEEK varchar The day of the week.
EFFECTIVE_DAYS_TRIGGER_OPERA_0 bigint The reference to the trigger operation.
EFFECTIVE_DAYS_HJORDER int The effective days for HJ order.
EFFECTIVE_DAYS_CAMPAIGN_DRAF_0 bigint The reference to the campaign draft.
EFFECTIVE_DAYS_CAMPAIGN_CORE_0 bigint The reference to the campaign core immutable element.
EFFECTIVE_DAYS_CAMPAIGN_IMMU_0 bigint The reference to the campaign immutable elements.

Foreign Key Relationships

  • EFFECTIVE_DAYS_TRIGGER_OPERA_0 references TRIGGER_OPERATION(ID)
  • EFFECTIVE_DAYS_CAMPAIGN_DRAF_0 references CAMPAIGN_DRAFT(ID)
  • EFFECTIVE_DAYS_CAMPAIGN_CORE_0 references CAMPAIGN_CORE_IMMUTABLE_ELEM_0(ID)
  • EFFECTIVE_DAYS_CAMPAIGN_IMMU_0 references CAMPAIGN_IMMUTABLE_ELEMENTS(ID)