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