일일 점검 자동화

테이블 (4)

T_COMPANY

  • company_id — BIGINT — 기본 키
  • company_name — Varchar(30)
  • docker_cnt — BIGINT
  • crontab_cnt — BIGINT
  • disk_clear_value — BIGINT

T_INSPECT_LIST

  • Inspection_result — BIGINT — 기본 키
  • server_id — BIGINT — 외래 키 → T_SERVER.server_id
  • company_id — BIGINT — 외래 키 → T_SERVER.company_id
  • cpu — BIGINT
  • memory — BIGINT
  • disk — BIGINT
  • docker — Boolean
  • backup_log — Boolean
  • backup_db — Boolean
  • total_flow_cnt — BIGINT
  • total_endpoint_cnt — BIGINT
  • total_call_cnt — BIGINT
  • success_call_cnt — BIGINT
  • fail_call_cnt — BIGINT
  • max_res_time — BIGINT
  • avg_res_time — BIGINT
  • createdAt — Datetime
  • docker_cnt — BIGINT
  • crontab_cnt — BIGINT

T_SERVER

  • server_id — BIGINT — 기본 키
  • company_id — BIGINT — 외래 키 → T_COMPANY.company_id
  • servere_name — Varchar(30)

T_USER

  • user_id — BIGINT — 기본 키 — NOT NULL
  • company_id — BIGINT — 외래 키 → T_COMPANY.company_id
  • email — Varchar(30)
  • password — Varchar(30)
  • createdAt — Datetime
  • role — Varchar(200)