test-client3

Tables (9)

ChainTestData

  • Key (id) — INT — Primary key — NOT NULL
  • Key (test_case_id) — INT — Foreign key → TestCase.Key — NOT NULL
  • Key (test_chain_id) — INT — Foreign key → TestChainInfo.Key — NOT NULL
  • Field (node_url) — VARCHAR(100) — NOT NULL
  • Field (name) — VARCHAR(45) — NOT NULL

ChainTestResult

  • Key (id) — INT — Primary key — NOT NULL
  • Key (test_data_id) — INT — Foreign key → ChainTestData.Key — NOT NULL
  • Key (test_case_id) — INT — Foreign key → ChainTestData.Key — NOT NULL
  • Field (res_ms) — INT — NOT NULL
  • Field (is_success) — INT — NOT NULL
  • Field (res_data) — JSON

TestCase

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(45) — NOT NULL
  • Field (interval_) — INT — NOT NULL
  • Field2 (creation_date) — INT — NOT NULL
  • Field (test_start_date) — INT — NOT NULL
  • Field (test_end_date) — INT — NOT NULL
  • Field (is_web_test) — INT — NOT NULL

TestCaseResult

  • Key (id) — INT — Primary key — NOT NULL
  • Key (test_case_id) — INT — Foreign key → TestCase.Key — NOT NULL
  • Field3 (test_success_ratio) — VARCHAR(45) — NOT NULL
  • Field (test_error_ratio) — VARCHAR(45) — NOT NULL

TestChainInfo

  • Key (id) — INT — Primary key — NOT NULL
  • Field (label) — VARCHAR(45) — NOT NULL
  • Field (network_id) — INT — NOT NULL

TestServerInfo

  • TestServerId (test_server_id) — INT — Primary key — NOT NULL
  • Field (test_server_name) — VARCHAR(45) — NOT NULL
  • Field2 (protocol) — VARCHAR(45) — NOT NULL
  • Field3 (host) — VARCHAR(45) — NOT NULL

TestTime

  • Key (id) — INT — Primary key — NOT NULL
  • Field (target_time) — INT — NOT NULL
  • Field (test_case_id) — INT — NOT NULL

WebTestData

  • TestDataId (id) — INT — Primary key — NOT NULL
  • TestServerId (test_server_id) — INT — Foreign key → TestServerInfo.TestServerId — NOT NULL
  • Key (test_case_id) — INT — Foreign key → TestCase.Key — NOT NULL
  • Field (http_method) — VARCHAR(45) — NOT NULL
  • Field (header) — JSON — NOT NULL
  • Field2 (qry_parameter) — VARCHAR(45)
  • Field3 (path_parameter) — VARCHAR(45)
  • Field (path) — VARCHAR(45) — NOT NULL
  • Field (body) — JSON — NOT NULL
  • Field (name) — VARCHAR(45) — NOT NULL

WebTestResult

  • Key (id) — INT — Primary key — NOT NULL
  • TestDataId (test_data_id) — INT — Foreign key → WebTestData.TestDataId — NOT NULL
  • Key (test_case_id) — INT — Foreign key → WebTestData.Key — NOT NULL
  • Field (res_ms) — INT — NOT NULL
  • Field2 (http_status_code) — INT — NOT NULL
  • Field (is_success) — INT — NOT NULL
  • Field (res_data) — JSON