Table slot9.WORLD.TSTA.CRIMINAL_COMPLAINT_DELETE
This table stores a delete log for criminal complaint records.
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
COURT_CASE_DELETE.ID Implied Constraint R
PK - Unique identifier for each criminal complaint delete record.
CRIMINAL_COMPLAINT_NUMBER varchar2 30  √  null Criminal complaint record number.
PERSON_FNAME varchar2 80  √  null Criminal complaint person first name.
PERSON_MNAME varchar2 80  √  null Criminal complaint person middle name.
PERSON_LNAME varchar2 100  √  null Criminal complaint person last name.
INCIDENT_ID varchar2 255  √  null Criminal complaint associated incident id.
ARREST_ID varchar2 255  √  null Criminal complaint associated arrest id.
DELETED_BY varchar2 100  √  null Comment for why the criminal complaint was deleted.
DELETED_DATE date 7  √  null
DELETE_REASON varchar2 255  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

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

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc CCDEL_PK
ARREST_ID Performance Asc CCDEL_ARR_ID_I
CRIMINAL_COMPLAINT_NUMBER Performance Asc CCDEL_COMP_ID_I
INCIDENT_ID Performance Asc CCDEL_INC_ID_I
PERSON_FNAME Performance Asc CCDEL_PER_FNAME_I
PERSON_LNAME Performance Asc CCDEL_PER_LNAME_I
PERSON_MNAME Performance Asc CCDEL_PER_MNAME_I
DELETED_BY Performance Asc CCDEL_USR_ID_I

Close relationships: