SchemaSpy - Table slot9.WORLD.TSTA.CALENDAR

This table store the assignments added to a calendar in the scheduling module 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

CALENDAR_ASSIGNMENT_ID

number

CALENDAR_ASSIGNMENTS_AUDIT.CALENDAR_ASSIGNMENT_ID	Implied Constraint R
JS_SCHEDULING_VW.CALENDAR_ASSIGNMENT_ID	Implied Constraint R

ACTIVE

varchar2

TYPE

varchar2

255

CODE

varchar2

255

ASSIGNMENT_CODES.ASSIGNMENT_CODE

CALASSIGN_ASCD_FK R

START_DATE_TIME

timestamp(6)

11,6

END_DATE_TIME

timestamp(6)

11,6

HOURS

number

√

null

TITLE

varchar2

255

√

null

ASSIGNMENT_SHIFT_ID

number

CALENDAR_SHIFTS.CALENDAR_SHIFT_ID

CALASSIGN_CALSHIFT_FK R

USER_SHIFT_ID

number

√

null

CALENDAR_SHIFTS.CALENDAR_SHIFT_ID

CALASSIGN_CALSHIFT_U_FK R

OFFICER_ID

number

√

null

OFFICERS.OFFICER_ID

Implied Constraint R

EMPLOYEE_ID

number

√

null

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

√

null

MINIMUM_STAFFING_FLG

varchar2

√

'N'

ASSIGNMENT_SERIES_ID

number

√

null

CALENDAR_ASSIGNMENT_SERIES.ASSIGNMENT_SERIES_ID

CALASSIGN_CALSERIES_FK R

OVERTIME_FLG

varchar2

√

'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"ACTIVE" IS NOT NULL	CALASSIGN_ACTIVE_NN
"CODE" IS NOT NULL	CALASSIGN_CODE_NN
"END_DATE_TIME" IS NOT NULL	CALASSIGN_END_TIME_NN
"CALENDAR_ASSIGNMENT_ID" IS NOT NULL	CALASSIGN_ID_NN
"ASSIGNMENT_SHIFT_ID" IS NOT NULL	CALASSIGN_SHIFT_ID_NN
"START_DATE_TIME" IS NOT NULL	CALASSIGN_START_TIME_NN
"TYPE" IS NOT NULL	CALASSIGN_TYPE_NN
COALESCE(OFFICER_ID,EMPLOYEE_ID) IS NOT NULL	CK_CALASSIGN_USERS

Indexes:

Column(s)	Type	Sort	Constraint Name
CALENDAR_ASSIGNMENT_ID	Primary key	Asc	CALASSIGN_PK
CODE	Performance	Asc	CALASSIGN_ASCD_FK_I
ASSIGNMENT_SERIES_ID	Performance	Asc	CALASSIGN_CALSERIES_FK_I
ASSIGNMENT_SHIFT_ID	Performance	Asc	CALASSIGN_CALSHIFT_FK_I
USER_SHIFT_ID	Performance	Asc	CALASSIGN_CALSHIFT_U_FK_I
EMPLOYEE_ID	Performance	Asc	CALASSIGN_EMP1_I
OFFICER_ID	Performance	Asc	CALASSIGN_OFF1_I