Table slot9.WORLD.TSTA.COURT_CASE_DELETE
This table stores court case delete 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
AGENCY_ATTACHMENT_INTERFACES.ID Implied Constraint R
AGENCY_SUBSCRIPTIONS_VW.ID Implied Constraint R
AGNCY_SRCH_INT_COUNT_HISTORY.ID Implied Constraint R
ASSOCIATE_DETAILS_VW.ID Implied Constraint R
ATTACHMENTS.ID Implied Constraint R
ATTACHMENTS_VW.ID Implied Constraint R
AUDIT_REPORTS.ID Implied Constraint R
AUDIT_SEARCHES.ID Implied Constraint R
BUS_PER_VEHICLE_VW.ID Implied Constraint R
CASE_ACTIVITY_ASSIGNMENTS.ID Implied Constraint R
CERTIFICATION_CERT_PREREQ.ID Implied Constraint R
CERTIFICATION_COURSE_PREREQ.ID Implied Constraint R
CERTIFICATION_EMPLOYEE.ID Implied Constraint R
CERTIFICATION_RANK.ID Implied Constraint R
CERTIFICATIONS.ID Implied Constraint R
CHARGE_CODE_TOKENS.ID Implied Constraint R
COURSE.ID Implied Constraint R
COURSE_ATTACHMENTS.ID Implied Constraint R
COURSE_EMPLOYEE_GROUPS.ID Implied Constraint R
COURSE_IMAGES.ID Implied Constraint R
COURSE_INST_EMP_ATTACHMENTS.ID Implied Constraint R
COURSE_INST_EMP_IMAGES.ID Implied Constraint R
COURSE_INSTANCE.ID Implied Constraint R
COURSE_INSTANCE_EMPLOYEE.ID Implied Constraint R
COURSE_PREREQUISITES.ID Implied Constraint R
COURT_APPEARANCE_OFFS.ID Implied Constraint R
COURT_APPEARANCES.ID Implied Constraint R
COURT_CASE_APPEARANCES.ID Implied Constraint R
COURT_CASE_ARRESTS.ID Implied Constraint R
COURT_CASE_CITATIONS.ID Implied Constraint R
COURT_CASE_COMPLAINTS.ID Implied Constraint R
COURT_CASE_INCS.ID Implied Constraint R
COURT_CASE_OFFS.ID Implied Constraint R
COURT_CASE_PEOPLE.ID Implied Constraint R
COURT_CASE_REFS.ID Implied Constraint R
COURT_CASES.ID Implied Constraint R
CRIMINAL_COMP_ATTACHMENTS.ID Implied Constraint R
CRIMINAL_COMP_CHARGE_TOKENS.ID Implied Constraint R
CRIMINAL_COMP_IMAGES.ID Implied Constraint R
CRIMINAL_COMPLAINT_ARRESTS.ID Implied Constraint R
CRIMINAL_COMPLAINT_CHARGES.ID Implied Constraint R
CRIMINAL_COMPLAINT_DELETE.ID Implied Constraint R
CRIMINAL_COMPLAINT_INCIDENTS.ID Implied Constraint R
CRIMINAL_COMPLAINT_SUBMIT_LOG.ID Implied Constraint R
CRIMINAL_COMPLAINTS.ID Implied Constraint R
DISPATCH_EVENT_PEOPLE_VW.ID Implied Constraint R
DS_IBR_MIGRATION_ERRORS.ID Implied Constraint R
DS_ICR_HEADER_FILES.ID Implied Constraint R
DS_ICR_HEADER_MESSAGES.ID Implied Constraint R
DS_ICR_INSERT_QUEUE.ID Implied Constraint R
DV_CRASH_DELETE_LOG.ID Implied Constraint R
DV_OFFICERS.ID Implied Constraint R
DV_ROLE_RESTRICTIONS.ID Implied Constraint R
EJS_NIBRS_DATA_ELEMENTS.ID Implied Constraint R
EJS_NOTES_ANNOTATED.ID Implied Constraint R
EJS_NOTES_ANNOTATIONS.ID Implied Constraint R
EMP_INFO_TYPE_CODE_ROLES.ID Implied Constraint R
EMPLOYEE_AFFILIATIONS.ID Implied Constraint R
EMPLOYEE_CLASSIFICATIONS.ID Implied Constraint R
EMPLOYEE_CONTACTS.ID Implied Constraint R
EMPLOYEE_EDUCATION.ID Implied Constraint R
EMPLOYEE_GROUP_EMPLOYEES.ID Implied Constraint R
EMPLOYEE_GROUPS.ID Implied Constraint R
EMPLOYEE_INFO.ID Implied Constraint R
EMPLOYEE_INFO_ATTACHMENTS.ID Implied Constraint R
EMPLOYEE_INFO_IMAGES.ID Implied Constraint R
EMPLOYEE_INFO_TYPE_CODES.ID Implied Constraint R
EMPLOYEE_MISC_IDS.ID Implied Constraint R
EMPLOYEE_SKILLS.ID Implied Constraint R
IMPOUND_BUSINESSES.ID Implied Constraint R
IMPOUND_DELETE_LOG.ID Implied Constraint R
INC_COMMENT_GROUP_COMMENTS.ID Implied Constraint R
INC_COMMENT_GROUPS.ID Implied Constraint R
INC_FLD_CONTACT_ADDRESSES_VW.ID Implied Constraint R
INC_NARRATIVE_PEOPLE.ID Implied Constraint R
INCIDENT_LOCATIONS.ID Implied Constraint R
JS_BAIR_PERSON_VW.ID Implied Constraint R
MAP_ICONS.ID Implied Constraint R
NOTIFICATION_AUDITS.ID Implied Constraint R
NOTIFICATION_DETAILS_DATA.ID Implied Constraint R
OFFENSE_GROUP_OFFENSES.ID Implied Constraint R
OFFENSE_GROUPS.ID Implied Constraint R
OFFICER_EMPLOYEE_VW.ID Implied Constraint R
PERSON_CAUTIONS.ID Implied Constraint R
PHOTO_LINEUP_CASES.ID Implied Constraint R
PHOTO_LINEUP_LIBRARY.ID Implied Constraint R
PLAN_TABLE.ID Implied Constraint R
PROPERTY_HOLD_CUSTODIES.ID Implied Constraint R
PROPERTY_HOLD_LOCATIONS.ID Implied Constraint R
PROPERTY_HOLD_SEARCH_VW.ID Implied Constraint R
PROPERTY_HOLDS.ID Implied Constraint R
RMS_ALERTS.ID Implied Constraint R
ROUTE_ACTION_INST_AGENCIES.ID Implied Constraint R
ROUTE_ACTION_INST_ROLES.ID Implied Constraint R
ROUTE_INSTANCE_AGENCIES.ID Implied Constraint R
ROUTE_INSTANCE_ROLES.ID Implied Constraint R
RV_ACCESSORS.ID Implied Constraint R
RV_CONDITION_FACTORS.ID Implied Constraint R
RV_CONDITION_PROPERTIES.ID Implied Constraint R
RV_CUSTOM_OBJECTS.ID Implied Constraint R
SCREEN_TYPE_SCREEN_PDF_FIELDS.ID Implied Constraint R
SCREEN_TYPE_SCREEN_PDFS.ID Implied Constraint R
SEARCH_INT_RESULTS_ACCESS.ID Implied Constraint R
SEARCH_INTERFACE_RESULTS.ID Implied Constraint R
SOLR_UPDATE_ID_TMP.ID Implied Constraint R
TAG_CASES.ID Implied Constraint R
TAGS.ID Implied Constraint R
TOAD_PLAN_TABLE.ID Implied Constraint R
USER_PINNED_RECORDS.ID Implied Constraint R
USER_SCREEN_DELETE_AUDIT.ID Implied Constraint R
USER_SCREEN_INSTANCE_DELETE.ID Implied Constraint R
PK - Unique identifier for each court case delete record.
CASE_NUMBER varchar2 100  √  null Court case number.
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
Court case agency code.
FILED_DATE date 7  √  null Filed Date/time of court case.
COMMENTS varchar2 255  √  null Additional comments/remarks on the court case.
DELETE_COMMENTS varchar2 255  √  null Delete comments/remarks.
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
COURT_CASE_ID number 0  √  null Court Case ID.

Analyzed at Mon Sep 20 21:05 MDT 2021

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

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc CRTCASEDEL_PK
AGENCY_CODE Performance Asc CRTCASEDEL_AGENCY_I

Close relationships: