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)