edge_server - 2022-04-05 09:10:44
Tables (27)
auth_group
- id — integer — Primary key — NOT NULL
- name — character — NOT NULL
auth_group_permissions
- id — integer — Primary key — NOT NULL
- group_id — integer — Foreign key → auth_group.id — NOT NULL
- permission_id — integer — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — integer — Primary key — NOT NULL
- name — character — NOT NULL
- content_type_id — integer — Foreign key → django_content_type.id — NOT NULL
- codename — character — NOT NULL
auth_user
- id — integer — Primary key — NOT NULL
- password — character — NOT NULL
- last_login — timestamp
- is_superuser — boolean — NOT NULL
- username — character — NOT NULL
- first_name — character — NOT NULL
- last_name — character — NOT NULL
- email — character — NOT NULL
- is_staff — boolean — NOT NULL
- is_active — boolean — NOT NULL
- date_joined — timestamp — NOT NULL
auth_user_groups
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → auth_user.id — NOT NULL
- group_id — integer — Foreign key → auth_group.id — NOT NULL
auth_user_user_permissions
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → auth_user.id — NOT NULL
- permission_id — integer — Foreign key → auth_permission.id — NOT NULL
camera
- id — bigint — Primary key — NOT NULL
- cameraId — character — NOT NULL
- cameraStreamingUrl — character
- cameraName — character
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- maskingImageLink — character
- location_id — bigint — Foreign key → location.id
- roi_id — bigint — Foreign key → roi.id
centerserverinfo
- id — bigint — Primary key — NOT NULL
- name — character — NOT NULL
- ip — character — NOT NULL
- port — integer — NOT NULL
- authCode — character — NOT NULL
- serviceType — integer — NOT NULL
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
device
- id — bigint — Primary key — NOT NULL
- serial — character — NOT NULL
- name — character
- type — integer — NOT NULL
- status — integer — NOT NULL
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- group_id — bigint — Foreign key → device.id
django_admin_log
- id — integer — Primary key — NOT NULL
- action_time — timestamp — NOT NULL
- object_id — text
- object_repr — character — NOT NULL
- action_flag — smallint — NOT NULL
- change_message — text — NOT NULL
- content_type_id — integer — Foreign key → django_content_type.id
- user_id — integer — Foreign key → auth_user.id — NOT NULL
django_content_type
- id — integer — Primary key — NOT NULL
- app_label — character — NOT NULL
- model — character — NOT NULL
django_migrations
- id — integer — Primary key — NOT NULL
- app — character — NOT NULL
- name — character — NOT NULL
- applied — timestamp — NOT NULL
django_session
- session_key — character — Primary key — NOT NULL
- session_data — text — NOT NULL
- expire_date — timestamp — NOT NULL
edge_server_block
- id — integer — Primary key — NOT NULL
- cat — character — NOT NULL
- label — character — NOT NULL
- type — character — NOT NULL
- bg_color — character — NOT NULL
- inputs — integer — NOT NULL
- outputs — integer — NOT NULL
- templates — jsonb — NOT NULL
edge_server_camera
- id — integer — Primary key — NOT NULL
- cameraId — character — NOT NULL
- cameraLiveUrl — character
- cameraName — character
- cameraLocation — character
- cameraLocationName — character
- cameraIP — character
- cameraResolution — character
- cameraTransferSpeed — character
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- lat — numeric(22,16)
- lon — numeric(22,16)
- maskingImageLink — character
- maskingPolygonPath — jsonb
edge_server_device
- id — integer — Primary key — NOT NULL
- serial — character — NOT NULL
- name — character
- status — integer — NOT NULL
- loc — character
- ip — inet
- firm_version — character
- located — integer
- left — integer
- top — integer
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- connected — timestamp
- project_id — integer — Foreign key → edge_server_project.id
- rule_id — integer — Foreign key → edge_server_rule.id
- viewpoints — jsonb
- loc_type — character
- vp_config — jsonb
- input_date — timestamp
edge_server_project
- id — integer — Primary key — NOT NULL
- name — character — NOT NULL
- desc — character
- status — integer — NOT NULL
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
edge_server_rule
- id — integer — Primary key — NOT NULL
- name — character — NOT NULL
- version — character — NOT NULL
- rule — jsonb — NOT NULL
- created — timestamp — NOT NULL
event
- eventId — uuid — Primary key — NOT NULL
- eventType — integer — NOT NULL
- eventTime — timestamp — NOT NULL
- eventData — jsonb
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- deliveryStatus — integer — NOT NULL
- failedReason — text
- service_id — bigint — Foreign key → service.id — NOT NULL
location
- id — bigint — Primary key — NOT NULL
- name — character — NOT NULL
- address — text
- latitude — numeric(22,16)
- longitude — numeric(22,16)
operation
- id — bigint — Primary key — NOT NULL
- device_id — bigint — Foreign key → device.id — NOT NULL
- service_id — bigint — Foreign key → service.id — NOT NULL
processing
- id — bigint — Primary key — NOT NULL
- camera_id — bigint — Foreign key → camera.id — NOT NULL
- service_id — bigint — Foreign key → service.id — NOT NULL
roi
- id — bigint — Primary key — NOT NULL
- maskingPolygonPath — jsonb
service
- id — bigint — Primary key — NOT NULL
- boxSize — double — NOT NULL
- scores — double — NOT NULL
- modelVersion — character
- imageStorePath — character
- frameRate — integer
- serviceType — integer — NOT NULL
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- CenterServerInfo_id — bigint — Foreign key → centerserverinfo.id
엣지가현재수행중인service ([Edge]OperateServicePrcessingCamera)
- id — bigint — Primary key — NOT NULL
- 박스크기(float) (boxSize) — double — NOT NULL
- Scores (scores) — double — NOT NULL
- 모델버전 (modelVersion) — character
- ImgStorePath (imageStorePath) — character
- FrameRate (frameRate) — integer
- Type(번호판 or 무단횡단) (serviceType) — integer — NOT NULL
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- cameraId — character — NOT NULL
- cameraStreamingUrl — character
- cameraName — character
- maskingImageLink — character
- roi_id — bigint — Foreign key → 엣지가현재수행중인카메라의roi.id — NOT NULL
엣지가현재수행중인카메라의roi ([Edge]CopyOfroi)
- id — bigint — Primary key — NOT NULL
- maskingPolygonPath — text
엣지발생Event ([Edge]event)
- Event uid (임의생성) (eventId) — uuid — Primary key — NOT NULL
- Type(번호판 or 무단횡단) (eventType) — integer — NOT NULL
- EventTime (eventTime) — timestamp — NOT NULL
- eventData — text
- created — timestamp — NOT NULL
- updated — timestamp — NOT NULL
- deliveryStatus — integer — NOT NULL
- failedReason — text
- service_id — bigint — Foreign key → 엣지가현재수행중인service.id — NOT NULL