알림

테이블 (8)

filter_condition_by_rule

  • notification_rule_id — VARCHAR(36) — 외래 키 → notification_rule.notification_rule_id — NOT NULL
  • error_type — VARCHAR(45) — NOT NULL
  • filter_condition_values — VARCHAR(500) — NOT NULL
  • INDEX — `fk_filter_condition_by_rule_notification_rule1_idx`

notification_by_rule

  • notification_rule_id — VARCHAR(36) — 외래 키 → notification_rule.notification_rule_id — NOT NULL
  • notification_type — VARCHAR(45) — NOT NULL
  • INDEX — `fk_notification_by_rule_notification_rule1_idx`

notification_recipient

  • notification_recipient_id — VARCHAR(36) — 기본 키 — NOT NULL
  • notification_service_id — VARCHAR(36) — 외래 키 → notification_service.notification_service_id — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • INDEX — `fk_notification_recipient_notification_service1_idx`
  • INDEX — `fk_notification_recipient_user1_idx`

notification_rule

  • notification_rule_id — VARCHAR(36) — 기본 키 — NOT NULL
  • notification_service_id — VARCHAR(36) — 외래 키 → notification_service.notification_service_id — NOT NULL
  • notification_rule_name — VARCHAR(45) — NOT NULL
  • INDEX — `fk_notification_rule_notification_service1_idx`

notification_service

  • notification_service_id — VARCHAR(36) — 기본 키 — NOT NULL
  • notification_service_name — VARCHAR(45) — NOT NULL

recipient_by_rule

  • notification_rule_id — VARCHAR(36) — 외래 키 → notification_rule.notification_rule_id — NOT NULL
  • notification_recipient_id — VARCHAR(36) — 외래 키 → notification_recipient.notification_recipient_id — NOT NULL
  • INDEX — `fk_recipient_by_rule_notification_rule1_idx`
  • INDEX — `fk_recipient_by_rule_notification_recipient1_idx`

suppress_time

  • notification_service_id — VARCHAR(36) — 외래 키 → notification_service.notification_service_id — NOT NULL
  • suppress_time_list — VARCHAR(45) — NOT NULL
  • INDEX — `fk_suppress_time_notification_service1_idx`

template

  • notification_service_id — VARCHAR(36) — 외래 키 → notification_service.notification_service_id — NOT NULL
  • error_type — VARCHAR(45) — NOT NULL
  • notification_type — VARCHAR(45) — NOT NULL
  • template — VARCHAR(400) — NOT NULL
  • INDEX — `fk_template_notification_service1_idx`