|
|
| 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 |
| K9_ID |
number |
0 |
|
|
|
|
|
| DOG_NAME |
varchar2 |
255 |
|
|
|
|
|
| SEX |
varchar2 |
1 |
√ |
|
null |
|
|
| EMPLOYEE_ID |
number |
0 |
√ |
|
null |
|
|
| HANDLER_NAME |
varchar2 |
257 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT dogs.k9_id,
dogs.dog_name,
dogs.sex,
dogs.employee_id,
enc_lname || ',' || enc_fname,
dogs.agency_code,
AGENCY_CODES.agency_desc
FROM K9_DOGS dogs, EMPLOYEES, AGENCY_CODES
WHERE EMPLOYEES.ejs_emp_id(+) = dogs.employee_id AND
AGENCY_CODES.agency_code(+) = dogs.agency_code
Possibly Referenced Tables/Views:
