tpops

Tables (17)

business_code_dictionary

  • code — CHAR(3) — Primary key — NOT NULL
  • name_ko — VARCHAR(100) — NOT NULL

service_name_mapping

  • physical_name — VARCHAR(31) — Primary key — NOT NULL
  • logical_name — VARCHAR(200) — NOT NULL
  • business_code — CHAR(3) — Foreign key → business_code_dictionary.code

tmax_config_file

  • id — BIGINT — Primary key — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_hash — CHAR(64) — NOT NULL
  • parse_status — VARCHAR(10) — NOT NULL
  • picked_at — TIMESTAMP — NOT NULL

tmax_domain

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • validation — VARCHAR(10) — NOT NULL

tmax_gateway

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • node_id — BIGINT — Foreign key → tmax_node.id — NOT NULL
  • nodename — VARCHAR(255) — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • gwtype — VARCHAR(20) — NOT NULL
  • portno — INT — NOT NULL
  • rgwaddr — VARCHAR(255) — NOT NULL
  • rgwportno — INT — NOT NULL
  • validation — VARCHAR(10) — NOT NULL

tmax_gateway_backup

  • id — BIGINT — Primary key — NOT NULL
  • gateway_id — BIGINT — Foreign key → tmax_gateway.id — NOT NULL
  • backup_idx — TINYINT — NOT NULL
  • rgwaddr — VARCHAR(255)
  • rgwportno — INT

tmax_hms

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • attributes — JSON

tmax_node

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • hostname — VARCHAR(255)
  • ip — VARCHAR(45)
  • validation — VARCHAR(10) — NOT NULL

tmax_node_port

  • id — BIGINT — Primary key — NOT NULL
  • node_id — BIGINT — Foreign key → tmax_node.id — NOT NULL
  • port_type — VARCHAR(20) — NOT NULL
  • port_no — INT — NOT NULL
  • idx — SMALLINT — NOT NULL

tmax_parse_issue

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • code — VARCHAR(10) — NOT NULL
  • severity — VARCHAR(10) — NOT NULL
  • message — TEXT — NOT NULL
  • source_line — INT
  • domain_id — BIGINT — Foreign key → tmax_domain.id
  • node_id — BIGINT — Foreign key → tmax_node.id
  • svrgroup_id — BIGINT — Foreign key → tmax_svrgroup.id
  • server_id — BIGINT — Foreign key → tmax_server.id
  • service_id — BIGINT — Foreign key → tmax_service.id
  • gateway_id — BIGINT — Foreign key → tmax_gateway.id

tmax_routing

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • type — VARCHAR(20)
  • validation — VARCHAR(10) — NOT NULL

tmax_routing_range

  • id — BIGINT — Primary key — NOT NULL
  • routing_id — BIGINT — Foreign key → tmax_routing.id — NOT NULL
  • low_value — VARCHAR(255)
  • high_value — VARCHAR(255)
  • target_svgname — VARCHAR(15) — NOT NULL
  • idx — SMALLINT — NOT NULL

tmax_rq

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • attributes — JSON

tmax_server

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • svrgroup_id — BIGINT — Foreign key → tmax_svrgroup.id — NOT NULL
  • svgname — VARCHAR(15) — NOT NULL
  • node_id — BIGINT — Foreign key → tmax_node.id — NOT NULL
  • nodename — VARCHAR(15) — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • svrtype — VARCHAR(20)
  • validation — VARCHAR(10) — NOT NULL

tmax_service

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • server_id — BIGINT — Foreign key → tmax_server.id — NOT NULL
  • svrname — VARCHAR(15) — NOT NULL
  • svrgroup_id — BIGINT — Foreign key → tmax_svrgroup.id — NOT NULL
  • svgname — VARCHAR(15) — NOT NULL
  • node_id — BIGINT — Foreign key → tmax_node.id — NOT NULL
  • nodename — VARCHAR(15) — NOT NULL
  • name — VARCHAR(31) — NOT NULL
  • business_code — CHAR(3) — Foreign key → business_code_dictionary.code
  • operation_type — CHAR(1)
  • naming_valid — BOOLEAN — NOT NULL
  • logical_name — VARCHAR(200)
  • validation — VARCHAR(10) — NOT NULL

tmax_svrgroup

  • id — BIGINT — Primary key — NOT NULL
  • source_file_id — BIGINT — Foreign key → tmax_config_file.id — NOT NULL
  • domain_id — BIGINT — Foreign key → tmax_domain.id — NOT NULL
  • node_id — BIGINT — Foreign key → tmax_node.id — NOT NULL
  • nodename — VARCHAR(15) — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • svgtype — VARCHAR(20)
  • validation — VARCHAR(10) — NOT NULL

tmax_svrgroup_relation

  • id — BIGINT — Primary key — NOT NULL
  • svrgroup_id — BIGINT — Foreign key → tmax_svrgroup.id — NOT NULL
  • relation_type — VARCHAR(10) — NOT NULL
  • target_name — VARCHAR(15) — NOT NULL
  • target_kind — VARCHAR(10)
  • target_id — BIGINT
  • idx — SMALLINT — NOT NULL