123

Tables (34)

AI_THRESHOLD

  • id — int — Primary key — NOT NULL
  • alarm_type — varchar(32) — NOT NULL
  • clip_prob_threshold — float
  • clip_duration_sec — int
  • yolo_duration_sec — int
  • both_overlap_window_sec — int
  • is_active — bit — NOT NULL
  • created_at — datetime2(7) — NOT NULL
  • updated_at — datetime2(7) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

CctvList

  • id — int — Primary key — NOT NULL
  • s1_seq — int
  • unique_id — nvarchar(50)
  • category — nvarchar(50)
  • location_name — nvarchar(100)
  • sub_location — nvarchar(100)
  • cctv_no — nvarchar(50)
  • seq — int
  • rotation_type — nvarchar(20)
  • camera_type — nvarchar(50)
  • size — nvarchar(50)
  • manufacturer — nvarchar(100)
  • model_name — nvarchar(100)
  • camera_kind — nvarchar(50)
  • detail_location — nvarchar(200)
  • camera_name — nvarchar(200)
  • lon — float
  • lat — float
  • private_ip — nvarchar(50)
  • internal_ip — nvarchar(50)
  • nvr_ip — nvarchar(50)
  • remark — nvarchar(500)
  • note — nvarchar(500)
  • pole — nvarchar(100)
  • bracket — nvarchar(100)
  • created_at — datetime
  • updated_at — datetime
  • ai_id — int
  • ai_onoff — varchar(10)
  • ai_output_ip — varchar(50)
  • ai_output_port — varchar(10)
  • is_thermal — bit — NOT NULL
  • thermal_warning_temp — int
  • thermal_fire_temp — int
  • health_status — nvarchar(20)
  • health_last_check_at — datetime
  • health_last_rtt_ms — int
  • health_last_error — nvarchar(255)
  • health_fail_count — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

EventLog

  • num — int — NOT NULL
  • eventType — nvarchar(50)
  • message — nvarchar(500)
  • indate — smalldatetime

WeatherInfo

  • id — int — Primary key — NOT NULL
  • location — varchar(255)
  • sunrise — varchar(255)
  • sunset — varchar(255)
  • temperature — float
  • humidity — int
  • wind_speed — float
  • condition — varchar(255)
  • conditionimage — varchar(255)
  • precip — float
  • timestamp — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

adia_ai

  • num — int — NOT NULL
  • title — nvarchar(50)
  • sound — nvarchar(50)
  • ip — nvarchar(50)
  • port — nvarchar(50)
  • id — nvarchar(500)
  • camera — nvarchar(50)
  • memo — nvarchar(500)
  • onoff — nvarchar(50)
  • indate — smalldatetime
  • threshold_fire — int
  • threshold_smoke — int
  • threshold_fall — int
  • threshold_person — int
  • threshold_car — int

adia_ai_alarm

  • id — int — Primary key — NOT NULL
  • alias — nvarchar(100) — NOT NULL
  • cctv_id — int
  • cctv_no — nvarchar(50)
  • location_name — nvarchar(100)
  • alarm_type — nvarchar(20) — NOT NULL
  • prob — float
  • first_event_time — datetime2(7) — NOT NULL
  • last_event_time — datetime2(7) — NOT NULL
  • last_event_id — int
  • status — nvarchar(20) — NOT NULL
  • created_at — datetime2(7) — NOT NULL
  • acked_at — datetime2(7)
  • resolved_at — datetime2(7)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

adia_ai_event_raw

  • id — int — Primary key — NOT NULL
  • alias — nvarchar(100) — NOT NULL
  • frame_ts — float — NOT NULL
  • frame_time — datetime2(7) — NOT NULL
  • frame_width — int — NOT NULL
  • frame_height — int — NOT NULL
  • detected — bit — NOT NULL
  • class_results — nvarchar(max) — NOT NULL
  • detections — nvarchar(max) — NOT NULL
  • vlm_detections — nvarchar(max)
  • aggregate — nvarchar(max)
  • analysis_summary — nvarchar(500)
  • frame_info — nvarchar(max)
  • sent_at — float — NOT NULL
  • received_at — datetime2(7) — NOT NULL
  • indate — smalldatetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

adia_alert_user

  • num — int — NOT NULL
  • alert_type — nvarchar(50)
  • user_id — nvarchar(50)
  • indate — smalldatetime

adia_archive

  • num — int — NOT NULL
  • title — nvarchar(50)
  • subtitle — nvarchar(250)
  • description — nvarchar(500)
  • eventdate — nvarchar(50)
  • starttime — nvarchar(50)
  • favorites — nchar(10)
  • duration — nvarchar(50)
  • userid — nvarchar(50)
  • files — nvarchar(150)
  • indate — smalldatetime

adia_area_map

  • num — int — Primary key — NOT NULL
  • areaTitle — nvarchar(100) — NOT NULL
  • subtitle — nvarchar(200)
  • comment — nvarchar(max) — varchar(max) NUL
  • alarmSound — nvarchar(50)
  • points — nvarchar(max) — NOT NULL
  • visible — char(1)
  • indate — datetime2(7)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

adia_areamap

  • num — int — NOT NULL
  • areaTitle — nvarchar(100) — NOT NULL
  • subtitle — nvarchar(200)
  • comment — nvarchar(500) — varchar(500) NUL
  • alarmSound — nvarchar(100)
  • points — nvarchar(max)
  • visible — char(1)
  • indate — datetime

adia_camera

  • num — int — NOT NULL
  • nvr_code — nvarchar(50)
  • title — nvarchar(50)
  • subtitle — nvarchar(250)
  • ip — nvarchar(50)
  • port — nvarchar(50)
  • id — nvarchar(50)
  • pwd — nvarchar(50)
  • memo — nvarchar(500)
  • startpoint — nvarchar(50)
  • endpoint — nvarchar(50)
  • connectAi — nvarchar(50)
  • connectAiOnOff — nvarchar(50)
  • sound — nvarchar(50)
  • visible — nchar(10)
  • display — int
  • indate — smalldatetime

adia_login_status

  • num — int — NOT NULL
  • userid — nvarchar(50)
  • ip_address — nvarchar(50)
  • indate — smalldatetime

adia_logs

  • id — int — Primary key — NOT NULL
  • level — varchar(50)
  • message — text
  • stack — text
  • timestamp — datetime
  • ipAddress — nvarchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

adia_nvr

  • num — int — NOT NULL
  • nvr_code — nvarchar(50)
  • subtitle — nvarchar(250)
  • ip — nvarchar(50)
  • port — nvarchar(50)
  • id — nvarchar(50)
  • pwd — nvarchar(50)
  • memo — nvarchar(500)
  • indate — smalldatetime

adia_user

  • num — int — NOT NULL
  • user_id — varchar(255)
  • user_name — nvarchar(50)
  • user_phone — nvarchar(50)
  • user_pwd — nvarchar(250)
  • user_info — nvarchar(500)
  • user_part — nvarchar(50)
  • user_status — nchar(10)
  • updatepwd — smalldatetime
  • updatedate — smalldatetime
  • indate — smalldatetime

adia_user_f

  • num — int — NOT NULL
  • userid — nvarchar(50)
  • indate — smalldatetime

adia_user_group_access

  • user_id — varchar(255) — Primary key — NOT NULL
  • group_id — varchar(50) — Primary key — NOT NULL
  • indate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

cctv_demo_video

  • id — int — Primary key — NOT NULL
  • title — nvarchar(200) — NOT NULL
  • cctv_no — nvarchar(50) — NOT NULL
  • file_path — nvarchar(500) — NOT NULL
  • file_name — nvarchar(255) — NOT NULL
  • file_size — bigint
  • status — nvarchar(10)
  • created_at — datetime2(7)
  • updated_at — datetime2(7)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

cctv_group

  • id — int — Primary key — NOT NULL
  • group_name — nvarchar(100) — NOT NULL
  • group_desc — nvarchar(200)
  • sort_order — int — NOT NULL
  • is_active — bit — NOT NULL
  • created_at — datetime2(7) — NOT NULL
  • updated_at — datetime2(7) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

cctv_group_item

  • id — int — Primary key — NOT NULL
  • group_id — int — Foreign key → cctv_group.id — NOT NULL
  • cctv_no — nvarchar(50) — NOT NULL
  • sort_order — int — NOT NULL
  • created_at — datetime2(7) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

cctv_layout_item

  • id — int — Primary key — NOT NULL
  • layout_id — int — Foreign key → cctv_layout_master.id — NOT NULL
  • r — int — NOT NULL
  • c — int — NOT NULL
  • row_span — int
  • col_span — int
  • cctv_no — nvarchar(50)
  • is_map — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

