Rack Flow2
Tables (17)
comm_status_type (상태 코드)
- comm_status_type — int — Primary key — NOT NULL — 1
- comm_status_type_desc — varchar(16) — NOT NULL — RUNNING
rack_center_info (렉 센터 정보)
- rack_center_id — varchar(32) — Primary key — NOT NULL — 여의도IDC
- rack_center_name — varchar(32) — rack center info
- rack_location — varchar(32) — 명동
- rack_cnt — int — 10
rack_host_comp (호스트 구성 정보)
- host_comp_id — int — Primary key — NOT NULL — 1
- host_name — varchar(32) — host_oke201
- host_location_id — varchar(8) — 42U
- host_status — varchar(16) — RUNNING
- host_total_vm_cnt — int — 99
- switch_name — int — Foreign key → rack_switch_comp.switch_comp_id — NOT NULL — switch-name-001
- resource_id — int — Foreign key → rack_switch_comp.resource_id — NOT NULL — 1
rack_host_info (호스트 정보)
- host_info_id — int — Primary key — NOT NULL — 1
- host_comp_id — int — Foreign key → rack_host_comp.host_comp_id — NOT NULL — 1
- host_name — varchar(32) — host_oke201
- host_cpu_cnt — int — 32
- host_memory_alloc — long — 64
- host_disk_alloc — long — 2048
- host_cpu_usage — long — 48
- host_memory_usage — long — 50
- host_disk_usage — long — 50
rack_host_vm_count (호스트 vm 상태 건수)
- host_vm_count_id — int — Primary key — NOT NULL — 1
- host_info_id — int — Foreign key → rack_host_info.host_info_id — NOT NULL — 1
- comm_status_type — int — Foreign key → comm_status_type.comm_status_type — NOT NULL — 1:RUNNING) 2:ERROR
- host_vm_count — int — 90
rack_host_vm_info (호스트 VM 정보)
- host_vm_info_id — int — Primary key — NOT NULL
- host_info_id — int — Foreign key → rack_host_info.host_info_id — NOT NULL — 1
- uu_id — varchar(40) — Foreign key → vt_resouce.id — NOT NULL — vt_resouce uu_id에 연결
- resource_type_id — int — Foreign key → vt_resouce.resource_type_id — NOT NULL — vt_resouce resource_type_id 연결
rack_host_vm_use (호스트 VM 사용률)
- host_vm_use_id — int — Primary key — NOT NULL — 1
- host_info_id — int — Foreign key → rack_host_info.host_info_id — NOT NULL — 1
- host_vm_cpu_usage — long — 50%
- host_vm_memroy_usage — long — 88%
- host_vm_disk_usage — long — 45%
rack_info (렉 정보)
- rack_id — varchar(32) — Primary key — NOT NULL — #rack001
- rack_center_id — varchar(32) — Foreign key → rack_center_info.rack_center_id — NOT NULL — 여의도IDC
- rack_server_cnt — int — 38
- rack_switch_cnt — int — 2
- rack_storage_cnt — int — 2
- rack_size — vvarchar(16) — 24/42U
rack_power_info (렉 전력 사용량)
- power_info_id — int — Primary key — NOT NULL — 1
- resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
- power_usage — int — 3000
- power_supply — int — 25
- fan_temperature — int — 30
rack_server_comp (렉 서버 정보)
- server_comp_id — int — Primary key — NOT NULL — 1
- resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
- server_location_id — varchar(8) — 41U
- server_comp_name — varchar(16) — server
- server_ip — varchar(32) — 192.168.0.1
- server_vm_cnt — int — 32
- server_serial_nm — varchar(16) — 0E33f232234455
rack_storage_comp (렉 스트로지 구성 정보)
- storage_id — int — Primary key — NOT NULL — 1
- resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
- storage_name — varchar(8) — vda15
- location_id — varchar(8) — 43U
- comp_name — varchar(16) — storage
- storage_status — varcahr(16) — RUNNING
rack_storage_info (렉 스토리지 정보)
- storage_info_id — int — Primary key — NOT NULL — 1
- storage_id — int — Foreign key → rack_storage_comp.storage_id — NOT NULL — 1
- storage_uuid — varchar(40) — 33764053-4441-4176-a757-e2308d53dc4c
- storage_type — varchar(16) — ext4
- storage_category — varchar(16) — ssd
- stroage_alloc_size — double — 40000
rack_switch_comp (렉 스위치 구성 정보)
- switch_comp_id — int — Primary key — NOT NULL — 1
- resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
- switch_name — varchar(32) — NOT NULL — switch-name-001
- switch_location_id — varchar(8) — 42U
- switch_comp_name — varchar(16) — switch
- switch_status — varchar(16) — RUNNING
rack_switch_info (스위치 정보)
- switch_info_id — int — Primary key — NOT NULL — 1
- switch_comp_id — int — Foreign key → rack_switch_comp.switch_comp_id — NOT NULL — 1
- switch_name — varchar(32) — switch-name-001
- switch_port_cnt — int — 48
- switch_location — varchar(32) — 1st Floor,Zone A
- switch_model_name — varchar(32) — WS-C2960S-48TS
- switch_temperature — int — 32
- switch_mac_address — varchar(32) — 0A-00-27-00-00-04
- switch_ip_address — varchar(32) — 192.168.0.1
- switch_enable_port — varchar(16) — 42/48
- switch_relate_stroage — varchar(16) — Ceph_001
- switch_status — varchar(16) — RUNNING
- switch_network_usage — double — 99GB
rack_switch_port (스위치 포트 정보)
- switch_port_id — int — Primary key — NOT NULL — 1
- switch_info_id — int — Foreign key → rack_switch_info.switch_info_id — NOT NULL — 1
- switch_port_status — varchar(16) — RUNNING
- switch_host_relate_info — varchar(32) — host-oke201
resouce_info (렉 연결 정보)
- resource_id — int — Primary key — NOT NULL — 1
- rack_center_id — varchar(32) — Foreign key → rack_center_info.rack_center_id — NOT NULL — 여의도IDC
- rack_id — varchar(32) — Foreign key → rack_info.rack_id — NOT NULL — #rack001
- resource_type_id — int — 1
- rack_status — varchar(16) — RUNNING
- uuid — varchar(512) — NULL
vt_resouce (리소스 정보)
- id — int — Primary key — NOT NULL
- resource_type_id — int — Primary key — NOT NULL
- uuid — varchar(40) — NOT NULL