criminal
Tables (12)
area_crime (Untitled)
- area (Key) — varchar2(50) — Primary key — NOT NULL
- occ_sum (Field2) — Number(8)
- occ_md (Field3) — Number(8)
- occ_rob (Field4) — Number(8)
- occ_genc (Field5) — Number(8)
- occ_st (Field6) — Number(8)
- occ_vio (Field7) — Number(8)
- arr_sum (Field8) — Number(8)
- arr_md (Field9) — Number(8)
- arr_rob (Field10) — Number(8)
- arr_genc (Field11) — Number(8)
- arr_st (Field12) — Number(8)
- arr_vio (Field13) — Number(8)
area_service (Untitled11)
- ser_id (Key2) — Number(8) — Primary key — NOT NULL
- area (Key) — varchar2(50) — Foreign key → area_crime.area — NOT NULL
- service_type (Key3) — Number(8) — Foreign key → service_type.service_type — NOT NULL
- count (Field2) — Number(8)
calm (Untitled6)
- calm (Key) — varchar2(50) — Primary key — NOT NULL
- police (Key2) — varchar2(50) — Foreign key → police.police — NOT NULL
- area (Key22) — varchar2(50) — Foreign key → police.area — NOT NULL
- local (Key3) — varchar2(50) — Foreign key → population.local — NOT NULL
- organ (Field3) — Number(8)
- calm_cctv (Field4) — Number(8)
crime_area (Untitled2)
- accode (Key) — varchar2(50) — Primary key — NOT NULL
- crime_type (Key3) — varchar2(50) — Foreign key → jongro_crime.crime_type — NOT NULL
- area (Key2) — varchar2(50) — Foreign key → area_crime.area — NOT NULL
- occur (Field3) — Number(8)
- arrest (Field4) — Number(8)
households (Untitled8)
- local_id (Key) — Number(8) — Primary key — NOT NULL
- area (Key2) — varchar2(50) — Foreign key → area_crime.area — NOT NULL
- 1_holds (Field) — Number(8)
- 2_holds (Field2) — Number(8)
- 3_holds (Field3) — Number(8)
- 4_holds (Field4) — Number(8)
- 5_holds (Field5) — Number(8)
jongro_crime (Untitled5)
- crime_type (Key) — varchar2(50) — Primary key — NOT NULL
- accode (Field) — varchar2(50)
- arrest (Field2) — varchar2(50)
- Field3 — Number(8)
- Field4 — Number(8)
place (Untitled12)
- cpcode (Key2) — varchar2(50) — Primary key — NOT NULL
- crime_type (Key) — varchar2(50) — Foreign key → jongro_crime.crime_type — NOT NULL
- home (Field2) — Number(8)
- road (Field3) — Number(8)
- store (Field4) — Number(8)
- vehicle (Field5) — Number(8)
- go (Field6) — Number(8)
- elses (Field7) — Number(8)
police (Untitled7)
- police (Key) — varchar2(50) — Primary key — NOT NULL
- area (Key2) — varchar2(50) — Foreign key → area_crime.area — NOT NULL
- policeman (Field) — Number(8)
- pol_md (Field5) — Number(8)
- pol_rob (Field6) — Number(8)
- pol_genc (Field7) — Number(8)
- pol_st (Field8) — Number(8)
- pol_vio (Field9) — Number(8)
population (Untitled3)
- local (Key) — varchar2(50) — Primary key — NOT NULL
- area (Key2) — varchar2(50) — Foreign key → area_crime.area — NOT NULL
- man (Field2) — Number(8)
- woman (Field3) — Number(8)
- kman (Field4) — Number(8)
- kwoman (Field5) — Number(8)
- fman (Field6) — Number(8)
- fwoman (Field7) — Number(8)
public (Untitled10)
- Key — Primary key — NOT NULL
service_type (Untitled4)
- service_type (Key) — varchar2(50) — Primary key — NOT NULL
- display_type (Field) — varchar2(50)