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)