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)