cctv_layout_master

  • id — int — Primary key — NOT NULL
  • layout_name — nvarchar(100) — NOT NULL
  • grid_rows — int
  • grid_cols — int
  • is_active — bit
  • user_id — nvarchar(50)
  • created_at — datetime2(7)
  • updated_at — datetime2(7)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

cctvlist_version_items

  • id — int — Primary key — NOT NULL
  • version_id — int — Foreign key → cctvlist_versions.version_id — NOT NULL
  • s1_seq — int
  • unique_id — nvarchar(50)
  • category — nvarchar(50)
  • location_name — nvarchar(100)
  • sub_location — nvarchar(100)
  • cctv_no — nvarchar(50)
  • seq — int
  • rotation_type — nvarchar(20)
  • camera_type — nvarchar(50)
  • size — nvarchar(50)
  • manufacturer — nvarchar(100)
  • model_name — nvarchar(100)
  • camera_kind — nvarchar(50)
  • detail_location — nvarchar(200)
  • camera_name — nvarchar(200)
  • lon — float
  • lat — float
  • private_ip — nvarchar(50)
  • internal_ip — nvarchar(50)
  • nvr_ip — nvarchar(50)
  • remark — nvarchar(500)
  • note — nvarchar(500)
  • pole — nvarchar(100)
  • bracket — nvarchar(100)
  • is_thermal — bit
  • thermal_warning_temp — int
  • thermal_fire_temp — int
  • ai_id — int
  • ai_onoff — nvarchar(10)
  • ai_output_ip — nvarchar(50)
  • ai_output_port — nvarchar(20)
  • created_at — datetime2(7)
  • updated_at — datetime2(7)
  • health_status — nvarchar(20)
  • health_last_check_at — datetime2(7)
  • health_last_rtt_ms — int
  • health_fail_count — int
  • health_last_error — nvarchar(500)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

cctvlist_versions

  • version_id — int — Primary key — NOT NULL
  • created_at — datetime2(7) — NOT NULL
  • created_by — nvarchar(50)
  • memo — nvarchar(200)
  • row_count — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

device_notifications

  • device_id — nvarchar(255) — Primary key — NOT NULL
  • notification_id — int — Foreign key → notifications.id — NOT NULL
  • is_seen — bit
  • seen_timestamp — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

login_history

  • id — int — Primary key — NOT NULL
  • userid — nvarchar(50)
  • ip_address — varchar(255)
  • login_time — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

map_place

  • id — int — Primary key — NOT NULL
  • place_key — nvarchar(64)
  • name — nvarchar(120) — NOT NULL
  • category — nvarchar(60)
  • description — nvarchar(400)
  • lat — float — NOT NULL
  • lng — float — NOT NULL
  • icon — nvarchar(60)
  • color — nvarchar(20)
  • radius_m — int
  • sort — int — NOT NULL
  • is_active — bit — NOT NULL
  • created_at — datetime2(7) — NOT NULL
  • updated_at — datetime2(7) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

notifications

  • id — int — Primary key — NOT NULL
  • message — nvarchar(255) — NOT NULL
  • timestamp — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

pn_agent

  • num — int — NOT NULL
  • phone — nvarchar(50)
  • name — nvarchar(50)
  • memo — nvarchar(50)
  • info — nvarchar(50)
  • indate — smalldatetime

pn_calling

  • num — int — NOT NULL
  • phone — nvarchar(50)
  • checkYN — nchar(10)
  • indate — smalldatetime

recording_history

  • history_id — int — Primary key — NOT NULL
  • camera_id — varchar(50) — NOT NULL
  • action — varchar(10) — NOT NULL
  • timestamp — datetime — NOT NULL
  • start_time — datetime
  • end_time — datetime
  • duration — int
  • notes — varchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

recording_status

  • camera_id — varchar(50) — Primary key — NOT NULL
  • is_recording — bit — NOT NULL
  • start_time — datetime
  • end_time — datetime
  • last_updated — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

video_recordings

  • num — int — NOT NULL
  • cameraIp — nvarchar(50)
  • cameraId — nvarchar(250)
  • cameraTitle — nvarchar(250)
  • startTime — datetime
  • endTime — datetime
  • metaTitle — nvarchar(50)
  • metaSubtitle — nvarchar(250)
  • metaDescription — nvarchar(500)
  • favorites — nchar(10)
  • duration — nvarchar(50)
  • userid — nvarchar(50)
  • files — nvarchar(150)
  • path — nvarchar(150)
  • indate — smalldatetime