|
|
| 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 |
|
| VMA_VEHICLE_MAKE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| VMO_VEHICLE_MODEL_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| VST_VEHICLE_STYLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| YEAR |
number |
38 |
√ |
|
null |
|
|
| VIN |
varchar2 |
20 |
√ |
|
null |
|
|
| BOTTOM_COLOR |
varchar2 |
30 |
√ |
|
null |
|
|
| TOP_COLOR |
varchar2 |
30 |
√ |
|
null |
|
|
| LIC_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| LIC_STATE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| LIC_YEAR |
number |
4 |
√ |
|
null |
|
|
| LIC_NUMBER |
varchar2 |
12 |
√ |
|
null |
|
|
| MISC_ID |
varchar2 |
20 |
√ |
|
null |
|
|
| COND_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DAMAGE |
varchar2 |
240 |
√ |
|
null |
|
|
| DAMAGE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PERSON_ID |
number |
38 |
|
|
|
|
|
| ROLE_CODE |
varchar2 |
30 |
|
|
|
|
|
| LNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| FNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| MNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| DOB |
date |
7 |
√ |
|
null |
|
|
| NME_TYP_NAME_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| TITLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SLNAME |
varchar2 |
4 |
√ |
|
null |
|
|
| SFNAME |
varchar2 |
4 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT v.vehicle_id, v.vma_vehicle_make_code, v.vmo_vehicle_model_code,
v.vst_vehicle_style_code, v.YEAR, v.vin, vd.bottom_color,
vd.top_color, vd.lic_type_code, vd.lic_state_code, vd.lic_year,
vd.lic_number, vd.misc_id, vd.cond_code, vd.damage, vd.damage_code,
pv.person_id, pv.role_code, m.lname, m.fname, m.mname, m.dob,
m.name_type_code nme_typ_name_type_code, m.title_code, m.slname,
m.sfname
FROM vehicles v,
vehicle_descriptions vd,
people_vehicles pv,
master_names m
WHERE vd.vehicle_id = v.vehicle_id
AND pv.vehicle_id = v.vehicle_id
AND pv.person_id = m.per_person_id
Possibly Referenced Tables/Views:
