Table slot9.WORLD.TSTA.MILITARY_SERVICE
This table stores military service information 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
MILITARY_SERVICE_ID number 0 Sequence used for primary key
PER_PERSON_ID number 38
PEOPLE.PERSON_ID MIL_SER_PER_FK R
Person ID number
MBC_BRANCH_CODE varchar2 30
EJS_CODES.CODE MIL_SER_MBC_BRANCH_EJS_CODE_FK R
Branch code designator
MSC_STATUS_CODE varchar2 3
MILITARY_STATUS_CODES.STATUS_CODE MIL_SER_MSC_FK R
Status code designator
MRC_REASON_CODE varchar2 30  √  null
EJS_CODES.CODE MIL_SER_MRC_REASON_EJS_CODE_FK R
Reason code designator
DISCHARGE_COMMENT varchar2 1000  √  null Dishcharge comment
LAST_ASSIGNED_CITY varchar2 240  √  null City name of last assignment
LAST_ASSIGNED_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE MIL_SER_LAST_ASSIG_EJS_CODE_FK R
State code of last assignment
SERVICE_START_DATE date 7  √  null Start date of service
SERVICE_END_DATE date 7  √  null End date of service
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
LAST_ASSIGNED_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE MIL_SER_LAST_ASSIG_EJS_CODE_FK R
MBC_BRANCH_CODE_TYPE varchar2 30  √  'MILITARY_BRANCH_CODES'
EJS_CODES.CODE_TYPE MIL_SER_MBC_BRANCH_EJS_CODE_FK R
MRC_REASON_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE MIL_SER_MRC_REASON_EJS_CODE_FK R
REC_ID number 0  √  null
DATE_OF_INFO date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"MBC_BRANCH_CODE" IS NOT NULL MIL_SER_MBC_BRANCH_CODE_NN
"MILITARY_SERVICE_ID" IS NOT NULL MIL_SER_MILITARY_SERVICE_ID_NN
"MSC_STATUS_CODE" IS NOT NULL MIL_SER_MSC_STATUS_CODE_NN
"PER_PERSON_ID" IS NOT NULL MIL_SER_PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
MILITARY_SERVICE_ID Primary key Asc MIL_SER_PK
LAST_ASSIGNED_STATE_CODE_TYPE + LAST_ASSIGNED_STATE_CODE Performance Asc/Asc MIL_SER_LAST_ASSIG_EJS_CODE_I
MBC_BRANCH_CODE_TYPE + MBC_BRANCH_CODE Performance Asc/Asc MIL_SER_MBC_BRANCH_EJS_CODE_I
MBC_BRANCH_CODE Performance Asc MIL_SER_MBC_FK_I
MRC_REASON_CODE Performance Asc MIL_SER_MRC_FK_I
MRC_REASON_CODE_TYPE + MRC_REASON_CODE Performance Asc/Asc MIL_SER_MRC_REASON_EJS_CODE_I
MSC_STATUS_CODE Performance Asc MIL_SER_MSC_FK_I
PER_PERSON_ID Performance Asc MIL_SER_PER_FK_I
LAST_ASSIGNED_STATE_CODE Performance Asc MIL_SER_STATE_CD_FK_I

Close relationships  within of separation: