Table slot9.WORLD.TSTA.ATTACHMENTS
This table stores attachments added to INCIDENTS, CITATIONS, ARRESTS, etc. 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
ID number 0
ADDRESS_ATTACHMENTS.ID ADDRATT_ATT_FK C
ARREST_ATTACHMENTS.ID ARRATT_ATT_FK C
BUSINESS_ATTACHMENTS.ID BUSNSATT_ATT_FK C
CASE_ATTACHMENTS.ID CASATT_ATT_FK C
CITATION_ATTACHMENTS.ATT_ID CITA_ATT_FK R
COURSE_ATTACHMENTS.ATTACHMENT_ID CRSATT_ATT_FK R
COURSE_INST_EMP_ATTACHMENTS.ATTACHMENT_ID CRSIEMPATT_ATT_FK R
COURT_APPEARANCE_ATCHMNTS.ID CRTAPPATT_ATT_FK C
COURT_CASE_ATTACHMENTS.ID CRTCASEATT_ATT_FK C
COURT_PAPER_ATTACHMENTS.ID CPAP_ATTCH_ATT_FK C
CRIMINAL_COMP_ATTACHMENTS.ATTACHMENT_ID CCATT_ATT_FK R
DISPATCH_EVENT_ATTACHMENTS.ID DISPATT_ATT_FK C
DS_ICR_FILE_REFERENCES.ATT_ID DSICRFREF_ATT_FK C
DS_ICR_HEADER_FILES.ERROR_FILE_ID DSICRHF_ATT_ERR_FK R
DS_ICR_HEADER_FILES.FILE_ID DSICRHF_ATT_FILE_FK R
DS_ICR_HEADER_FILES.RESPONSE_FILE_ID DSICRHF_ATT_RESP_FK R
DV_ATTACHMENTS.ID DVATT_ATT_FK R
DV_CRASH_ATTACHMENTS.ID CRASHATT_ATT_FK R
DV_REQUEST_ATTACHMENTS.ID DVREQATT_ATT_FK R
DV_SERVICE_ATTACHMENTS.ID DVSERATT_ATT_FK R
EJS_XML_DOC_ATTACHMENTS.ID EXDA_ATT_FK R
EMPLOYEE_ATTACHMENTS.ID EMP1ATT_ATT_FK C
EMPLOYEE_INFO_ATTACHMENTS.ATTACHMENT_ID EIATT_ATT_FK R
FIELD_INTERVIEW_ATTACHMENTS.ID FLDINTATT_ATT_FK C
GANG_ATTACHMENTS.ATT_ID GA_ATT_FK R
IMPOUND_ATTACHMENTS.ID IMPATT_ATT_FK C
INCIDENT_ATTACHMENTS.ID INCATT_ATT_FK C
K9_ATTACHMENTS.ATT_ID K9ATTA_ATT_FK R
PERMIT_ATTACHMENTS.ID PRMTATT_ATT_FK C
PERSON_ATTACHMENTS.ATT_ID PA_ATT_FK C
PROPERTY_ATTACHMENTS.ID PROATT_ATT_FK C
SCREEN_TYPE_SCREEN_PDFS.ATTACHMENT_ID STSP_ATT_FK R
USI_ATTACHMENTS.ID USIATT_ATT_FK C
VEHICLE_ATTACHMENTS.ID VEHATT_ATT_FK C
WARRANT_ATTACHMENTS.ID WARATT_ATT_FK C
COURT_CASE_DELETE.ID Implied Constraint R
MS_OBJ blob 4000  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
FILE_TYPE varchar2 6  √  null This is the type of file being stored. The file extension is used.
FILE_NAME varchar2 255  √  null
REC_ID number 0  √  null
AGENCY_ATTACHMENT_INT_ID number 0  √  null
AGENCY_ATTACHMENT_INTERFACES.ID ATT_ATTINT_FK R
Use if attachment stored externally. FK to AGENCY_ATTACHMENT_INTERFACES specifies what external storage solution manages this attachment
EXT_ATTACHMENT_ID varchar2 100  √  null Use if attachment stored externally. Unique identifier to external storage solution
FILE_PATH varchar2 260  √  null Use if attachment is stored on file system outside of database
TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ATT_EJSCD_ATTTYPE_FK R
TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ATT_EJSCD_ATTTYPE_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID" IS NOT NULL ATT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc ATT_PK
AGENCY_ATTACHMENT_INT_ID Performance Asc ATT_ATTINT_FK_I
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc ATT_EJSCD_ATTTYPE_FK_I

Close relationships  within of separation: