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