Table slot9.WORLD.TSTA.EMP_LANGUAGES
This table stores the languages spoken added to an employee 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
LANG_ID number 38 uniquely identifies the language.
EJS_EMP_ID number 30
EMPLOYEES.EJS_EMP_ID EMP_LANG_EMP1_FK R
EJS sequence to uniquely identify an employee.
INFO_DATE date 7  √  null Date of language information.
EMP_LANG_CODE varchar2 30
EJS_CODES.CODE EMP_LANG_EMP_LANG__EJS_CODE_FK R
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Creator date used for audit information.
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Updator date used for audit information.
LANG_TYPE_CODE varchar2 30
EJS_CODES.CODE EMP_LANG_LANG_TYPE_EJS_CODE_FK R
Language type code
TRAIN_ID number 30  √  null
TRAININGS.TRAIN_ID EMP_LANG_TRA_1_FK R
Sequence used to uniquely identify a training session.
EMP_LANG_CODE_TYPE varchar2 30  √  'LANGUAGE_CODES'
EJS_CODES.CODE_TYPE EMP_LANG_EMP_LANG__EJS_CODE_FK R
LANG_TYPE_CODE_TYPE varchar2 30  √  'LANGUAGE_TYPE_CODES'
EJS_CODES.CODE_TYPE EMP_LANG_LANG_TYPE_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EJS_EMP_ID" IS NOT NULL EMP_LANG_EJS_EMP_ID_NN
"EMP_LANG_CODE" IS NOT NULL EMP_LANG_EMP_LANG_CODE_NN
"LANG_ID" IS NOT NULL EMP_LANG_LANG_ID_NN
"LANG_TYPE_CODE" IS NOT NULL EMP_LANG_LANG_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
LANG_ID + EJS_EMP_ID Primary key Asc/Asc EMP_LANG_PK
EJS_EMP_ID Performance Asc EMP_LANG_EMP1_FK_I
EMP_LANG_CODE_TYPE + EMP_LANG_CODE Performance Asc/Asc EMP_LANG_EMP_LANG__EJS_CODE_I
LANG_TYPE_CODE Performance Asc EMP_LANG_LANG_TC_FK_I
LANG_TYPE_CODE_TYPE + LANG_TYPE_CODE Performance Asc/Asc EMP_LANG_LANG_TYPE_EJS_CODE_I
EMP_LANG_CODE Performance Asc EMP_LANG_LC_FK_I
TRAIN_ID Performance Asc EMP_LANG_TRA_1_FK_I

Close relationships  within of separation: