monitorling

Tables (4)

Server_Monitoring (API_MONITOR_DATA)

  • ID (id) — BIGINT(8) — Primary key — NOT NULL
  • AVAIL_VALUE (avail_value) — INT(4)
  • TOTAL_VALUE (total_value) — INT(4)
  • SERVER_NM — NVARCHAR(100)
  • DESC (desc) — NVARCHAR()
  • CREATED_AT (created_at) — DATETIME2
  • UPDATED_AT (updated_at) — DATETIME2
  • Field
  • RESOURCE_TYPE (code_type) — NVARCHAR(100) — Foreign key → Server_Monitoring.CODE_TYPE — NOT NULL

Server_Monitoring (AUTH_USER)

  • ID (id) — BIGINT(8) — Primary key — NOT NULL
  • PASSWORD (password) — NVARCHAR(128)
  • LAST_LOGIN (last_login) — DATETIME2
  • IS_SUPERUSER (is_superuser) — BIT(1)
  • USERNAME (username) — NVARCHAR(30)
  • EMAIL (email) — NVARCHAR(256)
  • IS_STAFF (is_staff) — BIT(1)
  • IS_ACTIVE (is_active) — BIT(1)
  • DATE_JOIN (date_join) — DATETIME2

Server_Monitoring (AUTHTOKEN_TOKEN)

  • TOKEN (token) — NVARCHAR(40) — Primary key — NOT NULL
  • CREATED_AT (created_at) — DATETIME2
  • USER_ID (id2) — BIGINT(8) — Foreign key → Server_Monitoring.ID — NOT NULL

Server_Monitoring (COMM_CODE)

  • ID (id) — BIGINT(8) — Primary key — NOT NULL
  • CODE_TYPE (code_type) — NVARCHAR(100) — Primary key — NOT NULL
  • CODE_NAME (code_name) — NVARCHAR(30)
  • MARK_NAME (mark_name) — NVARCHAR(100)
  • GROUP_CODE (group_code) — NVARCHAR(100)
  • FLAG (flag) — BIT(1)
  • CREATED_AT (created_at) — DATETIME2
  • UPDATED_AT (updated_at) — DATETIME2