ㅇㅇㅇㅇ
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