Table slot9.WORLD.TSTA.PROPERTIES
This table stores the property information for MASTER PROPERTIES added in the application
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
BUSINESS_PROPERTIES.PRO_PROPERTY_ID BPPROP_PRO_FK R
BUSINESS_PROPERTY_VW.PROPERTY_ID Implied Constraint R
EVIDENCE.PRO_PROPERTY_ID EVI_PRO_FK C
EVIDENCE_COC_MOST_RECENT_VW.PROPERTY_ID Implied Constraint R
EVIDENCE_CUSTODY_VW.PROPERTY_ID Implied Constraint R
EVIDENCE_STATUS_VW.PROPERTY_ID Implied Constraint R
INCIDENT_COMBO_OFCR_VW.PROPERTY_ID Implied Constraint R
INCIDENT_EVIDENCE_VW.PROPERTY_ID Implied Constraint R
INCIDENT_PROPERTIES.PROPERTY_ID INCPRO_PRO_FK R
INCIDENT_PROPERTY_VW.PROPERTY_ID Implied Constraint R
JS_BAIR_MO_FIELDS_VW.PROPERTY_ID Implied Constraint R
JS_EVIDENCE_VW.PROPERTY_ID Implied Constraint R
JS_INCIDENT_EVIDENCE_VW.PROPERTY_ID Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.PROPERTY_ID Implied Constraint R
JS_INCIDENT_PROPERTY_VW.PROPERTY_ID Implied Constraint R
JS_PERMIT_PROPERTY_VW.PROPERTY_ID Implied Constraint R
OFFENSES.PRO_PROPERTY_ID OFFNSE_PROP_FK R
PAWN_PROPERTIES.PRO_PROPERTY_ID PP_PRO_FK R
PAWN_PROPERTY_VW.PROPERTY_ID Implied Constraint R
PEOPLE_PROPERTIES.PROPERTY_ID PEPROP_PRO_FK R
PEOPLE_PROPERTY_VW.PROPERTY_ID Implied Constraint R
PERMIT_PROPERTIES.PROPERTY_ID PRMPRP_PRO_FK C
PERMIT_PROPERTIES_VW.PROPERTY_ID Implied Constraint R
PROPERTIES_AUDIT.PROPERTY_ID Implied Constraint R
PROPERTIES_NOT_DUPLICATES.NOT_DUP_PROPERTY_ID PRONODUP_NOT_PRO_FK R
PROPERTIES_NOT_DUPLICATES.PROPERTY_ID PRONODUP_PRO_FK R
PROPERTY_ATTACHMENTS.PROPERTY_ID PROATT_PRO_FK C
PROPERTY_CASH.PROPERTY_ID PROPC_PRO_FK C
PROPERTY_DETAILS.PROPERTY_ID PD_PRO_FK C
PROPERTY_DETAILS_VW.PROPERTY_ID Implied Constraint R
PROPERTY_HOLD_SEARCH_VW.PROPERTY_ID Implied Constraint R
PROPERTY_HOLDS.PROPERTY_ID PROPHO_PRO_FK R
PROPERTY_IMAGES.PROPERTY_ID PROIMG_PRO_FK R
PROPERTY_XREFS.PRIMARY_PROPERTY_ID PROPX_PRI_PROPERTY_FK C
PROPERTY_XREFS.RELATED_PROPERTY_ID PROPX_REL_PROPERTY_FK C
RV_PROPERTIES.PROPERTY_ID Implied Constraint R
USER_FIELD_PROP_VALUES.PROPERTY_ID USRSCRN_UFPRV_ADDR_ID_FK R
Property ID number
PROPERTY_TYPE_CODE varchar2 30
PROPERTY_TYPE_CODES.PROPERTY_TYPE PRO_PROP_CD_FK R
Type of property
EVIDENCE varchar2 1 'N' Evidence ?
DOCUMENT varchar2 30
EJS_CODES.CODE PRO_PROPDOC_EJS_CODES_FK R
Document/Check?
TYPE_OF_QUANTITY varchar2 30  √  null
EJS_CODES.CODE PRO_TYPE_OF_QUANTI_EJS_CODE_FK R
Unit of measure
PRIMARY_COLOR varchar2 30  √  null
EJS_CODES.CODE PRO_PRIMARY_COLOR_EJS_CODE_FK R
Color code(s) for the property
SECONDARY_COLOR varchar2 30  √  null
EJS_CODES.CODE PRO_SECONDARY_COLO_EJS_CODE_FK R
Color code(s) for the property
DRUG_TYPE varchar2 30  √  null
EJS_CODES.CODE PRO_DRUG_TYPE_EJS_CODE_FK R
code for drug type
QUANTITY number 20,3  √  null Number or items
DESCRIPTION varchar2 2500  √  null Description of property
MAKE varchar2 20  √  null Make of property
MODEL varchar2 25  √  null Model of property
SERIAL_NUMBER varchar2 25  √  null Serial number of property
VALUE number 11,2  √  null Estimated value of property
MISC varchar2 160  √  null Miscellaneous/ Owner Applied Number
DOCUMENT_NUMBER varchar2 6  √  null Check Number
BANK varchar2 40  √  null Name of Bank
DOCUMENT_DATE date 7  √  null Date of Document/Check
ACCOUNT_NAME varchar2 40  √  null Name of Account
ACCOUNT_NUMBER number 16  √  null Account Number on Document
PAYABLE_TO varchar2 40  √  null Payable To
AMOUNT number 12,2  √  null Amount of Check
ENDORSEE varchar2 40  √  null Endorsee of Document
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
BARREL_LENGTH varchar2 20  √  null Barrel Length of Gun
CALGAG_CODE varchar2 30  √  null
EJS_CODES.CODE PRO_CALGAG_CODE_EJS_CODE_FK R
NCIC Code for Caliber or Gauge
GUN_ACT_CODE varchar2 30  √  null
EJS_CODES.CODE PRO_GUN_ACT_CODE_EJS_CODE_FK R
NCIC Gun Action Type Code
GUN_TYP_CODE varchar2 30  √  null
EJS_CODES.CODE PRO_GUN_TYP_CODE_EJS_CODE_FK R
NCIC Weapon/Gun Type Code
INDX_SEC_LEVEL_CODE number 0  √  1
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE PROPERTIES_MIS_CD_CD_FK R
INDX_SEC_LEVEL_ID varchar2 100  √  null
INDX_SEC_LEVEL_AGENCY varchar2 30  √  null
ACTIVE_SUBSCRIPTION varchar2 1  √  null
CALGAG_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_CALGAG_CODE_EJS_CODE_FK R
DRUG_TYPE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_DRUG_TYPE_EJS_CODE_FK R
GUN_ACT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_GUN_ACT_CODE_EJS_CODE_FK R
GUN_TYP_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_GUN_TYP_CODE_EJS_CODE_FK R
PRIMARY_COLOR_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_PRIMARY_COLOR_EJS_CODE_FK R
SECONDARY_COLOR_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_SECONDARY_COLO_EJS_CODE_FK R
TYPE_OF_QUANTITY_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_TYPE_OF_QUANTI_EJS_CODE_FK R
REC_ID number 0  √  null
DOCUMENT_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRO_PROPDOC_EJS_CODES_FK R
CURRENCY_CODE varchar2 30  √  null
EJS_CODES.CODE PROP_CURR_CD_EJS_CODE_FK R
CURRENCY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PROP_CURR_CD_EJS_CODE_FK R
DATE_OF_INFO date 7  √  null
NUM_ROUNDS number 0  √  null
GUN_MAKE_ID number 0  √  null
GUN_MAKE_CODES.GUN_MAKE_ID PRO_GMC_FK R
LOADED_BY varchar2 100  √  null Interface that loaded this index record.
LAST_LOAD_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
evidence IN ( 'Y' , 'N' ) CK_PRO_EVIDENCE
"DOCUMENT" IS NOT NULL PRO_DOCUMENT_NN
"EVIDENCE" IS NOT NULL PRO_EVIDENCE_NN
"PROPERTY_ID" IS NOT NULL PRO_PROPERTY_ID_NN
"PROPERTY_TYPE_CODE" IS NOT NULL PRO_PROPERTY_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
PROPERTY_ID Primary key Asc PRO_PK
CALGAG_CODE_TYPE + CALGAG_CODE Performance Asc/Asc PRO_CALGAG_CODE_EJS_CODE_I
CALGAG_CODE Performance Asc PRO_CGCD_FK_I
PRIMARY_COLOR Performance Asc PRO_COLOR_FK_I
SECONDARY_COLOR Performance Asc PRO_COLOR_IDENTIFIED_BY_FK_I
DRUG_TYPE Performance Asc PRO_DRG_FK_I
DRUG_TYPE_TYPE + DRUG_TYPE Performance Asc/Asc PRO_DRUG_TYPE_EJS_CODE_I
GUN_ACT_CODE Performance Asc PRO_GACD_FK_I
GUN_MAKE_ID Performance Asc PRO_GMC_FK_I
GUN_TYP_CODE Performance Asc PRO_GTCD_FK_I
GUN_ACT_CODE_TYPE + GUN_ACT_CODE Performance Asc/Asc PRO_GUN_ACT_CODE_EJS_CODE_I
GUN_TYP_CODE_TYPE + GUN_TYP_CODE Performance Asc/Asc PRO_GUN_TYP_CODE_EJS_CODE_I
PRIMARY_COLOR_TYPE + PRIMARY_COLOR Performance Asc/Asc PRO_PRIMARY_COLOR_EJS_CODE_I
PROPERTY_TYPE_CODE Performance Asc PRO_PROP_CD_FK_I
DOCUMENT_TYPE + DOCUMENT Performance Asc/Asc PRO_PROPDOC_EJS_CODES_FK_I
TYPE_OF_QUANTITY Performance Asc PRO_QC_FK_I
SECONDARY_COLOR_TYPE + SECONDARY_COLOR Performance Asc/Asc PRO_SECONDARY_COLO_EJS_CODE_I
TYPE_OF_QUANTITY_TYPE + TYPE_OF_QUANTITY Performance Asc/Asc PRO_TYPE_OF_QUANTI_EJS_CODE_I
CURRENCY_CODE_TYPE + CURRENCY_CODE Performance Asc/Asc PROP_CURR_CD_EJS_CODE_FK_I
INDX_SEC_LEVEL_CODE Performance Asc PROP_INDX_SEC_LEVEL_CD_I

Close relationships  within of separation: