Table slot9.WORLD.TSTA.PHONES
This table stores phone numbers 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
PHONE_ID number 8
BUSINESS_ADDR_PHONES.PHONE_ID BA_PHO_PHONE_FK C
EMPLOYEE_ADDR_PHONES.PHONE_ID EA_PHO_PHONE_FK C
IMP_VEH_BUSINESSES_VW.PHONE_ID Implied Constraint R
IMPOUND_PEOPLE.PHONE_ID_HOME IMPP_PHONE_TO_HOME_FK R
IMPOUND_PEOPLE.PHONE_ID_WORK IMPP_PHONE_FK R
PEOPLE_COMBO_ADR_PH_VW.PHONE_ID Implied Constraint R
PEOPLE_COMBO_PH_VW.PHONE_ID Implied Constraint R
PEOPLE_COMBO_VW.PHONE_ID Implied Constraint R
PEOPLE_PHONE_VW.PHONE_ID Implied Constraint R
PERSON_ADDR_PHONES.PHONE_ID PA_PHO_PHONE_FK C
PHO_TYP_CD_PHONE_TYPE_CODE varchar2 30
EJS_CODES.CODE PHONE_PHO_TYP_CD_P_EJS_CODE_FK R
Code for phone type
PER_PERSON_ID number 0  √  null
PEOPLE.PERSON_ID PHONE_PER_FK C
Person ID number
AREA varchar2 3  √  null
DATE_OF_INFO date 7  √  null The date the information was provided
EXT varchar2 8  √  null Store a phone extension for a phone number.
PREFIX varchar2 3  √  null A phone number prefix.
SUFFIX varchar2 4  √  null A phone number suffix.
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null The date of creation.
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null The the information was updated.
ATT_ID number 6  √  null An id to uniquely identify a Public/Private Defender.
EJS_EMP_ID number 30  √  null
EMPLOYEES.EJS_EMP_ID PHONE_EMP1_FK R
EJS sequence to uniquely identify an employee.
PHO_TYP_CD_PHONE_TYPE_COD_TYPE varchar2 30  √  'PHONE_TYPE_CODES'
EJS_CODES.CODE_TYPE PHONE_PHO_TYP_CD_P_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PHO_TYP_CD_PHONE_TYPE_CODE" IS NOT NULL PHONE_PHO_TYP_CD_PHONE_TYPE_NN
"PHONE_ID" IS NOT NULL PHONE_PHONE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PHONE_ID Primary key Asc PHONE_PK
EJS_EMP_ID Performance Asc PHONE_EMP1_FK_I
AREA + PREFIX + SUFFIX Performance Asc/Asc/Asc PHONE_NUMBER_I
PER_PERSON_ID Performance Asc PHONE_PER_FK_I
PHO_TYP_CD_PHONE_TYPE_CODE Performance Asc PHONE_PHO_TYP_CD_FK_I
PHO_TYP_CD_PHONE_TYPE_COD_TYPE + PHO_TYP_CD_PHONE_TYPE_CODE Performance Asc/Asc PHONE_PHO_TYP_CD_P_EJS_CODE_I

Close relationships  within of separation: