|
|
| 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 |
| SERV_NO |
number |
4 |
√ |
|
null |
|
| SERVICE.SERV_NO
|
Implied Constraint R |
|
| TRAY_LIST_INSTR_LOC_ID |
number |
22 |
√ |
|
null |
|
|
| TRAY_LIST_NO |
varchar2 |
6 |
|
|
|
|
|
| TRAY_LIST_NAME |
varchar2 |
100 |
|
|
|
|
|
| TRAY_LIST_MAX_ID |
number |
22 |
|
|
|
|
|
| MAX_VERSION |
number |
22 |
|
|
|
|
|
| TOTAL_ITEMS |
number |
22 |
|
|
|
|
|
| LAST_REVISED |
date |
7 |
|
|
|
|
|
| TRAY_LIST_CREATION_DT |
date |
7 |
√ |
|
null |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
View Definition:
SELECT TL1.SERV_NO AS "SERV_NO", TL1.SOURCE_LOCATION_NO "TRAY_LIST_INSTR_LOC_ID", -- used for filtering based on user accessible location
TL1.TL_NO AS "TRAY_LIST_NO", TL1.DESCR AS "TRAY_LIST_NAME", TL1.TL_ID AS "TRAY_LIST_MAX_ID", TL1.VERSION AS "MAX_VERSION", TL1.TOTAL AS "TOTAL_ITEMS" , TL1.CREATED AS "LAST_REVISED", (SELECT CREATED FROM TRAY_LIST WHERE TL_NO = TL1.TL_NO AND VERSION = TL2.MIN_VERSION ) AS "TRAY_LIST_CREATION_DT" FROM TRAY_LIST TL1, (SELECT TL_NO, MIN(VERSION) AS MIN_VERSION, MAX(VERSION) AS VERSION FROM TRAY_LIST GROUP BY TL_NO) TL2 WHERE TL1.TL_NO = TL2.TL_NO AND TL1.VERSION = TL2.VERSION
Possibly Referenced Tables/Views:
