View slot9.WORLD.TSTA.PEOPLE_COMBO_ADDR_PHONES_VW
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
PERSON_ID number 0  √  null
JAIL_PEOPLE.PERSON_ID Implied Constraint R
SEX_CODE varchar2 0  √  null
RACE_CODE varchar2 0  √  null
ADDRESS_ID number 0  √  null
ADDRESSES.ADDRESS_ID Implied Constraint R
STREET_NAME varchar2 40  √  null
ADRS_CITY varchar2 40  √  null
ADRS_STATE varchar2 30  √  null
VEH_COLOR_CODE varchar2 0  √  null
VEH_TOP_COLOR_CODE varchar2 0  √  null
VEH_MAKE_CODE varchar2 0  √  null
VEH_MODEL_CODE varchar2 0  √  null
VEHICLE_ID number 0  √  null
DEPARTMENT_VEHICLES.VEHICLE_ID Implied Constraint R
YEAR number 0  √  null
ID_NUMBER varchar2 0  √  null
STATE_CD_STATE_CODE varchar2 0  √  null
CNTRY_CD_COUNTRY_TYPE_CODE varchar2 0  √  null
MISC_CD_MISC_ID_CODE varchar2 0  √  null
DATE_OF_ISSUE date 7  √  null
SMT_ID number 0  √  null
SMTS.SMT_ID Implied Constraint R
BDY_PRT_BODY_PART_CODE varchar2 0  √  null
SMT_CD_SMT_CODE varchar2 0  √  null
DESCRIPTION varchar2 0  √  null
PHONE_ID number 0  √  null
PHO_TYP_CD_PHONE_TYPE_CODE varchar2 30  √  null
AREA varchar2 3  √  null
PREFIX varchar2 3  √  null
SUFFIX varchar2 4  √  null
EXT varchar2 8  √  null
PHONE_DATE date 7  √  null
ADDR_ADDRESS_ID number 0  √  null
BLD_CD_BUILD_CODE varchar2 0  √  null
EYE_CD_EYE_CODE varchar2 0  √  null
HAIR_LNGTH_HAIR_LENGTH_CODE varchar2 0  √  null
SKN_CD_SKIN_CODE varchar2 0  √  null
FACE_HR_FACIAL_HAIR varchar2 0  √  null
HAIR_CD_HAIR_CODE varchar2 0  √  null
HEIGHT varchar2 0  √  null
WEIGHT varchar2 0  √  null
GLASSES varchar2 0  √  null
PHYS_DESC_DATE date 7  √  null
PHYS_DESC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT "PERSON_ID","SEX_CODE","RACE_CODE","ADDRESS_ID","STREET_NAME","ADRS_CITY","ADRS_STATE","VEH_COLOR_CODE","VEH_TOP_COLOR_CODE", "VEH_MAKE_CODE","VEH_MODEL_CODE","VEHICLE_ID","YEAR","ID_NUMBER","STATE_CD_STATE_CODE","CNTRY_CD_COUNTRY_TYPE_CODE", "MISC_CD_MISC_ID_CODE","DATE_OF_ISSUE","SMT_ID","BDY_PRT_BODY_PART_CODE","SMT_CD_SMT_CODE","DESCRIPTION","PHONE_ID", "PHO_TYP_CD_PHONE_TYPE_CODE","AREA","PREFIX","SUFFIX","EXT","PHONE_DATE","ADDR_ADDRESS_ID","BLD_CD_BUILD_CODE", "EYE_CD_EYE_CODE","HAIR_LNGTH_HAIR_LENGTH_CODE","SKN_CD_SKIN_CODE","FACE_HR_FACIAL_HAIR","HAIR_CD_HAIR_CODE","HEIGHT", "WEIGHT","GLASSES","PHYS_DESC_DATE","PHYS_DESC_ID" FROM PEOPLE_COMBO_ADR_PH_VW UNION SELECT "PERSON_ID","SEX_CODE","RACE_CODE","ADDRESS_ID","STREET_NAME","ADRS_CITY","ADRS_STATE","VEH_COLOR_CODE","VEH_TOP_COLOR_CODE", "VEH_MAKE_CODE","VEH_MODEL_CODE","VEHICLE_ID","YEAR","ID_NUMBER","STATE_CD_STATE_CODE","CNTRY_CD_COUNTRY_TYPE_CODE", "MISC_CD_MISC_ID_CODE","DATE_OF_ISSUE","SMT_ID","BDY_PRT_BODY_PART_CODE","SMT_CD_SMT_CODE","DESCRIPTION","PHONE_ID", "PHO_TYP_CD_PHONE_TYPE_CODE","AREA","PREFIX","SUFFIX","EXT","PHONE_DATE","ADDR_ADDRESS_ID","BLD_CD_BUILD_CODE", "EYE_CD_EYE_CODE","HAIR_LNGTH_HAIR_LENGTH_CODE","SKN_CD_SKIN_CODE","FACE_HR_FACIAL_HAIR","HAIR_CD_HAIR_CODE", "HEIGHT","WEIGHT","GLASSES","PHYS_DESC_DATE","PHYS_DESC_ID" FROM PEOPLE_COMBO_ADR_VW UNION SELECT "PERSON_ID","SEX_CODE","RACE_CODE","ADDRESS_ID","STREET_NAME","ADRS_CITY","ADRS_STATE","VEH_COLOR_CODE","VEH_TOP_COLOR_CODE", "VEH_MAKE_CODE","VEH_MODEL_CODE","VEHICLE_ID","YEAR","ID_NUMBER","STATE_CD_STATE_CODE","CNTRY_CD_COUNTRY_TYPE_CODE", "MISC_CD_MISC_ID_CODE","DATE_OF_ISSUE","SMT_ID","BDY_PRT_BODY_PART_CODE","SMT_CD_SMT_CODE","DESCRIPTION","PHONE_ID", "PHO_TYP_CD_PHONE_TYPE_CODE","AREA","PREFIX","SUFFIX","EXT","PHONE_DATE","ADDR_ADDRESS_ID","BLD_CD_BUILD_CODE", "EYE_CD_EYE_CODE","HAIR_LNGTH_HAIR_LENGTH_CODE","SKN_CD_SKIN_CODE","FACE_HR_FACIAL_HAIR","HAIR_CD_HAIR_CODE", "HEIGHT","WEIGHT","GLASSES","PHYS_DESC_DATE","PHYS_DESC_ID" FROM PEOPLE_COMBO_PH_VW
 
Possibly Referenced Tables/Views:
PEOPLE_COMBO_ADR_PH_VW PEOPLE_COMBO_ADR_VW PEOPLE_COMBO_PH_VW 


Close relationships: