logManagement

Tables (11)

agent_conf

  • server_idx (Key) — Primary key — NOT NULL
  • section_name (Key2) — Primary key — NOT NULL
  • key_name (Key3) — Primary key — NOT NULL
  • value (Field)
  • valid (Field2)
  • created_at (Field3)

agent_info (Untitled)

  • id (Key) — Primary key — NOT NULL
  • server_idx (Field)
  • uri (Field2)
  • port (Field3)

backup_hist (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • job_name (Field)
  • updated_by (Field2)
  • job_type (Field3)
  • type (Field4)
  • level (Field5)
  • start_at (Field6)
  • end_at (Field7)
  • size (Field8)
  • error (Field9)
  • status (Field10)

backup_info (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • job_name (Field)
  • server_id (Field2)
  • type (Field3)
  • shell_path (Field4)
  • period_type (Field5)
  • period_time (Field6)
  • period (Field7)
  • level (Field8)
  • preserv (Field9)
  • created_at (Field10)
  • created_by (Field11)
  • updated_at (Field12)
  • updated_by (Field13)
  • valid (Field14)

delete_period (Untitled3)

  • id (Field)
  • name (Field2)
  • table_name (Field3)
  • server_id (Field4) — char
  • shell_path (Field5)
  • period (Field6)
  • period_type (Field7)
  • valid (Field8)

event_info (Untitled8)

  • server_idx (Field)
  • process_idx (Field2)
  • section_name (Field3)
  • key_name (Field4)
  • value (Field5)
  • valid (Field6)

event_log (Untitled6)

  • event_id (Key) — Primary key — NOT NULL
  • event_type_id (Key2) — Foreign key → event_type.event_type_id — NOT NULL
  • process_idx (Key3) — Foreign key → process_info.process_idx — NOT NULL
  • id (Key22) — int(8) — Foreign key → process_info.id — NOT NULL
  • server_idx (Key222) — Foreign key → process_info.server_idx — NOT NULL
  • source (Field)
  • cause (Field2)
  • description (Field3)
  • closed (Field4)
  • close_time (Field5)
  • close_by (Field6)

event_type (Untitled7)

  • event_type_id (Key) — Primary key — NOT NULL
  • event_type (Field)
  • description (Field2)
  • valid_state (Field3)

port_info (Untitled4)

  • process_idx (Key5) — Foreign key → process_info.process_idx — NOT NULL
  • id (Key22) — int(8) — Foreign key → process_info.id — NOT NULL
  • server_idx (Key222) — Foreign key → process_info.server_idx — NOT NULL
  • value (Field)
  • valid (Field2)

process_info

  • process_idx (Key) — Primary key — NOT NULL
  • id (Key2) — int(8) — Foreign key → server_info.id — NOT NULL
  • server_idx (Key22) — Foreign key → server_info.server_idx — NOT NULL
  • uri (Field)
  • port (Field2)
  • valid (Field3)

server_info

  • id (Key) — int(8) — Primary key — NOT NULL
  • server_idx (Key2) — Primary key — NOT NULL
  • server_type (Field3) — int(11)
  • ip (Field4) — VARCHAR(45)
  • ext_info (Field5) — TEXT
  • server_name (Field)