map

Tables (8)

Fidelis

  • id — ObjectId — Primary key — NOT NULL
  • unit_id (fmc_fms) — ObjectId — Foreign key → Unit.id — NOT NULL
  • pulic_ip — varchar(20)
  • private_ip — varchar(20)
  • status — varchar(20)
  • created_at — timestamp
  • created_by — integer
  • updated_by — integer
  • updated_at — timestamp

Fidelis_incident_history

  • id — ObjectId — Primary key — NOT NULL
  • fidelis_id — ObjectId — Foreign key → Fidelis.id — NOT NULL
  • detail — string
  • start_time — timestamp
  • end_time — timestamp

Fidelis_risks

  • id — ObjectId — Primary key — NOT NULL
  • fidelis_id — ObjectId — Foreign key → Fidelis.id — NOT NULL
  • device — string
  • reason — string
  • infected_datetime — timestamp
  • processing_time — timestamp
  • status — string
  • updated_by — integer
  • updated_at — timestamp
  • created_by — integer
  • created_at — timestamp

Incident_history

  • id — ObjectId — Primary key — NOT NULL
  • fmd_fms_id — integer — Foreign key → fmc_fms.id — NOT NULL
  • detail — string
  • start_time — timestamp
  • end_time — timestamp

Unit

  • id — ObjectId — Primary key — NOT NULL
  • name — string
  • unit_code — string
  • profile_path — string
  • lat — number — encode
  • long — number — encode
  • created_by — integer
  • created_at — timestamp
  • updated_at — timestamp
  • updated_by — timestamp

User

  • id — ObjectId — Primary key — NOT NULL
  • username — string
  • password — string — endcode
  • role — string — enum
  • updated_by — integer
  • updated_at — timestamp
  • created_by — integer
  • created_at — timestamp

fmc_fms

  • id — ObjectId — Primary key — NOT NULL
  • unit_id (fmc_fms) — ObjectId — Foreign key → Unit.id — NOT NULL
  • pulic_ip — string
  • private_ip — string
  • status — string
  • created_at — timestamp
  • updated_by — integer
  • created_by — integer
  • updated_at — timestamp
  • is_fms — boolean

fmc_fms_risks

  • id — ObjectId — Primary key — NOT NULL
  • fmc_fms_id — ObjectId — Foreign key → fmc_fms.id — NOT NULL
  • device — string
  • reason — string
  • infected_datetime — timestamp
  • processing_time — timestamp
  • status — string
  • updated_by — integer
  • updated_at — timestamp
  • created_by — integer
  • created_at — timestamp