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