View slot9.WORLD.TSTA.PERMIT_PROPERTIES_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_STATUS_CODE varchar2 30
PERMIT_REASON_CODE varchar2 30  √  null
PURCHASE_TYPE_CODE varchar2 30  √  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
INSPECTED_DATE date 7  √  null
NEXT_INSPECTION_DATE date 7  √  null
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
NUM_ROUNDS number 0  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT p.permit_id, p.permit_no, p.permit_type_code, p.permit_status_code, p.permit_reason_code, p.purchase_type_code, 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.inspected_date, p.next_inspection_date, pr.property_id, pr.property_type_code, pr.evidence, pr.document, pr.type_of_quantity, pr.primary_color, pr.secondary_color, pr.drug_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, pr.gun_act_code, pr.gun_typ_code, pr.num_rounds, p.agency_code FROM permits p, permit_properties pp, properties pr WHERE p.permit_id = pp.permit_id AND pr.property_id = pp.property_id
 
Possibly Referenced Tables/Views:
PERMIT_PROPERTIES PERMITS PROPERTIES 


Close relationships: