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