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)