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