sdas

Tables (6)

CRIME_INFO

  • CASE_CODE — varchar2(100)
  • INVESTIGATOR_CODE — varchar2(100)
  • CRIME — varchar2(100) — NOT NULL
  • SUSPECT_NAME — varchar2(100) — NOT NULL
  • VICTIM_NAME — varchar2(100)
  • OCCURRENCE_TIME — date — NOT NULL
  • OCCURING_AREA — number(37)
  • ADMISSION_DATE — date
  • CLOSING_DATE — date
  • RESULT — varchar2(100)

INVESTIGATOR

  • INVESTIGATOR_CODE — varchar2(100)
  • INVESTIGATOR_NAME — varchar2(100) — NOT NULL
  • INVESTIGATOR_CLASS — varchar2(100) — NOT NULL
  • INVESTIGATOR_AFFILIATION — varchar2(100) — NOT NULL
  • INVESTIGATOR_CONTACT — varchar2(100) — NOT NULL
  • CASE_CODE — varchar2(100) — NOT NULL

SUSPECT

  • SUSPECT_NAME — varchar2(100) — NOT NULL
  • ARMY_NUMBER — varchar2(100) — NOT NULL
  • SUSPECT_CONTACT — varchar2(100) — NOT NULL
  • SUSPECT_AFFILIATION — varchar2(100) — NOT NULL
  • CASE_CODE — varchar2(100)
  • INVESTIGATOR_CODE — varchar2(100)

area_code

  • area_code — number(10)
  • upper_area_code — number(10)
  • area_nm — varchar2(50)

find_area_nm

  • CASE_CODE — varchar2(100) — NOT NULL
  • INVESTIGATOR_CODE — varchar2(100) — NOT NULL
  • CRIME — varchar2(100) — NOT NULL
  • SUSPECT_NAME — varchar2(100) — NOT NULL
  • VICTIM_NAME — varchar2(100)
  • OCCURRENCE_TIME — date — NOT NULL
  • OCCURING_AREA — number(10) — NOT NULL
  • ADMISSION_DATE — date
  • CLOSING_DATE — date
  • RESULT — varchar2(100)
  • occuring_area_nm — varchar2(50) — NOT NULL

uncompleted_case_contact

  • CASE_CODE — varchar2(100) — NOT NULL
  • CRIME — varchar2(100) — NOT NULL
  • INVESTIGATOR_NAME — varchar2(100) — NOT NULL
  • INVESTIGATOR_CONTACT — varchar2(100) — NOT NULL
  • SUSPECT_NAME — varchar2(100) — NOT NULL
  • SUSPECT_CONTACT — varchar2(100) — NOT NULL
  • SUSPECT_AFFILIATION — varchar2(100) — NOT NULL