|
|
| 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 |
| TREEENTRYID |
number |
22 |
|
|
|
|
|
| ENTRYPARENT |
number |
22 |
√ |
|
null |
|
|
| ENTRYCATEGORY |
number |
22 |
|
|
|
|
|
| ENTRYPUBLIC |
number |
22 |
|
|
|
|
|
| ENTRYOWNER |
number |
22 |
√ |
|
null |
|
|
| ENTRYSTRING |
nvarchar2 |
200 |
|
|
|
|
|
| ENTRYDESC |
nvarchar2 |
100 |
√ |
|
null |
|
|
| ENTRYSUBTYPE |
number |
22 |
√ |
|
null |
|
|
| LVL |
number |
22 |
√ |
|
null |
|
|
| HIERARCHY |
varchar2 |
900 |
√ |
|
null |
|
|
| CREATIONDATE |
date |
7 |
√ |
|
null |
|
|
| ATTRID |
number |
22 |
√ |
|
null |
|
|
| ATTRCATEGORY |
number |
22 |
√ |
|
null |
|
|
| ATTRSTRINGVALUE |
nvarchar2 |
850 |
√ |
|
null |
|
|
| ATTRINTVALUE |
number |
22 |
√ |
|
null |
|
|
| ATTRFLOATVALUE |
number |
22 |
√ |
|
null |
|
|
| ATTRDATEVALUE |
date |
7 |
√ |
|
null |
|
|
| ATTRBINARYVALUE |
blob |
4000 |
√ |
|
null |
|
|
Analyzed at Thu Dec 13 15:47 CST 2012
|
View Definition:
SELECT A.TREEENTRYID, A.ENTRYPARENT, A.ENTRYCATEGORY, A.ENTRYPUBLIC, A.ENTRYOWNER, A.ENTRYSTRING, A.ENTRYDESC, A.ENTRYSUBTYPE, A.LVL, A.HIERARCHY, A.CREATIONDATE,
B.ATTRID, B.ATTRCATEGORY, B.ATTRSTRINGVALUE, B.ATTRINTVALUE, B.ATTRFLOATVALUE, B.ATTRDATEVALUE, B.ATTRBINARYVALUE
FROM ENPBATREE A, ENPENTRYATTR B WHERE A.TREEENTRYID = B.TREEENTRYID (+)
Possibly Referenced Tables/Views:
