|
|
| 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 |
| TL_ID |
number |
22 |
√ |
|
null |
|
|
| TL_NO |
varchar2 |
6 |
|
|
|
|
|
| TRAY_NO |
varchar2 |
5 |
|
|
|
|
| TRAY.TRAY_NO
|
Implied Constraint R |
|
| ASID |
varchar2 |
10 |
|
|
|
|
|
| FIRST_ASSM_TIME |
date |
7 |
√ |
|
null |
|
|
| NEXT_ASSM_TIME |
date |
7 |
√ |
|
null |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
View Definition:
SELECT TS.TL_ID, TL.TL_NO, TS.TRAY_NO, TS.TS_NO ASID, TS.ASSM_DT FIRST_ASSM_TIME, ( SELECT MIN(TS2.ASSM_DT) AS NEXT_ASSM_TIME FROM TRAYSET TS2, TRAY_LIST TL2 WHERE TS2.TL_ID = TL2.TL_ID AND TL2.TL_NO = TL.TL_NO AND TS2.TRAY_NO = TS.TRAY_NO AND TS2.ASSM_DT > TS.ASSM_DT ) NEXT_ASSM_TIME FROM TRAYSET TS, TRAY_LIST TL WHERE TS.TL_ID = TL.TL_ID AND TS.ASSM_DT IS NOT NULL
Possibly Referenced Tables/Views:
