|
|
| 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 |
38 |
|
|
|
|
| VEHICLES.VEHICLE_ID
|
Implied Constraint R |
|
| VIN |
varchar2 |
20 |
√ |
|
null |
|
|
| YEAR |
number |
38 |
√ |
|
null |
|
|
| MAKE |
varchar2 |
100 |
√ |
|
null |
|
|
| MODEL |
varchar2 |
100 |
√ |
|
null |
|
|
| UNIT_NUMBER |
varchar2 |
255 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
V.VEHICLE_ID,
DV.VIN,
DV.YEAR,
IMC.DESCRIPTION,
IMOD.DESCRIPTION,
DV.UNIT_NUMBER
FROM DEPARTMENT_VEHICLES DV
INNER JOIN VEHICLES V ON DV.VEHICLE_ID = V.VEHICLE_ID
LEFT OUTER JOIN ITEM_MAKE_CODES IMC ON DV.MAKE_ID = IMC.MAKE_ID
LEFT OUTER JOIN ITEM_MODEL_CODES IMOD ON DV.MODEL_ID = IMOD.MODEL_ID
Possibly Referenced Tables/Views:
