Table slot9.WORLD.TSTA.COURSE_INSTANCE
This table stores Instances of a Course.
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
ID number 0
COURSE_EMPLOYEE_GROUPS.COURSE_INSTANCE_ID CRSEMPGRP_CRSINST_FK R
COURSE_INSTANCE_EMPLOYEE.COURSE_INSTANCE_ID CRSIEMP_CRSINST_FK R
COURT_CASE_DELETE.ID Implied Constraint R
PK for this table.
COURSE_ID number 0
COURSE.ID CRSINST_CRS_FK R
FK to COURSE table.
NAME varchar2 100
DESCRIPTION varchar2 1000  √  null
LOCATION varchar2 100  √  null Location of this course instance.
INSTRUCTORS varchar2 100  √  null Instructors for this course instance.
START_DATE_TIME date 7  √  null Start date and time.
END_DATE_TIME date 7  √  null End date and time.
CERT_LENGTH_DAYS number 0  √  null
MINIMUM_HOURS number 0  √  null
PASSING_SCORE number 0  √  null
MAX_ATTENDEES number 0  √  null
MIN_ATTENDEES number 0  √  null
TRAINING_COST number 0  √  null
EQUIPMENT varchar2 1000  √  null
EXTERNAL_FLAG varchar2 1  √  null
ACTIVE_FLAG varchar2 1  √  null
COMMENTS varchar2 1000  √  null
SELF_SIGNUP_FLAG varchar2 1  √  null
SELF_SIGNUP_START_DATE date 7  √  null
TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE CRSINST_TYPE_EJSCD_FK R
TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CRSINST_TYPE_EJSCD_FK R
CLASSIFICATION_CODE varchar2 30  √  null
EJS_CODES.CODE CRSINST_CLASS_EJSCD_FK R
CLASSIFICATION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CRSINST_CLASS_EJSCD_FK R
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE CRSINST_AGNCY_CD_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"COURSE_ID" IS NOT NULL CRSINST_COURSE_ID_FK_NN
"ID" IS NOT NULL CRSINST_ID_NN
"NAME" IS NOT NULL CRSINST_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc CRSINST_PK
AGENCY_CODE Performance Asc CRSINST_AGNCY_CD_FK_I
CLASSIFICATION_CODE_TYPE + CLASSIFICATION_CODE Performance Asc/Asc CRSINST_CLASS_EJSCD_FK_I
COURSE_ID Performance Asc CRSINST_CRS_FK_I
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc CRSINST_TYPE_EJSCD_FK_I

Close relationships  within of separation: