클웹 erd

테이블 (4)

crime_areas

  • id — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • name — VARCHAR(200) — NOT NULL
  • tel — VARCHAR(50)
  • type — INT — NOT NULL
  • lon — DOUBLE — NOT NULL
  • lat — DOUBLE — NOT NULL

pedestrian_records

  • id — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • district — VARCHAR(50) — NOT NULL
  • sensing_time — DATETIME — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • visitor_count — INT — NOT NULL
  • reg_datetime — DATETIME
  • autonomous_district — VARCHAR(50)
  • model_name — VARCHAR(50)
  • serial_no — VARCHAR(50)

police_facilities

  • id — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • police — VARCHAR(100) — NOT NULL
  • facility_type — VARCHAR(50) — NOT NULL
  • facility_name — VARCHAR(200) — NOT NULL
  • tel — VARCHAR(50)
  • lon — DOUBLE — NOT NULL
  • lat — DOUBLE — NOT NULL

safety_trails

  • id — VARCHAR(50) — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • lon — DOUBLE — NOT NULL
  • lat — DOUBLE — NOT NULL
  • facility_admin — VARCHAR(200)
  • position — VARCHAR(200)