test
Tables (22)
tbl_attribute_code
- attribute_key — VARCHAR(50) — Primary key — NOT NULL
- object_type — VARCHAR(20) — NOT NULL
- attribute_name — VARCHAR(100) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
tbl_attribute_value_code
- value_code — VARCHAR(50) — Primary key — NOT NULL
- attribute_key — VARCHAR(50) — Foreign key → tbl_attribute_code.attribute_key — NOT NULL
- value_name — VARCHAR(100) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
tbl_batch_execution_history
- batch_id — BIGINT — Primary key — NOT NULL
- batch_name — VARCHAR(100) — NOT NULL
- target_date — DATE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- processed_count — INT
- error_summary — VARCHAR(500)
- trace_id — VARCHAR(50)
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
tbl_data_export_log
- export_id — BIGINT — Primary key — NOT NULL
- requested_by — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- search_condition — JSON
- file_name — VARCHAR(200) — NOT NULL
- file_format — VARCHAR(10) — NOT NULL
- record_count — INT
- exported_at — DATETIME — NOT NULL
tbl_device
- device_id — BIGINT — Primary key — NOT NULL
- sequence_number — VARCHAR(50) — NOT NULL
- site_id — BIGINT — Foreign key → tbl_site.site_id
- install_location — VARCHAR(200) — NOT NULL
- detail_location — VARCHAR(200)
- ip — VARCHAR(45) — NOT NULL
- port — INT — NOT NULL
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- is_active — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- created_by — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- updated_by — BIGINT — Foreign key → tbl_user.user_id
tbl_device_detail
- device_detail_id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → tbl_device.device_id — NOT NULL
- device_name — VARCHAR(100) — NOT NULL
- device_type — VARCHAR(30) — NOT NULL
- ip — VARCHAR(45)
- port — INT
- device_status — VARCHAR(20) — NOT NULL
tbl_device_fault_action
- fault_action_id — BIGINT — Primary key — NOT NULL
- fault_log_id — BIGINT — Foreign key → tbl_device_fault_log.fault_log_id — NOT NULL
- action_status — VARCHAR(20) — NOT NULL
- actor — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- action_content — VARCHAR(500)
- action_at — DATETIME — NOT NULL
tbl_device_fault_log
- fault_log_id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → tbl_device.device_id — NOT NULL
- fault_level — VARCHAR(20) — NOT NULL
- fault_status — VARCHAR(20) — NOT NULL
- fault_content — VARCHAR(500)
- occurred_at — DATETIME — NOT NULL
- recovered_at — DATETIME
tbl_event
- event_id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → tbl_device.device_id — NOT NULL
- event_type_id — BIGINT — Foreign key → tbl_event_type_code.event_type_id — NOT NULL
- risk_level — VARCHAR(20)
- confidence_score — DECIMAL(5,2)
- occurred_location — VARCHAR(200)
- occurred_at — DATETIME — NOT NULL
- ended_at — DATETIME
- image1_file_name — VARCHAR(200)
- image2_file_name — VARCHAR(200)
- event_status — VARCHAR(20) — NOT NULL
- verification_status — VARCHAR(20)
- created_at — DATETIME — NOT NULL
tbl_event_log
- event_log_id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → tbl_event.event_id — NOT NULL
- device_id — BIGINT — Foreign key → tbl_device.device_id
- process_type — VARCHAR(30) — NOT NULL
- process_method — VARCHAR(50)
- processed_by — BIGINT — Foreign key → tbl_user.user_id
- processed_at — DATETIME — NOT NULL
tbl_event_object
- object_id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → tbl_event.event_id — NOT NULL
- object_type — VARCHAR(20) — NOT NULL
- confidence_score — DECIMAL(5,2)
- detected_at — DATETIME — NOT NULL
tbl_event_object_attribute
- attribute_id — BIGINT — Primary key — NOT NULL
- object_id — BIGINT — Foreign key → tbl_event_object.object_id — NOT NULL
- attribute_key — VARCHAR(50) — Foreign key → tbl_attribute_value_code.attribute_key — NOT NULL
- attribute_value — VARCHAR(50) — Foreign key → tbl_attribute_value_code.value_code — NOT NULL
- raw_value — VARCHAR(100)
- created_at — DATETIME — NOT NULL
tbl_event_response_action
- action_id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → tbl_event.event_id — NOT NULL
- response_type — VARCHAR(30) — NOT NULL
- target_info — VARCHAR(200)
- content — TEXT
- result_status — VARCHAR(20)
- detail — JSON
- requested_by — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- requested_at — DATETIME — NOT NULL
- result_at — DATETIME
tbl_event_stat_daily
- stat_date — DATE — Primary key — NOT NULL
- event_type_id — BIGINT — Foreign key → tbl_event_type_code.event_type_id — NOT NULL
- site_id — BIGINT — Foreign key → tbl_site.site_id — NOT NULL
- device_id — BIGINT — Foreign key → tbl_device.device_id — NOT NULL
- event_count — INT — NOT NULL
- false_alarm_count — INT — NOT NULL
- avg_response_sec — INT
tbl_event_type_code
- event_type_id — BIGINT — Primary key — NOT NULL
- event_type_name — VARCHAR(50) — NOT NULL
- risk_level_default — VARCHAR(20)
tbl_login_log
- login_log_id — BIGINT — Primary key — NOT NULL
- input_login_id — VARCHAR(50) — NOT NULL
- user_status — VARCHAR(20)
- login_result — VARCHAR(10) — NOT NULL
- user_ip — VARCHAR(45)
- insert_date — DATETIME — NOT NULL
tbl_object_attribute_stat_daily
- stat_date — DATE — Primary key — NOT NULL
- object_type — VARCHAR(20) — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → tbl_device.device_id — NOT NULL
- attribute_key — VARCHAR(50) — Foreign key → tbl_attribute_value_code.attribute_key — NOT NULL
- attribute_value — VARCHAR(50) — Foreign key → tbl_attribute_value_code.value_code — NOT NULL
- count — INT — NOT NULL
tbl_object_stat_daily
- stat_date — DATE — Primary key — NOT NULL
- object_type — VARCHAR(20) — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → tbl_device.device_id — NOT NULL
- object_count — INT — NOT NULL
tbl_site
- site_id — BIGINT — Primary key — NOT NULL
- site_name — VARCHAR(100) — NOT NULL
- region_code — VARCHAR(20)
- is_active — CHAR(1) — NOT NULL
tbl_user
- user_id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- pwd — VARCHAR(200) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- user_status — VARCHAR(20) — NOT NULL
- login_failure_count — INT — NOT NULL
- last_login_at — DATETIME
- locked_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
tbl_user_password_history
- history_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- pwd_hash — VARCHAR(200) — NOT NULL
- changed_at — DATETIME — NOT NULL
tbl_user_session
- session_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
- token — VARCHAR(500) — NOT NULL
- issued_at — DATETIME — NOT NULL
- expired_at — DATETIME — NOT NULL