cctv

Tables (6)

cctv_analysis

  • analysis_id (Key) — Primary key — NOT NULL
  • camera_id (Key2) — Foreign key → cctv_media.camera_id — NOT NULL
  • object_id (Field2)
  • object_position_x (Field3)
  • object_position_y (Field4)
  • object_size_width (Field5)
  • object_size_height (Field6)
  • object_action (Field7)
  • object_approach (Field8)
  • onlive (Field9)

cctv_media

  • camera_id (Key) — Primary key — NOT NULL
  • date (Field)
  • location (Field2)

postech_in_object

  • object_id (Key) — Primary key — NOT NULL
  • analysis_id (Key2) — Foreign key → cctv_analysis.analysis_id — NOT NULL
  • gender (Field)
  • age (Field2)
  • day (Field3)
  • position (Field4)
  • timezone (Field5)
  • attack (Field6)
  • help (Field7)
  • howl (Field8)

postech_out_geo_risk

  • dong_code (Key) — Primary key — NOT NULL
  • current_assault_risk (Field)

postech_out_risk

  • risk_id (Key) — Primary key — NOT NULL
  • obj1_id (Field)
  • obj2_id (Field2)
  • obj3_id (Field3)
  • assault_1_1 (Field4)

sns_data

  • Key — Primary key — NOT NULL
  • link (Field)
  • location (Field2)
  • crime_type (Field3)