View slot9.WORLD.TSTA.FLDINT_ADD_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
FLDINT_ID number 0
FIELD_INTERVIEWS.FLDINT_ID Implied Constraint R
FLDINT_DATE date 7
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE Implied Constraint R
SUMMARY varchar2 2000  √  null
AGENCY_ONLY_YN varchar2 1  √  null
SECURITY_LEVEL number 0  √  null
INTELL_ONLY_YN varchar2 1  √  null
ADDRESS_ID number 0
ADDRESSES.ADDRESS_ID Implied Constraint R
STREET_NUMBER varchar2 10  √  null
DIRCT_CD_DIRECTION_CODE varchar2 30  √  null
STREET_NAME varchar2 40  √  null
STREET_CD_STREET_TYPE_CODE_COD varchar2 30  √  null
ADDR_SC_ADDRESS_SUBTYPE_CODE varchar2 30  √  null
SUB_NUMBER varchar2 50  √  null
INTRSECT1_STREET_NUMBER varchar2 10  √  null
INTRSECT1_DIR varchar2 30  √  null
INTRSECT1_NAME varchar2 40  √  null
ADDITIONAL_INFO varchar2 255  √  null
BEAT varchar2 30  √  null
SUB_BEAT varchar2 30  √  null
CITY varchar2 40  √  null
STATE_CD_STATE_CODE varchar2 30  √  null
ZIP5 varchar2 30  √  null
ZIP4 number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT F.FLDINT_ID , F.FLDINT_DATE , F.AGENCY_CODE , F.SUMMARY , F.AGENCY_ONLY_YN , F.SECURITY_LEVEL , F.INTELL_ONLY_YN , FA.ADDRESS_ID , A.STREET_NUMBER , A.DIRCT_CD_DIRECTION_CODE , A.STREET_NAME , A.STREET_CD_STREET_TYPE_CODE , A.ADDR_SC_ADDRESS_SUBTYPE_CODE , A.SUB_NUMBER , A.INTRSECT1_STREET_NUMBER , A.INTRSECT1_DIR , A.INTRSECT1_NAME , FA.FI_ADDR_COMMENT , A.BEAT , A.SUB_BEAT , A.CITY , A.STATE_CD_STATE_CODE , A.ZIP5 , A.ZIP4 FROM FIELD_INTERVIEWS F , ADDRESSES A , FLDINT_ADDRESSES FA WHERE FA.ADDRESS_ID = A.ADDRESS_ID AND FA.FLDINT_ID = F.FLDINT_ID
 
Possibly Referenced Tables/Views:
ADDRESSES FIELD_INTERVIEWS FLDINT_ADDRESSES 


Close relationships: