criminal

Tables (12)

Untitled9

    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)