Table slot9.WORLD.TSTA.ASSIGNMENT_LOGS
This table stores log entries for assignments in 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
LOG_ID number 38
DEPARTMENT_VEHICLES.LOG_ID DV_AL_FK R
EMP_ASSIGNMENT_K9_DOGS.LOG_ID EAK9D_AL_FK R
ACCESS_LOGS.LOG_ID Implied Constraint R
ASSIGN_ID number 38
ASSIGNMENTS.ASSIGN_ID AL_ASSIG_FK R
Unique identifier for an employee assigment.
LOG_STATUS varchar2 10  √  null The status of the daily log.
OFFICER_ID number 0  √  null
OFFICERS.OFFICER_ID AL_OFF_FK R
Records the different assignments an employee has or has had.
EJS_EMP_ID number 30  √  null
EMPLOYEES.EJS_EMP_ID AL_EMP_FK R
EJS sequence to uniquely identify an employee.
EMPLOYEE_ID varchar2 20  √  null The employee identification number.
STATUS_CODE varchar2 30  √  null
EMP_STATUS_CODES.STATUS_CODE AL_STCD_FK R
The code used to identify the employee status during the assignment.
START_DATE_TIME date 7  √  null The date and time the assignment started.
END_DATE_TIME date 7  √  null The date and time the assignment ended.
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
REC_ID number 0  √  null
DSPLY_LOG_ID number 0  √  null Assignment Log reference number incremented per agency.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ASSIGN_ID" IS NOT NULL AL_ASSIGN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
LOG_ID Primary key Asc AL_PK
ASSIGN_ID Performance Asc AL_ASSIG_FK_I
EJS_EMP_ID Performance Asc AL_EMP_FK_I
OFFICER_ID Performance Asc AL_OFF_FK_I
STATUS_CODE Performance Asc AL_STCD_FK_I

Close relationships  within of separation: