|
|
| 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 |
| 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_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 |
|
|
| PERMIT_ROLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PERMIT_ROLE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| BUSINESS_NAME |
varchar2 |
80 |
|
|
|
|
|
| BTC_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| BTC_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| BUSINESS_ID |
varchar2 |
30 |
√ |
|
null |
|
|
| BUSINESS_NUMBER |
number |
0 |
|
|
|
|
|
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
, PB.permit_role_code
, (SELECT R.DESCRIPTION FROM EJS_CODES R WHERE R.CODE = PB.PERMIT_ROLE_CODE AND R.CODE_TYPE = PB.PERMIT_ROLE_CODE_TYPE)
, B.BUSINESS_NAME
, B.BTC_TYPE_CODE
, (SELECT btc.DESCRIPTION FROM EJS_CODES btc WHERE btc.CODE = B.BTC_TYPE_CODE AND btc.CODE_TYPE = B.BTC_TYPE_CODE_TYPE)
, B.BUSINESS_ID
, B.BUSINESS_NUMBER
FROM PERMITS P
INNER JOIN PERMIT_BUSINESSES PB ON P.PERMIT_ID = PB.PERMIT_ID
INNER JOIN BUSINESSES B ON PB.BUSINESS_NUMBER = B.BUSINESS_NUMBER
Possibly Referenced Tables/Views:
