View slot9.WORLD.TSTA.JS_PERMIT_PROPERTY_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
PERMIT_ID number 0
PERMITS.PERMIT_ID Implied Constraint R
PERMIT_NO varchar2 40  √  null
PERMIT_TYPE_CODE varchar2 30
PERMIT_TYPE_DESC varchar2 4000  √  null
PERMIT_STATUS_CODE varchar2 30
PERMIT_STATUS_DESC varchar2 4000  √  null
PERMIT_REASON_CODE varchar2 30  √  null
PERMIT_REASON_DESC varchar2 4000  √  null
APP_DATE date 7  √  null
ISSUED_BY varchar2 255  √  null
ISSUE_DATE date 7  √  null
PROCESS_DATE date 7  √  null
PROCESSED_BY varchar2 30  √  null
EXPIRE_DATE date 7  √  null
REVIEW_DATE date 7  √  null
REVIEWED_BY varchar2 30  √  null
COMMENTS varchar2 255  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
AGENCY_DESC varchar2 40  √  null
PURCHASE_TYPE_CODE varchar2 30  √  null
PURCHASE_TYPE_DESC varchar2 4000  √  null
NEXT_INSPECTION_DATE date 7  √  null
INSPECTED_DATE date 7  √  null
INSPECTED_BY varchar2 30  √  null
NEXT_REVIEW_DATE date 7  √  null
PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID Implied Constraint R
PROPERTY_TYPE_CODE varchar2 30
PROPERTY_TYPE_DESC varchar2 80  √  null
EVIDENCE varchar2 1
DOCUMENT varchar2 30
TYPE_OF_QUANTITY varchar2 30  √  null
PRIMARY_COLOR varchar2 30  √  null
PRIMARY_COLOR_DESC varchar2 4000  √  null
SECONDARY_COLOR varchar2 30  √  null
SECONDARY_COLOR_DESC varchar2 4000  √  null
DRUG_TYPE varchar2 30  √  null
DRUG_TYPE_DESC varchar2 4000  √  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
CALGAG_DESC varchar2 4000  √  null
GUN_ACT_CODE varchar2 30  √  null
GUN_ACT_DESC varchar2 4000  √  null
GUN_TYP_CODE varchar2 30  √  null
GUN_TYP_DESC varchar2 4000  √  null
NUM_ROUNDS number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT P.PERMIT_ID , P.PERMIT_NO , P.PERMIT_TYPE_CODE , (SELECT TYP.DESCRIPTION FROM EJS_CODES TYP WHERE TYP.CODE = P.PERMIT_TYPE_CODE AND TYP.CODE_TYPE = P.PERMIT_TYPE_CODE_TYPE) , P.PERMIT_STATUS_CODE , (SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE = P.PERMIT_STATUS_CODE AND ST.CODE_TYPE = P.PERMIT_STATUS_CODE_TYPE) , P.PERMIT_REASON_CODE , (SELECT RSN.DESCRIPTION FROM EJS_CODES RSN WHERE RSN.CODE = P.PERMIT_REASON_CODE AND RSN.CODE_TYPE = P.PERMIT_REASON_CODE_TYPE) , P.APP_DATE , P.ISSUED_BY , P.ISSUE_DATE , P.PROCESS_DATE , P.PROCESSED_BY , P.EXPIRE_DATE , P.REVIEW_DATE , P.REVIEWED_BY , P.COMMENTS , P.CREATOR_ID , P.CREATOR_DATE , P.UPDATOR_ID , P.UPDATOR_DATE , P.REC_ID , P.AGENCY_CODE , (SELECT AG.AGENCY_DESC FROM AGENCY_CODES AG WHERE AG.AGENCY_CODE = P.AGENCY_CODE) , P.PURCHASE_TYPE_CODE , (SELECT PUR.DESCRIPTION FROM EJS_CODES PUR WHERE PUR.CODE = P.PURCHASE_TYPE_CODE AND PUR.CODE_TYPE = P.PURCHASE_TYPE_CODE_TYPE) , P.NEXT_INSPECTION_DATE , P.INSPECTED_DATE , P.INSPECTED_BY , P.NEXT_REVIEW_DATE , pr.property_id , pr.property_type_code , (SELECT PTC.PROPERTY_TYPE_DESC FROM PROPERTY_TYPE_CODES PTC WHERE PTC.PROPERTY_TYPE = PR.PROPERTY_TYPE_CODE) , pr.evidence , pr.document , pr.type_of_quantity , pr.primary_color , (SELECT PC.DESCRIPTION FROM EJS_CODES PC WHERE PC.CODE = PR.PRIMARY_COLOR AND PC.CODE_TYPE = PR.PRIMARY_COLOR_TYPE) , pr.secondary_color , (SELECT SC.DESCRIPTION FROM EJS_CODES SC WHERE SC.CODE = PR.SECONDARY_COLOR AND SC.CODE_TYPE = PR.SECONDARY_COLOR_TYPE) , pr.drug_type , (SELECT DT.DESCRIPTION FROM EJS_CODES DT WHERE DT.CODE = PR.DRUG_TYPE AND DT.CODE_TYPE = PR.DRUG_TYPE_TYPE) , pr.quantity , pr.description , pr.make , pr.model , pr.serial_number , pr.VALUE , pr.misc , pr.document_number , pr.bank , pr.document_date , pr.account_name , pr.account_number , pr.payable_to , pr.amount , pr.endorsee , pr.barrel_length , pr.calgag_code , (SELECT C.DESCRIPTION FROM EJS_CODES C WHERE C.CODE = PR.CALGAG_CODE AND C.CODE_TYPE = PR.CALGAG_CODE_TYPE) , pr.gun_act_code , (SELECT G.DESCRIPTION FROM EJS_CODES G WHERE G.CODE = PR.GUN_ACT_CODE AND G.CODE_TYPE = PR.GUN_ACT_CODE_TYPE) , pr.gun_typ_code , (SELECT GT.DESCRIPTION FROM EJS_CODES GT WHERE GT.CODE = PR.GUN_TYP_CODE AND GT.CODE_TYPE = PR.GUN_ACT_CODE_TYPE) , pr.num_rounds FROM PERMITS P INNER JOIN PERMIT_PROPERTIES PP ON P.PERMIT_ID = PP.PERMIT_ID INNER JOIN PROPERTIES PR ON PP.PROPERTY_ID = PR.PROPERTY_ID
 
Possibly Referenced Tables/Views:
AGENCY_CODES EJS_CODES PERMIT_PROPERTIES PERMITS PROPERTIES PROPERTY_TYPE_CODES 


Close relationships: