Table slot9.WORLD.TSTA.ASSIGNMENTS
This table stores assignment information added to the OFFICER DAILY LOG 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
ASSIGN_ID number 38
ACTIVITY_HEADERS.ASSIGN_ID ACTHD_ASSIG_FK R
ASSIGNMENT_EQUIPMENT.ASSIGN_ID AE_ASSIG_FK R
ASSIGNMENT_LOGS.ASSIGN_ID AL_ASSIG_FK R
ASSIGNMENT_SUB_BEATS.ASSIGN_ID ASSSB_ASSIG_FK R
ASSIGNMENT_VEHICLES.ASSIGN_ID AV_ASSIG_FK R
DV_ASSIGNMENTS.ODL_ASSIGNMENT_ID DVAS_ASSIG_FK R
EMP_ASSIGNMENT_K9_DOGS.ASSIGN_ID Implied Constraint R
JS_OFFICER_DAILY_ACTIVITY_VW.ASSIGN_ID Implied Constraint R
JS_OFFICER_DAILY_EQUIPMENT_VW.ASSIGN_ID Implied Constraint R
JS_OFFICER_DAILY_VEHICLE_VW.ASSIGN_ID Implied Constraint R
JS_OFFICER_DAILY_VW.ASSIGN_ID Implied Constraint R
Unique assignment identifier.
ASSIGN_DATE date 7  √  null The assignment date.
TASK_TIME number 5  √  null The average time duration for a given assignment.
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
ASSIGN_COMMENT varchar2 1000  √  null Free text assignment comments.
ASSIGN_CODE varchar2 30
ASSIGNMENT_CODES.ASSIGNMENT_CODE ASSIG_ASCD_FK R
Assignment code
SUB_CAT_CODE varchar2 5  √  null
EMP_SUB_ASSIGN_CODES.CAT_CODE ASSIG_EMP_SUB_CD_FK R
Category code of the sub assignment.
SUB_ASSIGN_CODE varchar2 5  √  null
EMP_SUB_ASSIGN_CODES.ASSIGN_CODE ASSIG_EMP_SUB_CD_FK R
Assignment code for the sub assignment.
SUB_CODE varchar2 5  √  null
EMP_SUB_ASSIGN_CODES.SUB_CODE ASSIG_EMP_SUB_CD_FK R
Sub assignment code.
REC_ID number 0  √  null
SHIFT_CODE varchar2 30  √  null
ASSIGNMENT_SHIFT_CODES.SHIFT_CODE ASSIG_ASC_FK R
Assignment shift code.
POSTED varchar2 1  √  null Flag used to control and filter searches by posted assignments.
SUPERVISOR varchar2 1  √  null Supervisor assignment flag.
ASSIGN_STATUS varchar2 30
EJS_CODES.CODE ASSIG_EJS_CODES_FK R
ASSIGN_STATUS_TYPE varchar2 30
EJS_CODES.CODE_TYPE ASSIG_EJS_CODES_FK R
ASSIGN_NUMBER varchar2 20
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ASSIG_AGNCY_CD_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ASSIGN_CODE" IS NOT NULL ASSIG_ASSIGN_CODE_NN
"ASSIGN_ID" IS NOT NULL ASSIG_ASSIGN_ID_NN
"ASSIGN_NUMBER" IS NOT NULL ASSIG_ASSIGN_NUM_NN
"ASSIGN_STATUS" IS NOT NULL ASSIG_ASSIGN_STATUS_NN
"ASSIGN_STATUS_TYPE" IS NOT NULL ASSIG_ASSIGN_STATUS_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
ASSIGN_ID Primary key Asc ASSIG_PK
AGENCY_CODE Performance Asc ASSIG_AGNCY_CD_FK_I
SHIFT_CODE Performance Asc ASSIG_ASC_FK_I
ASSIGN_CODE Performance Asc ASSIG_ASCD_FK_I
ASSIGN_DATE Performance Asc ASSIG_ASSIGN_DATE_I
Performance ASSIG_ASSIGN_DATE_TRUNC_I
ASSIGN_STATUS_TYPE + ASSIGN_STATUS Performance Asc/Asc ASSIG_EJS_CODES_FK_I
SUB_CODE + SUB_CAT_CODE + SUB_ASSIGN_CODE Performance Asc/Asc/Asc ASSIG_EMP_SUB_CD_FK_I

Close relationships  within of separation: