Table slot9.WORLD.TSTA.ASSIGNMENT_CODES
This table defines the valid assignment codes for 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
ASSIGNMENT_CODE varchar2 30
ASSIGNMENT_CODE_AGENCIES.ASSIGNMENT_CODE ACA_ASCD_FK C
ASSIGNMENT_TEMPLATES.ASSIGNMENT_CODE ATP_AC_FK R
ASSIGNMENTS.ASSIGN_CODE ASSIG_ASCD_FK R
CALENDAR_ASSIGNMENTS.CODE CALASSIGN_ASCD_FK R
FLEET_DASHBOARD_COST_VW.ASSIGNMENT_CODE Implied Constraint R
FLEET_DASHBOARD_MAINTENANCE_VW.ASSIGNMENT_CODE Implied Constraint R
FLEET_DASHBOARD_SERVICE_VW.ASSIGNMENT_CODE Implied Constraint R
JS_FLEET_DASH_MAINT_VW.ASSIGNMENT_CODE Implied Constraint R
Assignment code unique id
DESCRIPTION varchar2 50  √  null Assignment description
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
CREATOR_ID varchar2 100  √  null Person creating the record
REC_ID number 0  √  null
ASSIGNMENT_CATEGORY varchar2 30  √  null
EJS_CODES.CODE ASCD_EJSCD_CAT_FK R
ASSIGNMENT_CATEGORY_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ASCD_EJSCD_CAT_FK R
MODULE_FLG varchar2 5  √  null
MINIMUM_STAFFING_FLG varchar2 1  √  'N'
ACTIVE_FLAG varchar2 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ASSIGNMENT_CODE" IS NOT NULL ASCD_ASSIGNMENT_CODE_NN
ACTIVE_FLAG IN ('Y', 'N') CK_ASCD_ACTIVE_FLG
MINIMUM_STAFFING_FLG IN ('Y', 'N') CK_ASCD_MIN_STAFFING_FLG

Indexes:
Column(s) Type Sort Constraint Name
ASSIGNMENT_CODE Primary key Asc ASCD_PK
ASSIGNMENT_CATEGORY_TYPE + ASSIGNMENT_CATEGORY Performance Asc/Asc ASCD_EJSCD_CAT_FK_I

Close relationships  within of separation: