View slot9.WORLD.TSTA.PROPERTY_DETAILS_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
PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID Implied Constraint R
PROPERTY_TYPE_CODE varchar2 30
EVIDENCE varchar2 1
DOCUMENT varchar2 30
TYPE_OF_QUANTITY varchar2 30  √  null
PRIMARY_COLOR varchar2 30  √  null
SECONDARY_COLOR varchar2 30  √  null
DRUG_TYPE varchar2 30  √  null
QUANTITY number 20,3  √  null
DESCRIPTION varchar2 2500  √  null
MAKE varchar2 20  √  null
MODEL varchar2 25  √  null
SERIAL_NUMBER varchar2 25  √  null
VALUE number 11,2  √  null
MISC varchar2 160  √  null
DOCUMENT_NUMBER varchar2 6  √  null
BANK varchar2 40  √  null
DOCUMENT_DATE date 7  √  null
ACCOUNT_NAME varchar2 40  √  null
ACCOUNT_NUMBER number 16  √  null
PAYABLE_TO varchar2 40  √  null
AMOUNT number 12,2  √  null
ENDORSEE varchar2 40  √  null
BARREL_LENGTH varchar2 20  √  null
CALGAG_CODE varchar2 30  √  null
GUN_ACT_CODE varchar2 30  √  null
GUN_TYP_CODE varchar2 30  √  null
PROP_DTL_TYPE varchar2 6
PROPERTY_DETAIL_TYPE_CODES.PROP_DTL_TYPE Implied Constraint R
PD_COMMENT varchar2 255  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT P.PROPERTY_ID ,P.PROPERTY_TYPE_CODE ,P.EVIDENCE ,P.DOCUMENT ,P.TYPE_OF_QUANTITY ,P.PRIMARY_COLOR ,P.SECONDARY_COLOR ,P.DRUG_TYPE ,P.QUANTITY ,P.DESCRIPTION ,P.MAKE ,P.MODEL ,P.SERIAL_NUMBER ,P.VALUE ,P.MISC ,P.DOCUMENT_NUMBER ,P.BANK ,P.DOCUMENT_DATE ,P.ACCOUNT_NAME ,P.ACCOUNT_NUMBER ,P.PAYABLE_TO ,P.AMOUNT ,P.ENDORSEE ,P.BARREL_LENGTH ,P.CALGAG_CODE ,P.GUN_ACT_CODE ,P.GUN_TYP_CODE ,PD.PROP_DTL_TYPE ,PD.PD_COMMENT FROM PROPERTIES P , PROPERTY_DETAILS PD WHERE P.PROPERTY_ID = PD.PROPERTY_ID
 
Possibly Referenced Tables/Views:
PROPERTIES PROPERTY_DETAILS 


Close relationships: