iacm
Tables (25)
alarm_event_log
- idx — INTEGER
- log — TEXT
- log_time — DATETIME
alarm_log
- idx — INTEGER
- id — TEXT
- login_time — DATETIME
card
- idx — INTEGER
- card_class — TEXT
- card_number — TEXT
- floor — TEXT
- station — TEXT
- node — TEXT
- card_name — TEXT
category_floor
- idx — INTEGER
- category_name — TEXT
- category_status — TEXT
category_station
- idx — INTEGER — NOT NULL
- major_category_idx — INTEGER
- major_category_name — TEXT
- minor_category_name — TEXT
- minor_category_id — TEXT
- category_status — TEXT
- dooropen — TEXT
- doornode — TEXT
- gateman — INTEGER
- starttime — timestamp
- endtime — timestamp
- doorcount — TEXT
- doorinterval — TEXT
- rackid — TEXT
- usedoorlock — TEXT
category_station_board
- idx — INTEGER
- floor — TEXT
- station — TEXT
- node — TEXT
- address — TEXT
- status — TEXT
- status485 — TEXT
- latency — TEXT
- name — TEXT
category_station_rack
- idx — INTEGER
- device_type — INTEGER
- major_category_idx — INTEGER
- major_category_name — TEXT
- minor_category_idx — INTEGER
- minor_category_name — TEXT
- major_category_status — TEXT
- rackid — TEXT
- rack_num — INTEGER
- device_name — INTEGER
- pos_x — INTEGER
- pos_y — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
category_station_rack_connection
- id — INTEGER
- rack_idx — INTEGER — NOT NULL
- sunbunjang_idx — INTEGER — NOT NULL
- mid_point — TEXT
- created_at — TIMESTAMP
commute_setting
- idx — INTEGER
- communication — TEXT
- commutecount — TEXT
- interval — TEXT
- mainconnect — TEXT
- retransmissioncount — varchar
faq
- id — INTEGER
- category — TEXT — NOT NULL
- intent — TEXT — NOT NULL
- base_answer — TEXT
- img_filename — TEXT
- updated_at — TEXT
faq_explain
- id — INTEGER
- faq_id — INTEGER
- corp — TEXT
- model — TEXT
- answer — TEXT
- explain_img_filename — varchar
- updated_at — TEXT
login_log
- idx — INTEGER
- id — TEXT
- login_time — DATETIME
- address — varchar
- floor — integer — NOT NULL
- station — integer — NOT NULL
- node — integer — NOT NULL
machine
- id — INTEGER
- address — varchar
- floor — integer — NOT NULL
- station — integer — NOT NULL
- node — integer — NOT NULL
member
- idx — INTEGER
- id — TEXT
- pass — TEXT
- grade — TEXT
network_setting
- idx — INTEGER
- name — TEXT
- colorcode — TEXT
port_switch
- idx — INTEGER
- port — TEXT
- baudrate — INTEGER
site_map
- idx — INTEGER
- filepath — TEXT
- major_category_idx — INTEGER
- minor_category_idx — INTEGER
- pinX — float
- pinY — float
- pin2x — float
- pin2y — float
sunbunjang
- idx — INTEGER
- major_category_idx — INTEGER
- minor_category_idx — INTEGER
- portidx — INTEGER
- rack_idx — INTEGER
- portname — INTEGER
- data1 — TEXT
- data2 — TEXT
- data3 — TEXT
- data4 — TEXT
- network — TEXT
switch_alert
- idx — INTEGER
- enable — TEXT
switch_command
- idx — INTEGER
- faq_id — INTEGER
- corp — TEXT
- model — TEXT
- cmd — TEXT
- cmd_text — TEXT
- cmd_type — TEXT
- cmdtypetext — TEXT
- client_bubble — varchar
- server_bubble — varchar
switch_connect
- idx — INTEGER
- baudrate — TEXT — NOT NULL
- corp — TEXT
- model — TEXT
- baurate — TEXT
switch_setting
- idx — INTEGER
- switch_corp — TEXT
- switch_model — TEXT
- floor — TEXT
- station — TEXT
- name — TEXT
- pos_x — TEXT
- pos_y — TEXT
- power — varchar
udp_ip
- idx — INTEGER
- address — TEXT
udp_log
- idx — INTEGER
- logdata — TEXT
- login_time — DATETIME
udp_setting
- idx — INTEGER
- interval — INTEGER
- wait — INTEGER
- warning — INTEGER
- error — INTEGER
- doorinterval — INTEGER
- rs485interval — INTEGER