ALERTNOW_TAGGING
Tables (4)
1 (ISBER)
- Alert_id (PK) — INT — Primary key — NOT NULL
- Company_id (Field) — INT
- Integration_type (Field2) — VARCHAR(500)
- Payload_Summary (Field3) — TEXT
2 (Sentence_table)
- Sentence_id (PK) — INT — Primary key — NOT NULL
- Alert_id (FK) — INT — Foreign key → 1.Alert_id — NOT NULL
- Sentence (Field) — TEXT
3 (Template_Table)
- Template_id (PK) — INT — Primary key — NOT NULL
- Sentence (FK) — TEXT — Foreign key → 2.Sentence_id — NOT NULL
- Template (Field1) — TEXT
- Alert_title (Field2) — VARCHAR(500)
- Impact_scope (Field3) — VARCHAR(500)
- Key_symptom (Field4) — VARCHAR(500)
- Alert_type (Field5) — VARCHAR(500)
- Company_id (Field6) — INT
4 (Entity_Table)
- Entity_id (PK) — INT — Primary key — NOT NULL
- Alert_id (FK) — INT — Foreign key → 1.Alert_id — NOT NULL
- Affected_entity (Field) — VARCHAR(500)