Table slot9.WORLD.TSTA.EMPLOYEE_MISC_IDS
This table stores the employee identification records
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
COURT_CASE_DELETE.ID Implied Constraint R
Unique id for employee identification record
EJS_EMP_ID number 0
EMPLOYEES.EJS_EMP_ID EMPMISC_EMP1_FK R
FK to EMPLOYEES for employee unique id
ENC_ID_NUMBER raw 64 Misc ID number
MISC_ID_CODE varchar2 2
MISC_ID_CODES.MISC_ID_CODE EMPMISC_MISC_CD_FK R
FK to MISC_ID_CODES for misc ID type code
STATE_CODE varchar2 30  √  null
EJS_CODES.CODE EMPMISC_EJSCD_STATE_FK R
FK to EJS_CODES for misc ID state code
STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMPMISC_EJSCD_STATE_FK R
FK to EJS_CODES for misc ID state code type
COUNTRY_CODE varchar2 30  √  null
EJS_CODES.CODE EMPMISC_EJSCD_CNTRY_FK R
FK to EJS_CODES for misc ID country code
COUNTRY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMPMISC_EJSCD_CNTRY_FK R
FK to EJS_CODES for misc ID country code type
DATE_OF_ISSUE date 7  √  null Date id issued
EXPIRE_DATE date 7  √  null Date id expires
DATE_OF_INFO date 7  √  null Date of info for misc id record
COMMENTS varchar2 1000  √  null Comment for misc id record
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
"EJS_EMP_ID" IS NOT NULL EMPMISC_EMP_ID_NN
"MISC_ID_CODE" IS NOT NULL EMPMISC_ID_CODE_NN
"ID" IS NOT NULL EMPMISC_ID_NN
"ENC_ID_NUMBER" IS NOT NULL EMPMISC_ID_NUMBER_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc EMPMISC_PK
COUNTRY_CODE_TYPE + COUNTRY_CODE Performance Asc/Asc EMPMISC_EJSCD_CNTRY_FK_I
STATE_CODE_TYPE + STATE_CODE Performance Asc/Asc EMPMISC_EJSCD_STATE_FK_I
EJS_EMP_ID Performance Asc EMPMISC_EMP1_FK_I
ENC_ID_NUMBER + MISC_ID_CODE Performance Asc/Asc EMPMISC_ID_NUMBER_TYPE_I
ENC_ID_NUMBER Performance Asc EMPMISC_IDNUM_I
MISC_ID_CODE Performance Asc EMPMISC_MISC_CD_FK_I

Close relationships  within of separation: