dddd
Tables (50)
channel_status
- stat_code — int(11) — Primary key — NOT NULL
- stat_name — varchar(45) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
clients_log
- client_id — bigint(20) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- grp_serial — int(11) — NOT NULL
- user_serial — int(11) — NOT NULL
- client_user — varchar(45) — NOT NULL
- client_type — int(11) — NOT NULL
- client_addr — varchar(128) — NOT NULL
- client_login — varchar(45) — NOT NULL
- client_port — varchar(45) — NOT NULL
- login_time — datetime(3) — NOT NULL
- logout_time — datetime(3)
common_code
- code_id — int(11) — Primary key — NOT NULL
- code_group — varchar(45) — NOT NULL
- code_value — varchar(128) — NOT NULL
- code_name — varchar(128) — NOT NULL
- code_desc — varchar(128)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device
- dev_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- grp_serial — int(11) — NOT NULL
- dev_serial — int(11) — NOT NULL
- dev_name — varchar(1024)
- dev_opmode — int(11) — NOT NULL
- dev_comment — text
- dev_stat — int(11) — NOT NULL
- dev_type — int(11) — NOT NULL
- model_id — int(11) — Foreign key → device_model.model_id — NOT NULL
- dev_addr — varchar(45)
- dev_wport — int(11) — NOT NULL
- dev_user — varchar(1024)
- dev_pass — varchar(1024)
- dev_channel — int(11) — NOT NULL
- dev_media — int(11) — NOT NULL
- dev_property — text
- dev_version — varchar(64)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
- dev_custom_property — text
device_channel
- dch_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — Foreign key → device.vms_id — NOT NULL
- dev_serial — int(11) — Foreign key → device.dev_serial — NOT NULL
- dch_ch — int(11) — NOT NULL
- dch_type — int(11) — NOT NULL
- dch_name — varchar(1024)
- dch_media — int(11) — NOT NULL
- dch_defstrm — int(11) — NOT NULL
- dch_defrec — int(11) — NOT NULL
- dch_rec_sched — varchar(1024)
- dch_val1 — text
- dch_val2 — text
- dch_val3 — text
- dch_save_day — int(11)
- dch_opmode — int(11)
- dch_comment — text
- dch_rec_size — bigint(20)
- dch_property — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device_group
- dev_grp_serial — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- grp_serial — int(11) — NOT NULL
- grp_name — varchar(45) — NOT NULL
- dev_grp_desc — varchar(256)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device_group_item
- id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — Foreign key → device_channel.vms_id — NOT NULL
- grp_serial — int(11) — NOT NULL
- dev_grp_serial — int(11) — Foreign key → device_group.dev_grp_serial — NOT NULL
- dev_serial — int(11) — Foreign key → device_channel.dev_serial — NOT NULL
- dch_ch — int(11) — Foreign key → device_channel.dch_ch — NOT NULL
- dev_ch_serial — varchar(45) — NOT NULL
- dev_grp_name — varchar(128)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device_media
- dchm_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — Foreign key → device_channel.vms_id — NOT NULL
- dev_serial — int(11) — Foreign key → device_channel.dev_serial — NOT NULL
- dch_ch — int(11) — Foreign key → device_channel.dch_ch — NOT NULL
- dchm_serial — int(11) — NOT NULL
- media_type — int(11) — Foreign key → media_type.media_type — NOT NULL
- dchm_stat — int(11) — NOT NULL
- dchm_url — varchar(1024) — NOT NULL
- dchm_port — int(11) — NOT NULL
- dchm_codec — varchar(128) — NOT NULL
- dchm_width — int(11) — NOT NULL
- dchm_height — int(11) — NOT NULL
- dchm_desc — varchar(64) — NOT NULL
- dchm_property — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device_model
- model_id — int(11) — Primary key — NOT NULL
- model_name — varchar(64) — NOT NULL
- model_driver — varchar(128) — NOT NULL
- model_version — varchar(50) — NOT NULL
- model_property — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device_model_company
- model_id — int(11) — Primary key — NOT NULL
- model_name — varchar(64) — NOT NULL
- model_driver — varchar(128) — NOT NULL
- company — varchar(64)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device_model_server
- srv_serial — int(11) — Primary key — NOT NULL
- model_id — int(11) — Primary key — NOT NULL
- model_name — varchar(64) — NOT NULL
- model_driver — varchar(128) — NOT NULL
- model_version — varchar(50) — NOT NULL
- model_property — text — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
device_recording
- dch_id — int(11) — Foreign key → device_channel.dch_id — NOT NULL
- srv_id — int(11) — Foreign key → servers.srv_id — NOT NULL
- rec_method — int(11)
- rec_strm — int(11)
- rec_stat — int(11) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
dist_engine
- engine_name — varchar(50) — Primary key — NOT NULL
- engine_type — int(11) — NOT NULL
- engine_host — varchar(64) — NOT NULL
- engine_port — int(11) — NOT NULL
- engine_user — varchar(1024)
- engine_pass — varchar(1024)
- engine_db — varchar(64) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
emap_image
- img_id — int(11) — Primary key — NOT NULL
- map_id — int(11) — Foreign key → emap_manager.map_id — NOT NULL
- img_type — tinyint(1) — NOT NULL
- inner_filename — varchar(128)
- original_filename — varchar(128)
- img_path — varchar(128)
- img_size — int(11)
- img_version — int(11) — NOT NULL
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
emap_item
- item_id — int(11) — Primary key — NOT NULL
- map_id — int(11) — Foreign key → emap_manager.map_id — NOT NULL
- dev_serial — int(11)
- dch_id — int(11)
- item_type — int(11)
- item_property — mediumtext — NOT NULL
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
emap_link_map
- link_id — int(11) — Primary key — NOT NULL
- item_id — int(11) — Foreign key → emap_item.item_id — NOT NULL
- map_id — int(11) — Foreign key → emap_manager.map_id — NOT NULL
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
emap_manager
- map_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- grp_serial — int(11) — NOT NULL
- node_serial — int(11) — Foreign key → emap_node.node_serial — NOT NULL
- map_type — tinyint(1) — NOT NULL
- map_name — varchar(128) — NOT NULL
- map_desc — varchar(1024)
- thumbnail_path — varchar(128)
- map_document — mediumtext
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
- mod_user_serial — int(11)
- mod_user_name — varchar(45)
- is_editing — tinyint(1) — NOT NULL
- edit_user_serial — int(11)
- edit_user_id — varchar(45)
- edit_user_ip — char(15)
emap_node
- node_serial — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- grp_serial — int(11) — NOT NULL
- node_type — int(11)
- node_name — varchar(128) — NOT NULL
- node_parent — int(11) — NOT NULL
- node_property — mediumtext
- orderBy — int(11) — NOT NULL
- depth_level — int(11) — NOT NULL
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
event_code
- evt_code — int(11) — Primary key — NOT NULL
- evt_name — varchar(128) — NOT NULL
- evt_subcodes — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
event_data_class
- data_type — int(11) — NOT NULL
- name — varchar(128)
- data_value — varchar(4096)
event_list
- list_key — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- dev_serial — int(11) — NOT NULL
- dch_ch — int(11) — NOT NULL
- src_type — int(11) — NOT NULL
- rule_key — int(11) — Foreign key → event_rule.rule_key — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
event_rule
- rule_key — int(11) — Primary key — NOT NULL
- rule_cond — text — NOT NULL
- rule_acts — text — NOT NULL
- vms_id — int(11) — Foreign key → tree_user.vms_id — NOT NULL
- grp_serial — int(11) — Foreign key → tree_user.grp_serial — NOT NULL
- user_serial — int(11) — Foreign key → tree_user.user_serial — NOT NULL
- rule_name — varchar(512)
- rule_desc — varchar(512)
- approval — varchar(128)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
event_rule_ref
- ref_key — int(11) — Primary key — NOT NULL
- rule_key — int(11) — Foreign key → event_rule.rule_key — NOT NULL
- rule_type — int(11) — NOT NULL
- rule_src — int(11) — NOT NULL
- vms_id — int(11)
- grp_serial — int(11)
- user_serial — int(11)
- dev_serial — int(11)
- dch_ch — int(11)
- srv_serial — int(11)
- src_type — int(11)
- ref_desc — varchar(512)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
event_type_code
- vurix_code — int(11) — Primary key — NOT NULL
- event_code — varchar(64) — Primary key — NOT NULL
- id — int(11) — NOT NULL
- tybis_code — int(11) — NOT NULL
- description — varchar(128)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
event_type_list
- id — int(11) — Primary key — NOT NULL
- dch_type — int(11) — Primary key — NOT NULL
- val_name — varchar(64) — Primary key — NOT NULL
- description — varchar(128)
- val_type — varchar(32)
- val_list — varchar(128)
- is_array — int(11) — NOT NULL
- op_list — varchar(128)
- parent_id — int(11) — NOT NULL
- property — varchar(128)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
lang_info
- lang_id — int(11) — Primary key — NOT NULL
- lang_group — varchar(50) — NOT NULL
- lang_code — char(2) — NOT NULL
- lang_item — varchar(50) — NOT NULL
- lang_value — varchar(64) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
media_type
- media_type — int(11) — Primary key — NOT NULL
- media_name — varchar(45) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
node_item
- vms_id — int(11) — Foreign key → tree_node.vms_id — NOT NULL
- dev_serial — int(11) — Foreign key → device.dev_serial — NOT NULL
- grp_serial — int(11) — Foreign key → tree_node.grp_serial — NOT NULL
- user_serial — int(11) — Foreign key → tree_node.user_serial — NOT NULL
- ctx_serial — int(11) — Foreign key → tree_node.ctx_serial — NOT NULL
- node_serial — int(11) — Foreign key → tree_node.node_serial — NOT NULL
- node_type — int(11) — Foreign key → tree_node.node_type — NOT NULL
- nitem_nick — varchar(1024)
- nitem_index — int(11) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
pcs_car_info
- idx — int(11) — Primary key — NOT NULL
- car_num — varchar(128) — 차량 번호 전체(파싱용)
- car_num1 — varchar(50) — 지역명(지역별 선택일 경우)
- car_num2 — tinyint(4) — 숫자 2자리(최대 99이므로 tinyint 타입)
- car_num3 — varchar(50) — 가~하, 한글 1자리
- car_num4 — smallint(6) — 숫자 4자리
- visit_reason — tinyint(4) — 방문 목적(0:none, 1:입주, 2:방문, 3:특수, 4:문제)
- name — varchar(128) — 차주 이름
- contact — varchar(128) — 연락처
- description — varchar(1024) — 설명
- allow_entry — varchar(256) — 진입 허가
- image_path — varchar(1024) — 이미지경로
- register_time — datetime — NOT NULL — 등록 시간
- modify_time — datetime — NOT NULL — 수정 시간
portforwarding_group
- pfg_id — int(11) — Primary key — NOT NULL
- pfg_group — int(11) — NOT NULL
- pfg_ref — int(11) — NOT NULL
- vms_id — int(11) — Foreign key → servers.vms_id — NOT NULL
- srv_serial — int(11) — Foreign key → servers.srv_serial — NOT NULL
- pfg_addr — varchar(45)
- pfg_port — int(11) — NOT NULL
- pfg_desc — varchar(128)
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
portforwarding_rule
- pfr_id — int(11) — Primary key — NOT NULL
- pfg_group — int(11) — Foreign key → portforwarding_group.pfg_group — NOT NULL
- vms_id — int(11) — NOT NULL
- srv_serial — int(11) — NOT NULL
- pfr_addr — varchar(45)
- pfr_port — int(11) — NOT NULL
- pfr_desc — varchar(128) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
process_manager
- process_name — varchar(128) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- srv_serial — int(11) — NOT NULL
- value1 — varchar(128)
- value2 — varchar(128)
- value3 — varchar(128)
- state — varchar(32)
- process_start_time — datetime(3) — NOT NULL
- process_end_time — datetime(3) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
ptz_touring_device
- ptz_device_index — int(11) — Primary key — NOT NULL
- vms_id — int(11) — Foreign key → device_channel.vms_id — NOT NULL
- dev_serial — int(11) — Foreign key → device_channel.dev_serial — NOT NULL
- dch_ch — int(11) — Foreign key → device_channel.dch_ch — NOT NULL
- group_id — int(11) — Foreign key → ptz_touring_group.group_id — NOT NULL
- dev_name — varchar(50) — NOT NULL
- scenario — text — NOT NULL
- ptz_device_property — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
ptz_touring_group
- group_id — int(11) — Primary key — NOT NULL
- group_name — varchar(50)
- vms_id — int(11) — Foreign key → tree_user.vms_id — NOT NULL
- grp_serial — int(11) — Foreign key → tree_user.grp_serial — NOT NULL
- user_serial — int(11) — Foreign key → tree_user.user_serial — NOT NULL
- touring_status — int(11) — NOT NULL
- touring_sched — text — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
rtsp_deny
- dev_serial — int(11) — NOT NULL
- vms_id — int(11) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
rtsp_list
- rtsp_addr — varchar(45) — NOT NULL
- vms_id — int(11) — NOT NULL
- dev_serial — int(11) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
server_config
- conf_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- srv_serial — int(11) — NOT NULL
- conf_group — varchar(45) — NOT NULL
- conf_item — varchar(45) — NOT NULL
- conf_name — varchar(45) — NOT NULL
- conf_value — varchar(8192) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
server_failover
- hist_id — int(11) — Foreign key → server_failover_history.hist_id — NOT NULL
- from_srv_id — int(11) — NOT NULL
- to_srv_id — int(11) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
server_failover_history
- hist_id — int(11) — Primary key — NOT NULL
- fo_active — int(11) — NOT NULL
- fo_type — int(11) — NOT NULL
- from_srv_id — int(11) — NOT NULL
- from_srv_serial — int(11) — NOT NULL
- to_srv_id — int(11) — NOT NULL
- to_srv_serial — int(11) — NOT NULL
- vms_id — int(11) — NOT NULL
- srv_serial — int(11) — NOT NULL
- grp_serial — int(11) — NOT NULL
- user_serial — int(11) — NOT NULL
- fo_desc — varchar(2048) — NOT NULL
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
server_type
- srv_type — int(11) — Primary key — NOT NULL
- srv_type_name — varchar(45) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
servers
- srv_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- srv_serial — int(11) — NOT NULL
- srv_name — varchar(45) — NOT NULL
- srv_type — int(11) — Foreign key → server_type.srv_type — NOT NULL
- srv_addr — varchar(128)
- srv_login_addr — varchar(45)
- srv_login_port — int(11)
- srv_svc_addr — varchar(50)
- srv_svc_port — int(11) — NOT NULL
- srv_stat — int(11) — NOT NULL
- srv_property — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
tree_group
- grp_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — NOT NULL
- grp_serial — int(11) — NOT NULL
- grp_name — varchar(45) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
tree_node
- node_serial — int(11) — Primary key — NOT NULL
- node_type — int(11) — Primary key — NOT NULL
- vms_id — int(11) — Foreign key → user_context.vms_id — NOT NULL
- grp_serial — int(11) — Foreign key → user_context.grp_serial — NOT NULL
- user_serial — int(11) — Foreign key → user_context.user_serial — NOT NULL
- ctx_serial — int(11) — Foreign key → user_context.ctx_serial — NOT NULL
- node_name — varchar(45)
- node_parent — int(11) — NOT NULL
- node_property — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
tree_user
- user_idx — int(11) — Primary key — NOT NULL
- vms_id — int(11) — Foreign key → tree_group.vms_id — NOT NULL
- grp_serial — int(11) — Foreign key → tree_group.grp_serial — NOT NULL
- user_serial — int(11) — NOT NULL
- user_id — varchar(45) — NOT NULL
- user_name — varchar(45) — NOT NULL
- user_pass — varchar(128)
- user_property — text
- user_sched — text
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
trouble_car
- idx — int(11) — Primary key — NOT NULL
- car_num — varchar(128) — 차량 번호 전체(파싱용)
- car_num1 — varchar(50) — 지역명(지역별 선택일 경우)
- car_num2 — tinyint(4) — 숫자 2자리(최대 99이므로 tinyint 타입)
- car_num3 — varchar(50) — 가~하, 한글 1자리
- car_num4 — smallint(6) — 숫자 4자리
- type — tinyint(4) — 문제 코드
- description — varchar(512) — 설명
- ins_time — datetime — NOT NULL — 등록 시간
- mod_time — datetime — NOT NULL — 수정 시간
trouble_car_type
- type_id — int(11) — Primary key — NOT NULL
- type_name — varchar(1024) — NOT NULL
- ins_time — datetime(3) — NOT NULL
- mod_time — datetime(3) — NOT NULL
user_context
- ctx_id — int(11) — Primary key — NOT NULL
- vms_id — int(11) — Foreign key → tree_user.vms_id
- grp_serial — int(11) — Foreign key → tree_user.grp_serial
- user_serial — int(11) — Foreign key → tree_user.user_serial — NOT NULL
- ctx_serial — int(11)
- ctx_desc — varchar(128)
- ins_time — datetime(3)
- mod_time — datetime(3)
version
- version — int(11) — Primary key — NOT NULL
- description — varchar(8192)
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
vfs_arch_info
- arch_id — int(11) — Primary key — NOT NULL
- path_type — int(11) — NOT NULL
- relative_path — varchar(256) — NOT NULL
- host — varchar(256)
- port — int(11)
- save_day — int(11) — NOT NULL
- keep_day — int(11)
- timeout — int(11) — NOT NULL
- user_name — varchar(256)
- pass — varchar(256)
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL
vfs_retrieve_device
- device_id — int(11) — Primary key — NOT NULL
- ref_info_id — int(11) — NOT NULL
- vms_id — int(11) — NOT NULL
- dev_serial — int(11) — NOT NULL
- dch_ch — int(11) — NOT NULL
- req_start — bigint(20) — NOT NULL
- req_end — bigint(20) — NOT NULL
- status — int(11) — NOT NULL
- ins_time — datetime — NOT NULL
- mod_time — datetime — NOT NULL