3dvs
Tables (33)
TSD_ALARM_CONDITION
- ALARM_ID — varchar(20) — Primary key — NOT NULL
- THRESHOLD_IDS — varchar(256) — NOT NULL
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
TSD_ALARM_DEF
- ALARM_ID — varchar(20) — Primary key — NOT NULL
- ALARM_NAME — varchar(128)
- ALARM_TYPE — varchar(128)
- SEVERITY_CCD — varchar(10)
- ALARM_DESC — varchar(256)
- ASD_TYPE — varchar(10)
- USER_ID — varchar(20)
- USE_FLAG — char(1)
- DESCRIPTION — varchar(256)
TSD_ALARM_HIST
- MSG_ID — bigint(12) — Primary key — NOT NULL
- ALARM_ID — varchar(20)
- ALARM_DATE — datetime
- SEVERITY_CCD — varchar(10)
- ALARM_NAME — varchar(128)
- ALARM_TYPE — varchar(128)
- DEVICE_ID — varchar(20)
- ALARM_DESC — varchar(256)
- VALUE — varchar(20)
- EXTRA_VALUE — varchar(20)
- ATTACKERS — varchar(256)
- SOURCES — varchar(256)
- DESTINATIONS — varchar(256)
- CONFIRM_TYPE — char(1)
- CONFIRM_DATE — datetime
- CONFIRM_USER_ID — varchar(20)
TSD_ALARM_THRESHOLD
- THRESHOLD_ID — varchar(20) — Primary key — NOT NULL
- SEVERITY_CCD — varchar(10)
- DEVICE_TYPE — varchar(10)
- ALARM_TYPE — varchar(128)
- THRESHOLD_VAL — varchar(10)
- CONDITION_VAL — varchar(5)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
TSD_BUILDING
- CENTER_ID — varchar(20) — Primary key — NOT NULL
- DC_ID — varchar(20)
- CENTER_NAME — varchar(128)
- CENTER_NUMBER — varchar(45)
- CENTER_FLOOR — varchar(20)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_DC
- DC_ID — varchar(20) — Primary key — NOT NULL
- DC_NAME — varchar(128)
- DC_ZIPCODE — varchar(6)
- DC_ADDRESS1 — varchar(100)
- DC_ADDRESS2 — varchar(255)
- DC_LATITUDE — varchar(20)
- DC_LONGITUDE — varchar(20)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_DEPART
- DEPART_ID — varchar(20) — Primary key — NOT NULL
- DEPART_NAME — varchar(128)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_FLOW
- FLOW_ID — varchar(20) — Primary key — NOT NULL
- SOURCE_IP — varchar(64) — Primary key — NOT NULL
- SOURCE_PORT — int(11) — Primary key — NOT NULL
- DEST_IP — varchar(64) — Primary key — NOT NULL
- DEST_PORT — int(11) — Primary key — NOT NULL
- PROTOCOL — varchar(6) — Primary key — NOT NULL
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_HOST
- HOST_ID — varchar(20) — Primary key — NOT NULL
- HOST_NAME — varchar(128)
- RACK_ID — varchar(20)
- RACK_SLOT_NO — int(11)
- ZONE_ID — varchar(20)
- CPU_CORE_NUM — int(11)
- SWITCH_GW_FLAG — char(1)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_HOST_IP
- HOST_VM_ID — varchar(20) — Primary key — NOT NULL
- HOST_VM_IP — varchar(20) — Primary key — NOT NULL
- HOST_VM_IP_NAME — varchar(64)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_HOST_STORAGE
- HOST_VM_ID — varchar(20) — Primary key — NOT NULL
- HOST_MOUNT_NAME — varchar(128) — Primary key — NOT NULL
- HOST_MOUNT_SIZE — int(11)
- HOST_MOUNT_FLAG — char(1)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_HOST_STS
- HOST_ID — varchar(51) — Foreign key → TSD_HOST.HOST_ID — NOT NULL — 장치 식별자
- COLLECT_TS — varchar(50) — NOT NULL — 수집 TS
- COLLECT_DTM — datetime(3) — NOT NULL — 수집 일시
- INTERVAL_TS — varchar(50) — 수집 기간
- STATUS_CODE — char(5) — 장치 상태
- JSON_VALUE — varchar(21000)
- SAVE_DTM — datetime(3) — NOT NULL — 저장 일시
TSD_HOST_VM
- VM_ID — varchar(20) — Primary key — NOT NULL
- VM_NAME — varchar(128)
- HOST_ID — varchar(20)
- RACK_ID — varchar(20)
- RACK_SLOT_NO — int(11)
- ZONE_NAME — varchar(128)
- CPU_CORE_NUM — int(11)
- SWITCH_GW_FLAG — char(1)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_LINK
- LINK_ID — varchar(20) — Primary key — NOT NULL
- LINK_DEVICE_ID1 — varchar(20)
- LINK_PORT_ID1 — varchar(20)
- LINK_DEVICE_ID2 — varchar(20)
- LINK_PORT_ID2 — varchar(20)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_LINK_STS
- LINK_ID — varchar(125) — Foreign key → TSD_LINK.LINK_ID — NOT NULL — 링크 식별자
- COLLECT_TS — varchar(50) — NOT NULL — 수집 TS
- COLLECT_DTM — datetime(3) — NOT NULL — 수집 일시
- INTERVAL_TS — varchar(50) — 수집 기간
- IN_STATUS_CODE — char(5) — 인입 링크 상태
- OUT_STATUS_CODE — char(5) — 진출 링크 상태
- JSON_VALUE — varchar(21000)
- SAVE_DTM — datetime(3) — NOT NULL — 저장 일시
TSD_RACK
- RACK_ID — varchar(20) — Primary key — NOT NULL
- RACK_NO — varchar(20)
- RACK_NAME — varchar(128)
- RACK_MAX_SLOT — int(11)
- RACK_VFLAG — char(1)
- ZONE_ID — varchar(20)
- POS_X — int(11)
- POS_Z — int(11)
- POS_A — int(11)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
- CENTER_ID — varchar(20)
- PHYSICAL_ROW — varchar(20)
- PHYSICAL_COLUMN — varchar(20)
- PHYSICAL_RESERVED — varchar(20)
- RACK_TYPE — char(5)
TSD_RACK_STS
- RACK_ID — varchar(51) — Foreign key → TSD_RACK.RACK_ID — NOT NULL — 랙 식별자
- COLLECT_TS — varchar(50) — NOT NULL — 수집 TS
- COLLECT_DTM — datetime(3) — NOT NULL — 수집 일시
- INTERVAL_TS — varchar(50) — 수집 기간
- STATUS_CODE — char(5) — 랙 상태
- JSON_VALUE — varchar(21000)
- SAVE_DTM — datetime(3) — NOT NULL — 저장 일시
TSD_SUBNET
- SUBNET_MASK — varchar(20) — Primary key — NOT NULL
- BIT_MASK — varchar(20) — Primary key — NOT NULL
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_SVC
- SERVICE_ID — varchar(20) — Primary key — NOT NULL
- DC_ID — varchar(20)
- CENTER_ID — varchar(20)
- DEPART_ID — varchar(20)
- DEPART — varchar(128)
- SERVICE_NAME — varchar(128)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_SVC_MAPPING
- SERVICE_ID — varchar(20) — Primary key — NOT NULL
- DEVICE_ID — varchar(20) — Primary key — NOT NULL
- CENTER_ID — varchar(20) — NOT NULL
- DEPART_ID — varchar(20) — NOT NULL
- SERVICE_NAME — varchar(128)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_SWITCH
- SWITCH_ID — varchar(20) — Primary key — NOT NULL
- SWITCH_NAME — varchar(128)
- SWITCH_VENDOR — varchar(128)
- SWITCH_MODEL — varchar(128)
- SWITCH_TYPE — varchar(10)
- RACK_ID — varchar(20)
- RACK_SLOT_NO — int(11)
- CPU_CORE_NUM — int(11)
- SWITCH_GW_FLAG — char(1)
- ZONE_ID — varchar(20)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_SWITCH_IP
- SWITCH_ID — varchar(20) — Primary key — NOT NULL
- SWITCH_IP — varchar(20) — Primary key — NOT NULL
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_SWITCH_MODEL (TSD_SWITCH_TEMPLATE)
- 모델ID (MODEL_ID) — varchar(20) — Primary key — NOT NULL
- 벤더 (SWITCH_VENDOR) — varchar(20)
- 이름 (SWITCH_MODEL) — varchar(128)
- SWITCH_TYPE — varchar(20)
- 포트 수 (PORT_QUANTITY) — int(11)
- CPU_CORE_NUM — int(11)
- BACK_PANEL_IMAGE — varchar(255)
- USE_FLAG — char(1)
- DESCRIPTION — varchar(255)
- UPDATE_DATE — datetime
- USER_ID — varchar(20)
TSD_SWITCH_PORT (CopyOfTSD_SWITCH)
- SWITCH_ID — varchar(20) — Primary key — NOT NULL
- SWITCH_NAME — varchar(128)
- SWITCH_VENDOR — varchar(128)
- SWITCH_MODEL — varchar(128)
- SWITCH_TYPE — varchar(10)
- RACK_ID — varchar(20)
- RACK_SLOT_NO — int(11)
- CPU_CORE_NUM — int(11)
- SWITCH_GW_FLAG — char(1)
- ZONE_ID — varchar(20)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_SWITCH_STS
- SWITCH_ID — varchar(51) — Foreign key → TSD_SWITCH.SWITCH_ID — NOT NULL — 장치 식별자
- COLLECT_TS — varchar(50) — NOT NULL — 수집 TS
- COLLECT_DTM — datetime(3) — NOT NULL — 수집 일시
- INTERVAL_TS — varchar(50) — 수집 기간
- STATUS_CODE — char(5) — 장치 상태
- JSON_VALUE — varchar(21000)
- SAVE_DTM — datetime(3) — NOT NULL — 저장 일시
TSD_UNKNOWN_HOST
- UNKNOWN_IP — varchar(64) — Primary key — NOT NULL
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
TSD_USER
- ID — varchar(20) — Primary key — NOT NULL
- USER_ID — varchar(255)
- USER_NAME — varchar(255)
- PASSWORD_HASH — varchar(255)
- USER_TYPE — char(5)
- UPDATE_DATE — datetime
- DEPART_ID — varchar(255)
TSD_ZONE
- ZONE_ID — varchar(20) — Primary key — NOT NULL
- ZONE_NAME — varchar(128)
- USE_FLAG — char(1)
- USER_ID — varchar(20)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(256)
T_SYS_CODE
- SYS_CODE — char(5) — Primary key — NOT NULL — 코드
- SYS_CODE_TYPE — char(2) — NOT NULL — 시스템 유형 코드
- SYS_INT_VALUE — bigint(20) — 코드 정수값
- SYS_NAME — varchar(100) — NOT NULL — 기본 코드 이름
- SYS_NOTE — varchar(100) — 코드 설명
- DISPLAY_ORDER — int(10) — NOT NULL — 화면 정렬 순서
T_SYS_CODE_TYPE
- SYS_CODE_TYPE — char(2) — Primary key — NOT NULL — 시스템 코드 유형
- SYS_TYPE_NAME — varchar(20) — 시스템 유형 이름
- SYS_TYPE_NOTE — varchar(100) — 시스템 유형 설명
T_SYS_CONFIG
- CONFIG_KEY — varchar(20) — Primary key — NOT NULL — 설정 키
- CONFIG_VALUE — varchar(2000) — NOT NULL — 설정 값
- CONFIG_NOTE — varchar(100) — 설정 설명
- SAVE_UID — char(31) — NOT NULL — 저장자
- SAVE_DTM — datetime — NOT NULL — 저장일시
T_TP_STS
- UID — varchar(50) — Primary key — NOT NULL
- COLLECT_TS — varchar(50) — NOT NULL — 수집 TS
- COLLECT_DTM — datetime — NOT NULL — 수집 일시
- INTERVAL_TS — varchar(50) — 수집 기간
- JSON_VALUE — varchar(21000) — NOT NULL
- SAVE_DTM — datetime — NOT NULL — 저장 일시
포트매핑 (포트매핑템플릿)
- 모델ID (MODEL_ID) — varchar(20) — Primary key — NOT NULL
- 매핑ID (Key) — Primary key — NOT NULL
- 인덱스 (Key2) — Primary key — NOT NULL
- 이름 (SWITCH_MODEL) — varchar(128)