FISS_V2.0_hashtag

Tables (31)

Core (코어)

  • id (Key) — Primary key — NOT NULL
  • track_id (Key2) — Foreign key → Track.id — NOT NULL
  • (Key22) — Foreign key → Track.start_facility_no — NOT NULL
  • (Key3) — Foreign key → Track.end_facility_no — NOT NULL
  • core_name (1) — NOT NULL — 코어 명
  • core_status (2) — 뭔지모름
  • track_standard (Field) — NOT NULL

HashTag (해시태그)

  • id (Key) — Type — Primary key
  • Field2
  • Field4

HashTagMapping (해시태그/오브젝트(시설물/선로) 매핑)

  • id (Key) — Primary key — NOT NULL
  • hash_tag_id (Key2) — BITINT — Foreign key → HashTag.id — NOT NULL
  • target_object_id (Field) — BITINT — NOT NULL
  • target_object_type (Field2) — VARCHAR(255) — NOT NULL

Track (선로)

  • id (Key) — Primary key — NOT NULL
  • start_facility_no (Key2) — Foreign key → facility.id — NOT NULL
  • end_facility_no (Key3) — Foreign key → facility.id — NOT NULL
  • track_length (1) — varchar(255) — NOT NULL
  • track_location (2) — NOT NULL — 지중/가공
  • track_type (3) — NOT NULL — 선로 종류
  • track_standard (4) — 코어 갯수
  • track_geometry (Field4) — NOT NULL
  • track_etc (Field5)
  • business_no (Field6)

TrackFacilityConn (코어 연결 정보)

  • id (Key) — Primary key — NOT NULL
  • facility_no (Key2) — Foreign key → facility.id — NOT NULL — 시설물 id
  • start_core_no (1) — NOT NULL — 코어 연결 첫번째 선택 선로의 코어
  • start_core_rt_info (2) — NOT NULL — 코어 연결 첫번째 선택 선로의 코어의 rt
  • start_track_no (3) — NOT NULL — 코어 연결 첫번째 선택 선로
  • facility_no (4) — NOT NULL
  • end_core_no (5) — NOT NULL — 코어 연결 두번째 선택 선로의 코어
  • end_core_rt_info (6) — NOT NULL — 코어 연결 두번째 선택 선로의 코어의 rt
  • end_track_no (7) — NOT NULL — 코어 연결 두번째 선택 선로
  • node_no (8) — NOT NULL — 노드 시설물 id
  • ring_no (9) — 링 id

UserHashTagMapping (사용자 해시태그 매핑)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key — NOT NULL
  • hash_tag_id (Key3) — Foreign key → HashTag.id — NOT NULL
  • created_date (Field) — NOT NULL
  • modified_date (Field2) — NOT NULL

Users (사용자)

  • user_no (modified_date) — init_login_yn — Primary key — NOT NULL
  • Field
  • Field2

core_memo (코어 메모)

  • id (Key4) — Primary key — NOT NULL
  • core_id (Key) — Foreign key → Core.id — NOT NULL
  • track_id (Key2) — Foreign key → Core.track_id — NOT NULL
  • (Key22) — Foreign key → Core.Key22 — NOT NULL
  • (Key3) — Foreign key → Core.Key3 — NOT NULL
  • content (Field) — NOT NULL

device_lldp_oid (장비 OID)

  • id (Key) — Primary key — NOT NULL
  • device_id (Key2) — Foreign key → nms_device.id — NOT NULL
  • chassisIdOid (Field)
  • remotePortIdOid (Field2)
  • remotePortDescOid (Field3)
  • remoteSystemNameOid (Field4)
  • remoteManageAddrOid (Field5)

device_lldp_port (스위치 장비 포트별 lldp oid)

  • id (Key) — Primary key — NOT NULL
  • device_id (Key2) — Foreign key → nms_device.id — NOT NULL
  • local_port_oid (Field2)
  • remote_port_oid (Field3)
  • remote_ip_oid (Field4)

device_port (스위치 장비 포트별 snmp oid)

  • id (Key2) — Primary key — NOT NULL
  • port (Key3) — Primary key — NOT NULL
  • device_id (Key) — Foreign key → nms_device.id — NOT NULL
  • if_admin_status_oid (Field)
  • if_oper_status_oid (Field2)
  • port_type (Field3)

error_alarm_setting (장애알림설정)

  • id (Key) — Primary key — NOT NULL
  • display_type (Field)
  • alarm_delay_time(minute) (Field2)
  • rollup_hash_tag_id (Field3)
  • dual_rollup_hash_tag_id (Field4)
  • is_dual_rollup_all (Field5)
  • is_rollup_all (Field6)

facility (시설물)

  • id (Key) — Primary key — NOT NULL
  • facility_geometry (1) — NOT NULL — geo 포인트 객체
  • lat (2) — NOT NULL
  • lon (3) — NOT NULL — 경도
  • manage_no (4) — NOT NULL — fiss 상에서 실질적으로 쓰이는 시설물 명
  • business_no (5) — 비지니스 번호
  • nms_info_no (6) — 최초 설계시에 한 시설물에 하나의 스위치만 등록 가능하게 설계 되어서 만들어진 것 같음\
  • manage_name (7)
  • facility_nm (8) — NOT NULL
  • favorite_no (9) — BIGINT — 즐겨찾기 번호 같은데 테이블이 따로 있음
  • computerize_no (Field10)
  • content (Field11)
  • ip_no (Field12)
  • make_company (Field13)
  • main_poll_share_yn (Field14)
  • main_facility_no (Field18)
  • item_type (Field15)
  • drawing_id (Field16)
  • file (Field17)
  • lotno_addr (지번주소)

lldp_info (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • nms_info_id (Key2) — Foreign key → nmsinfo.id — NOT NULL
  • device_id (Key22) — Foreign key → nmsinfo.device_id — NOT NULL
  • facility_id (Key3) — Foreign key → nmsinfo.facility_id — NOT NULL
  • port (Field5)
  • local_port (Field)
  • chassis_id (Field4)
  • remote_port (Field2)
  • remote_ip(management_address) (Field3)
  • remote_facility_id (Key4) — Foreign key → facility.id — NOT NULL

nms_device (스위치 장비 정보)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • manufacturer (Field2)
  • name_oid (Field3)
  • device_port_polling (Field4)
  • device_port_trap (Field5)

nms_device_snmp_default_value (스위치 장비 snmp 버전 별 기본값)

  • id (Key) — Primary key — NOT NULL
  • device_id (Key2) — Foreign key → nms_device.id — NOT NULL
  • user_name (Field3)
  • security_level (Field4)
  • auth_protocol (Field5)
  • auth_password (Field6)
  • privacy_protocol (Field7)
  • privacy_password (Field8)
  • read_community (Field9)
  • write_community (Field10)

nms_error_info (nms 장애)

  • id (Key) — Primary key — NOT NULL
  • nms_error_type_id (Key2) — Foreign key → nms_error_type.id — NOT NULL
  • nms_info_id (Key3) — Foreign key → nmsinfo.id — NOT NULL
  • device_id (Key22) — Foreign key → nmsinfo.device_id — NOT NULL
  • facility_id (Key32) — Foreign key → nmsinfo.facility_id — NOT NULL
  • Field

nms_error_type (장애 종류)

  • id (Key) — Primary key — NOT NULL
  • code (Field2) — NOT NULL
  • name (Field6) — NOT NULL
  • description (Field) — NOT NULL
  • endabled (Field3) — NOT NULL
  • created_date (Field4) — NOT NULL
  • modified_date (Field5) — NOT NULL

nmsinfo (시설물 스위치 장비)

  • id (Key) — Primary key — NOT NULL
  • device_id (Key2) — Foreign key → nms_device.id — NOT NULL
  • facility_id (Key3) — Foreign key → facility.id — NOT NULL
  • switch_ip (Field)
  • switch_name (Field2)
  • polling (Field3)
  • is_connected (Field4)
  • snmp_version (Field5)

notification_setting (유저 장애 알림 설정)

  • id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • sound_enabled (Field2)
  • popup_enabled (Field3)
  • created_date (Field4)
  • modified_date (Field5)

notification_sound (장애 알림 사운드 종류)

  • id (Key) — Primary key — NOT NULL
  • notification_setting_id (Key2) — Foreign key → notification_setting.id — NOT NULL
  • file_name (Field3) — NOT NULL
  • file_path (Field4) — NOT NULL
  • enabled (Field5) — NOT NULL
  • created_date (Field) — NOT NULL
  • modified_date (Field2) — NOT NULL

notification_type_setting (유저 장애 알림 이벤트)

  • id (Key2) — Primary key — NOT NULL
  • notification_setting_id (Key) — Foreign key → notification_setting.id — NOT NULL
  • nms_error_type_id (Key3) — Foreign key → nms_error_type.id — NOT NULL
  • enabled (Field2) — NOT NULL
  • created_date (Field3) — NOT NULL
  • modified_date (Field4) — NOT NULL

ptopConnect (PtoP 연결 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • node_id (Field) — BIGINT — NOT NULL
  • track_id (Field2) — BIGINT — NOT NULL
  • core_id (Field4) — NOT NULL
  • connect (Field3) — TEXT — NOT NULL

ptopConnectAlias (PtoP 연결 별칭)

  • id (Key2) — BIGINT — Primary key — NOT NULL
  • ptop_connect_id (Key) — BIGINT — Foreign key → ptopConnect.id — NOT NULL
  • alias (Field) — VARCHAR(255) — NOT NULL

ptopConnectMapping (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • track_facility_conn_id (Key4) — Foreign key → TrackFacilityConn.id — NOT NULL
  • facility_no (Key22) — Foreign key → TrackFacilityConn.facility_no — NOT NULL — 시설물 id
  • ptop_connect_id (Key2) — BIGINT — Foreign key → ptopConnect.id — NOT NULL

snmp_v2_configuration (Untitled3)

  • id (Key4) — Primary key — NOT NULL
  • nms_info_id (Key) — Foreign key → nmsinfo.id — NOT NULL
  • device_id (Key2) — Foreign key → nmsinfo.device_id — NOT NULL
  • facility_id (Key3) — Foreign key → nmsinfo.facility_id — NOT NULL
  • read_community (Field)
  • write_community (Field2)

snmp_v3_configuration (Untitled2)

  • id (Key4) — Primary key — NOT NULL
  • nms_info_id (Key) — Foreign key → nmsinfo.id — NOT NULL
  • device_id (Key2) — Foreign key → nmsinfo.device_id — NOT NULL
  • facility_id (Key3) — Foreign key → nmsinfo.facility_id — NOT NULL
  • user_name (Field)
  • security_level (Field2)
  • auth_protocol (Field3)
  • auth_password (Field4)
  • privacy_protocol (Field5)
  • privacy_password (Field6)

splitter (스플리터)

  • id (Key) — Primary key — NOT NULL
  • core_id (들어오는 core id) — NOT NULL
  • facility_id (시설물 id) — NOT NULL
  • split_size (스플리터 사이즈) — NOT NULL
  • track_id (선로 id) — NOT NULL

splitter_port (스플리터 포트 정보)

  • id (Key2) — Primary key — NOT NULL
  • splitter_id (Key) — Foreign key → splitter.id — NOT NULL
  • port_number (Field2)
  • core_id (Field3)

switch_memo (시설물 스위치 장비 메모)

  • id (Key) — Primary key — NOT NULL
  • switch_device_id (Field) — NOT NULL
  • content (Field2) — NOT NULL
  • created_date (Field3) — NOT NULL
  • modified_date (Field4) — NOT NULL

switch_port (시설물 스위치 장비 포트 연결 정보)

  • id (Key) — Primary key — NOT NULL
  • nms_info_id (Key2) — Foreign key → nmsinfo.id — NOT NULL
  • device_id (Key22) — Foreign key → nmsinfo.device_id — NOT NULL
  • facility_id (Key3) — Foreign key → nmsinfo.facility_id — NOT NULL
  • port (Field)
  • is_connected_port (Field2)
  • is_monitoring_port (Field3)