|
|
| 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 |
|
|
|
|
|
| TL_NO |
varchar2 |
6 |
|
|
|
|
|
| TL_EXT_NO |
varchar2 |
15 |
√ |
|
null |
|
|
| TL_TYPE |
number |
22 |
|
|
|
|
|
| DESCR |
varchar2 |
100 |
|
|
|
|
|
| HEADER |
varchar2 |
200 |
√ |
|
null |
|
|
| FOOTER |
varchar2 |
200 |
√ |
|
null |
|
|
| USER_ID |
number |
22 |
|
|
|
|
| USERS.USER_ID
|
Implied Constraint R |
|
| SERV_NO |
number |
4 |
√ |
|
null |
|
| SERVICE.SERV_NO
|
Implied Constraint R |
|
| STER_NO |
number |
4 |
√ |
|
null |
|
|
| COLOR_NO |
number |
4 |
√ |
|
null |
|
| COLOR.COLOR_NO
|
Implied Constraint R |
|
| CREATED |
date |
7 |
|
|
|
|
|
| VERSION |
number |
22 |
|
|
|
|
|
| STATUS |
number |
1 |
|
|
|
|
|
| IMGLNK |
varchar2 |
255 |
√ |
|
null |
|
|
| CHARGE_CODE |
varchar2 |
50 |
√ |
|
null |
|
|
| TOTAL |
number |
22 |
|
|
|
|
|
| STORAGE_LOCATION_NO |
number |
22 |
√ |
|
null |
|
|
| SOURCE_LOCATION_NO |
number |
22 |
√ |
|
null |
|
|
| DISPLAYMFR |
number |
1 |
√ |
|
null |
|
|
| HOT_IND |
char |
1 |
|
|
|
|
|
| STORAGE_BIN |
varchar2 |
7 |
√ |
|
null |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
View Definition:
SELECT CS1.TL_ID, CS1.TL_NO, CS1.TL_EXT_NO, CS1.TL_TYPE, CS1.DESCR, CS1.HEADER, CS1.FOOTER, CS1.USER_ID, CS1.SERV_NO, CS1.STER_NO, CS1.COLOR_NO, CS1.CREATED, CS1.VERSION, CS1.STATUS, CS1.IMGLNK, CS1.CHARGE_CODE, CS1.TOTAL, CS1.STORAGE_LOCATION_NO, CS1.SOURCE_LOCATION_NO, CS1.DISPLAYMFR, CS1.HOT_IND, CS1.STORAGE_BIN FROM TRAY_LIST CS1 WHERE CS1.VERSION = (SELECT MAX(VERSION) FROM TRAY_LIST WHERE TL_NO = CS1.TL_NO)
Possibly Referenced Tables/Views:
