클웹 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)