Table slot9.WORLD.TSTA.ACTIVITIES
This table stores the activity information in the OFFICER DAILY LOG
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
ACTIVITY_ID number 0
ACTIVITY_RESULTS.ACTIVITY_ID ACT_RES_ACT_FK R
JS_OFFICER_DAILY_ACTIVITY_VW.ACTIVITY_ID Implied Constraint R
OFFENSE_ACTIVITIES.ACTIVITY_ID Implied Constraint R
Activity unique id
ACTIVITY_COUNT number 5  √  null Sequential activity counter
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
ACTIVITY_CODE varchar2 30
ACTIVITY_CODES.ACTIVITY_CODE ACT_ACD_FK R
Activity code
REC_ID number 0  √  null
ACTIVITY_HEADER_ID number 0
ACTIVITY_HEADERS.ACTIVITY_HEADER_ID ACT_ACTHD_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ACTIVITY_CODE" IS NOT NULL ACT_ACTIVITY_CODE_NN
"ACTIVITY_HEADER_ID" IS NOT NULL ACT_ACTIVITY_HEADER_ID_NN
"ACTIVITY_ID" IS NOT NULL ACT_ACTIVITY_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ACTIVITY_ID Primary key Asc ACT_PK
ACTIVITY_CODE Performance Asc ACT_ACD_FK_I
ACTIVITY_HEADER_ID Performance Asc ACT_ACTHD_FK_I

Close relationships  within of separation: