|
|
| 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 |
| VEHICLE_ID |
number |
0 |
|
|
|
|
|
| UNIT_NUMBER |
varchar2 |
255 |
√ |
|
null |
|
|
| 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 |
|
|
| CURRENT_MILEAGE |
number |
0 |
√ |
|
null |
|
|
| LAST_SERVICE_DATE |
date |
7 |
√ |
|
null |
|
|
| NEXT_SERVICE_MILEAGE |
number |
0 |
√ |
|
null |
|
|
| NEXT_SERVICE_DATE |
date |
7 |
√ |
|
null |
|
|
| ASSIGNMENT_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
(SELECT DV.VEHICLE_ID,
DV.UNIT_NUMBER,
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),
EJS_FLEET_MGMT_SEARCH_PK.GET_MAX_VEHICLE_ODOMETER (DV.VEHICLE_ID),
(SELECT MAX (START_DATE)
FROM DV_SERVICE_RECORDS SR2
WHERE SR2.VEHICLE_ID = DV.VEHICLE_ID),
EJS_FLEET_MGMT_SEARCH_PK.GET_NEXT_SERVICE_MILES (DV.VEHICLE_ID,
DV.AGENCY_CODE),
EJS_FLEET_MGMT_SEARCH_PK.GET_NEXT_SERVICE_DATE (DV.VEHICLE_ID,
DV.AGENCY_CODE),
DV.ASSIGNMENT_CODE
FROM DEPARTMENT_VEHICLES DV)
Possibly Referenced Tables/Views:
