|
|
| 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 |
| REQUEST_ID |
number |
0 |
|
|
|
|
|
| UNIT_NUMBER |
varchar2 |
255 |
√ |
|
null |
|
|
| VEHICLE_ID |
number |
0 |
|
|
|
|
|
| VEHICLE_AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| VEHICLE_TYPE |
varchar2 |
100 |
√ |
|
null |
|
|
| VEHICLE_MAKE |
varchar2 |
100 |
√ |
|
null |
|
|
| VEHICLE_MODEL |
varchar2 |
100 |
√ |
|
null |
|
|
| VEHICLE_CATEGORY |
varchar2 |
4000 |
√ |
|
null |
|
|
| VEHICLE_CATEGORY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| VEHICLE_CATEGORY_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| VEHICLE_STATUS |
varchar2 |
4000 |
√ |
|
null |
|
|
| REQUEST_TYPE |
varchar2 |
4000 |
√ |
|
null |
|
|
| REQUEST_STATUS |
varchar2 |
4000 |
√ |
|
null |
|
|
| REQUEST_STATUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| REQUEST_LOGIN_NAME |
varchar2 |
4000 |
√ |
|
null |
|
|
| REQUEST_DATE |
date |
7 |
√ |
|
null |
|
|
| REVIEW_LOGIN_NAME |
varchar2 |
4000 |
√ |
|
null |
|
|
| REVIEW_DATE |
date |
7 |
√ |
|
null |
|
|
| REQUEST_DESCRIPTION |
varchar2 |
255 |
√ |
|
null |
|
|
| ASSIGNMENT_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
(
SELECT
SR.REQUEST_ID,
DV.UNIT_NUMBER,
SR.VEHICLE_ID,
DV.AGENCY_CODE,
(SELECT DESCRIPTION FROM ITEM_SUB_TYPE_CODES IST WHERE IST.TYPE_ID = DV.TYPE_ID),
(SELECT DESCRIPTION FROM ITEM_MAKE_CODES IMC WHERE IMC.MAKE_ID = DV.MAKE_ID),
(SELECT DESCRIPTION FROM ITEM_MODEL_CODES IMC WHERE IMC.MAKE_ID = DV.MAKE_ID AND IMC.MODEL_ID = DV.MODEL_ID),
(SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE=DV.VEH_CATEGORY_CODE_TYPE AND EC.CODE=DV.VEH_CATEGORY_CODE),
DV.VEH_CATEGORY_CODE,
DV.VEH_CATEGORY_CODE_TYPE,
(SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = DV.STATUS_CODE_TYPE AND EC.CODE = DV.STATUS_CODE),
REQUEST_TYPE.DESCRIPTION,
STATUS.DESCRIPTION,
STATUS.CODE,
GET_USER_NAME(SR.REQUEST_LOGIN_ID),
SR.REQUEST_DATE,
GET_USER_NAME(SR.REVIEW_LOGIN_ID),
SR.REVIEW_DATE,
SR.DESCRIPTION,
DV.ASSIGNMENT_CODE
FROM DV_SERVICE_REQUEST SR
INNER JOIN DEPARTMENT_VEHICLES DV ON SR.VEHICLE_ID = DV.VEHICLE_ID
LEFT OUTER JOIN EJS_CODES REQUEST_TYPE ON REQUEST_TYPE.CODE_TYPE = SR.REQUEST_TYPE_CODE_TYPE AND REQUEST_TYPE.CODE = SR.REQUEST_TYPE_CODE
LEFT OUTER JOIN EJS_CODES STATUS ON STATUS.CODE_TYPE = SR.STATUS_CODE_TYPE AND STATUS.CODE = SR.STATUS_CODE
)
Possibly Referenced Tables/Views:
