View slot9.WORLD.TSTA.INCIDENT_EVIDENCE_VW
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID Implied Constraint R
PROPERTY_TYPE_CODE varchar2 30
EVIDENCE varchar2 1
DOCUMENT varchar2 30
TYPE_OF_QUANTITY varchar2 30  √  null
PRIMARY_COLOR varchar2 30  √  null
SECONDARY_COLOR varchar2 30  √  null
DRUG_TYPE varchar2 30  √  null
QUANTITY number 20,3  √  null
DESCRIPTION varchar2 2500  √  null
MAKE varchar2 20  √  null
MODEL varchar2 25  √  null
SERIAL_NUMBER varchar2 25  √  null
VALUE number 11,2  √  null
MISC varchar2 160  √  null
DOCUMENT_NUMBER varchar2 6  √  null
BANK varchar2 40  √  null
DOCUMENT_DATE date 7  √  null
ACCOUNT_NAME varchar2 40  √  null
ACCOUNT_NUMBER number 16  √  null
PAYABLE_TO varchar2 40  √  null
AMOUNT number 12,2  √  null
ENDORSEE varchar2 40  √  null
BARREL_LENGTH varchar2 20  √  null
CALGAG_CODE varchar2 30  √  null
GUN_ACT_CODE varchar2 30  √  null
GUN_TYP_CODE varchar2 30  √  null
INCIDENT_ID number 0
INCIDENTS.INCIDENT_ID Implied Constraint R
I_AGNCY_CD_AGENCY_CODE varchar2 30
REPORT_DATE date 7
START_DATE date 7  √  null
END_DATE date 7  √  null
SUMMARY varchar2 1000  √  null
INC_REPORT_NUMBER varchar2 20
STATUS varchar2 30
SUPP_SEQ number 0
RESPONSIBLE_USER_ID varchar2 100  √  null
AGENCY_ONLY varchar2 1  √  null
CID varchar2 1  √  null
SECURITY_LEVEL number 38  √  null
P_STATUS_CODE varchar2 30  √  null
INCPER_INC_INCIDENT_ID number 38  √  null
INCPER_PER_PERSON_ID number 38  √  null
INCPER_MN_MN_ID number 38  √  null
E_STATUS_CODE varchar2 30  √  null
EVID_LOC_CODE varchar2 30  √  null
AGNCY_CD_AGENCY_CODE varchar2 30  √  null
EVIDENCE_ID number 38
EVIDENCE.EVIDENCE_ID Implied Constraint R
DISPOSITION_CODE varchar2 30  √  null
SCHED_DISP_DATE date 7  √  null
DISP_ORDER_DATE date 7  √  null
DISPOSITION_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT p.property_id, p.property_type_code, p.evidence, p.document, p.type_of_quantity, p.primary_color, p.secondary_color, p.drug_type, p.quantity, p.description, p.make, p.model, p.serial_number, p.VALUE, p.misc, p.document_number, p.bank, p.document_date, p.account_name, p.account_number, p.payable_to, p.amount, p.endorsee, p.barrel_length, p.calgag_code, p.gun_act_code, p.gun_typ_code, i.incident_id, i.agncy_cd_agency_code i_agncy_cd_agency_code, i.report_date, i.start_date, i.end_date, i.summary, i.inc_report_number, isupp.isc_status_code "STATUS", isupp.supp_seq, isupp.responsible_user_id, isupp.agency_only, isupp.cid, isupp.security_level, ip.status_code p_status_code, ip.incper_incident_id, ip.incper_person_id, ip.incper_mn_id, e.status_code e_status_code, e.evid_loc_code, e.agncy_cd_agency_code, e.evidence_id, e.disposition_code, e.sched_disp_date, e.disp_order_date, e.disposition_date FROM properties p, incidents i, incident_properties ip, incident_supplements isupp, evidence e WHERE p.property_id = ip.property_id AND p.property_id = e.pro_property_id AND ip.incsup_incident_id = isupp.inc_incident_id AND ip.incsup_supp_seq = isupp.supp_seq AND i.incident_id = isupp.inc_incident_id
 
Possibly Referenced Tables/Views:
EVIDENCE INCIDENT_PROPERTIES INCIDENT_SUPPLEMENTS INCIDENTS PROPERTIES 


Close relationships: