|
|
| 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 |
|
|
| TRAYSET_BIN |
varchar2 |
7 |
√ |
|
null |
|
|
| TRAY_ID |
number |
22 |
|
|
|
|
|
| TRAY_TYPE |
number |
22 |
√ |
|
null |
|
|
| TL_NO |
varchar2 |
6 |
√ |
|
null |
|
|
| HOT_TRAY_IND |
char |
1 |
|
|
|
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
View Definition:
SELECT TS_ID, TS_NO, TS_TIME, TS_TYPE, TRAY.TRAY_NO, TL_ID, ASSM_LOC_NO, USER_ID, CREAT_DT, ASSM_DT, MOD_DT, TOTAL, STATUS, HOLD_IND, TRAYSET_BIN, TRAY_ID, TRAY_TYPE, TL_NO, HOT_TRAY_IND FROM TRAYSET, TRAY WHERE TRAYSET.TRAY_NO = TRAY.TRAY_NO
Possibly Referenced Tables/Views:
