Table slot9.WORLD.TSTA.EDUCATION
This table stores the education information including degree type added to a MASTER PERSON 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
EDUCATION_ID number 0
EDUCATION_STATUSES.EDUCATION_ID EDED_EDID_FK R
Sequence used for primary key.
PERSON_ID number 38
PEOPLE.PERSON_ID EDU_PER_FK C
Person ID number
BUSINESS_NUMBER number 38
BUSINESSES.BUSINESS_NUMBER EDU_BUSNS_FK C
Unique id for business
DEGREE_TYPE_CODE varchar2 3
DEGREE_TYPE_CODES.CODE EDU_DTC_FK R
The code to specify the type of degree.(i.e. masters, bachelors...)
NUMBER_YEARS_COMPLETED number 2  √  null Number of years completed.
DATE_OF_INFO date 7  √  null Date of Information.
START_DATE date 7  √  null
END_DATE date 7  √  null
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
"BUSINESS_NUMBER" IS NOT NULL EDU_BUSINESS_NUMBER_NN
"DEGREE_TYPE_CODE" IS NOT NULL EDU_DEGREE_TYPE_CODE_NN
"EDUCATION_ID" IS NOT NULL EDU_EDUCATION_ID_NN
"PERSON_ID" IS NOT NULL EDU_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EDUCATION_ID Primary key Asc EDU_PK
BUSINESS_NUMBER Performance Asc EDU_BUSNS_FK_I
DEGREE_TYPE_CODE Performance Asc EDU_DTC_FK_I
PERSON_ID Performance Asc EDU_PER_FK_I

Close relationships  within of separation: