|
|
| 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 |
| TS_ID |
number |
22 |
|
|
|
|
|
| TS_NO |
varchar2 |
10 |
|
|
|
|
|
| TS_TIME |
date |
7 |
|
|
|
|
|
| TS_TYPE |
number |
22 |
|
|
|
|
|
| TRAY_NO |
varchar2 |
5 |
|
|
|
|
| TRAY.TRAY_NO
|
Implied Constraint R |
|
| TL_ID |
number |
22 |
√ |
|
null |
|
|
| ASSM_LOC_NO |
number |
22 |
√ |
|
null |
|
|
| USER_ID |
number |
22 |
|
|
|
|
| USERS.USER_ID
|
Implied Constraint R |
|
| CREAT_DT |
date |
7 |
√ |
|
null |
|
|
| ASSM_DT |
date |
7 |
√ |
|
null |
|
|
| MOD_DT |
date |
7 |
√ |
|
null |
|
|
| TOTAL |
number |
22 |
|
|
|
|
|
| STATUS |
number |
22 |
|
|
|
|
|
| HOLD_IND |
char |
1 |
√ |
|
null |
|
|
| ON_HOLD_COMMENT |
varchar2 |
1000 |
√ |
|
null |
|
|
| COMMENTS |
varchar2 |
1000 |
√ |
|
null |
|
|
| TRAYSET_BIN |
varchar2 |
7 |
√ |
|
null |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
View Definition:
SELECT TS."TS_ID",TS."TS_NO",TS."TS_TIME",TS."TS_TYPE",TS."TRAY_NO",TS."TL_ID",TS."ASSM_LOC_NO",TS."USER_ID",TS."CREAT_DT",TS."ASSM_DT",TS."MOD_DT",TS."TOTAL",TS."STATUS",TS."HOLD_IND",TS."ON_HOLD_COMMENT",TS."COMMENTS",TS."TRAYSET_BIN" FROM TRAYSET TS, ( SELECT TRAY_NO, MAX(TS_ID) AS TS_ID FROM TRAYSET GROUP BY TRAY_NO ) CURRENT_TS WHERE TS.TS_ID = CURRENT_TS.TS_ID
Possibly Referenced Tables/Views:
