알림
테이블 (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`