|
|
| 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 |
| TRAY_NO |
varchar2 |
5 |
|
|
|
|
| TRAY.TRAY_NO
|
Implied Constraint R |
|
| TS_NO |
varchar2 |
10 |
|
|
|
|
|
| ASM_TIME |
date |
7 |
|
|
|
|
|
| ACTIVITY |
number |
22 |
|
|
|
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
View Definition:
SELECT TRAYSET.TRAY_NO, ASSEMBLY.TS_NO, ASSEMBLY.ASM_TIME, ASSEMBLY.ACTIVITY FROM ASSEMBLY, TRAYSET WHERE TRAYSET.TS_NO = ASSEMBLY.TS_NO AND ASSEMBLY.ACTIVITY IN (12,11,3,6)
Possibly Referenced Tables/Views:
