|
|
| 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 |
| COURSE_INCSTANCE_ID |
number |
0 |
|
|
|
|
|
| COURSE_NAME |
varchar2 |
100 |
|
|
|
|
|
| AGENCY_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| LOCATION |
varchar2 |
100 |
√ |
|
null |
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| START_DATE_STR |
varchar2 |
10 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
(
SELECT
CI.ID AS COURSE_INSTANCE_ID,
CI.NAME AS COURSE_NAME,
AC.AGENCY_DESC AS AGENCY_NAME,
CI.LOCATION AS LOCATION,
CI.START_DATE_TIME AS START_DATE,
TO_CHAR(CI.START_DATE_TIME,'MM/DD/YYYY') AS START_DATE_STR,
CI.AGENCY_CODE AS AGENCY_CODE
FROM COURSE_INSTANCE CI
LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = CI.AGENCY_CODE
WHERE
( CI.START_DATE_TIME IS NULL OR
(CI.START_DATE_TIME IS NOT NULL AND CI.START_DATE_TIME > SYSDATE )
)
AND CI.ACTIVE_FLAG = 'Y'
)
Possibly Referenced Tables/Views:
