Table slot9.WORLD.TSTA.PERMITS
This table store the permit information created in the application
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
JS_PERMIT_BUSINESS_VW.PERMIT_ID Implied Constraint R
JS_PERMIT_PEOPLE_VW.PERMIT_ID Implied Constraint R
JS_PERMIT_PROPERTY_VW.PERMIT_ID Implied Constraint R
JS_PERMIT_VEHICLE_VW.PERMIT_ID Implied Constraint R
JS_PERMITS_VW.PERMIT_ID Implied Constraint R
PERMIT_ATTACHMENTS.PERMIT_ID PRMTATT_PRMT_FK C
PERMIT_BUSINESSES.PERMIT_ID PRMB_PRMT_FK C
PERMIT_BUSINESSES_VW.PERMIT_ID Implied Constraint R
PERMIT_IMAGES.PERMIT_ID PRMTIMA_PRMT_FK C
PERMIT_PEOPLE.PERMIT_ID PRMP_PRMT_FK C
PERMIT_PEOPLE_VW.PERMIT_ID Implied Constraint R
PERMIT_PROPERTIES.PERMIT_ID PRMPRP_PRMT_FK C
PERMIT_PROPERTIES_VW.PERMIT_ID Implied Constraint R
PERMIT_VEHICLES.PERMIT_ID PERMV_PRMT_FK C
PERMIT_VEHICLES_VW.PERMIT_ID Implied Constraint R
SAFETY_INSPECTIONS.PERMIT_ID SI_PRMT_FK R
Permit ID Number - Primary Key Hidden from user
PERMIT_NO varchar2 40  √  null Permit Number
PERMIT_TYPE_CODE varchar2 30
EJS_CODES.CODE PRMT_PERMIT_TYPE_C_EJS_CODE_FK R
Permit Type Code
PERMIT_STATUS_CODE varchar2 30
EJS_CODES.CODE PRMT_PERMIT_STATUS_EJS_CODE_FK R
Permit Status Code
PERMIT_REASON_CODE varchar2 30  √  null
EJS_CODES.CODE PRMT_PERMIT_REASON_EJS_CODE_FK R
Permit Reason Code
APP_DATE date 7  √  null Permit Application Date
ISSUED_BY varchar2 255  √  null Permit Issued By
ISSUE_DATE date 7  √  null Date Permit Issued
PROCESS_DATE date 7  √  null Date Permit Processed
PROCESSED_BY varchar2 30  √  null Processed By - User ID
EXPIRE_DATE date 7  √  null Date Permit Expires
REVIEW_DATE date 7  √  null Date Reviewed
REVIEWED_BY varchar2 30  √  null Reviewed By - User ID
COMMENTS varchar2 255  √  null General Comments
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
PERMIT_REASON_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRMT_PERMIT_REASON_EJS_CODE_FK R
PERMIT_STATUS_CODE_TYPE varchar2 30  √  'PERMIT_STATUS_CODES'
EJS_CODES.CODE_TYPE PRMT_PERMIT_STATUS_EJS_CODE_FK R
PERMIT_TYPE_CODE_TYPE varchar2 30  √  'PERMIT_TYPE_CODES'
EJS_CODES.CODE_TYPE PRMT_PERMIT_TYPE_C_EJS_CODE_FK R
REC_ID number 0  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE PRMT_AGNCY_CD_FK R
PURCHASE_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PRMT_PURCHASE_TYPE_EJS_CODE_FK R
PURCHASE_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE PRMT_PURCHASE_TYPE_EJS_CODE_FK R
NEXT_INSPECTION_DATE date 7  √  null
INSPECTED_DATE date 7  √  null
INSPECTED_BY varchar2 30  √  null
NEXT_REVIEW_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PERMIT_ID" IS NOT NULL PRMT_PERMIT_ID_NN
"PERMIT_STATUS_CODE" IS NOT NULL PRMT_PERMIT_STATUS_CODE_NN
"PERMIT_TYPE_CODE" IS NOT NULL PRMT_PERMIT_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
PERMIT_ID Primary key Asc PRMT_PK
AGENCY_CODE Performance Asc PRMT_AGNCY_CD_FK_I
PERMIT_REASON_CODE_TYPE + PERMIT_REASON_CODE Performance Asc/Asc PRMT_PERMIT_REASON_EJS_CODE_I
PERMIT_STATUS_CODE_TYPE + PERMIT_STATUS_CODE Performance Asc/Asc PRMT_PERMIT_STATUS_EJS_CODE_I
PERMIT_TYPE_CODE_TYPE + PERMIT_TYPE_CODE Performance Asc/Asc PRMT_PERMIT_TYPE_C_EJS_CODE_I
PERMIT_REASON_CODE Performance Asc PRMT_PRMRSCD_FK_I
PERMIT_STATUS_CODE Performance Asc PRMT_PRMSCD_FK_I
PERMIT_TYPE_CODE Performance Asc PRMT_PRMTCD_FK_I
PURCHASE_TYPE_CODE_TYPE + PURCHASE_TYPE_CODE Performance Asc/Asc PRMT_PURCH_TYPE_EJS_CODE_FK_I

Close relationships  within of separation: