|
|
| 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 |
| XML_PARENT_ID |
number |
0 |
|
|
|
|
|
| STATUS_CODE |
varchar2 |
30 |
|
|
|
|
|
| TAG_CATEGORY_CODE |
varchar2 |
3 |
|
|
|
|
|
| XML_DOC_ID |
number |
0 |
|
|
|
|
|
| EJS_INDEX_ID |
number |
0 |
√ |
|
null |
|
|
| PARENT_KEY_VALUE |
varchar2 |
240 |
√ |
|
null |
|
|
| PARENT_TAG_NAME_KEY |
varchar2 |
240 |
√ |
|
null |
|
|
| XML_VALUE_ID |
number |
0 |
|
|
|
|
|
| TAG_NAME |
varchar2 |
80 |
|
|
|
|
|
| DOC_CATEGORY_CODE |
varchar2 |
3 |
|
|
|
|
|
| ROW_TAG_NAME |
varchar2 |
80 |
|
|
|
|
|
| XML_VALUE |
varchar2 |
4000 |
√ |
|
null |
|
|
| TAG_LABEL |
varchar2 |
80 |
√ |
|
null |
|
|
| ROW_TAG_ID |
number |
0 |
|
|
|
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT PT.XML_PARENT_ID XML_PARENT_ID
,PT.STATUS_CODE STATUS_CODE
,PT.TAG_CATEGORY_CODE TAG_CATEGORY_CODE
,PT.XML_DOC_ID XML_DOC_ID
,PT.EJS_INDEX_ID EJS_INDEX_ID
,PT.PARENT_KEY_VALUE PARENT_KEY_VALUE
,PT.PARENT_TAG_NAME_KEY PARENT_TAG_NAME_KEY
,TV.XML_VALUE_ID XML_VALUE_ID
,TV.TAG_NAME TAG_NAME
,RT.DOC_CATEGORY_CODE DOC_CATEGORY_CODE
,RT.ROW_TAG_NAME ROW_TAG_NAME
,TV.XML_VALUE XML_VALUE
,TV.TAG_LABEL TAG_LABEL
,TV.ROW_TAG_ID ROW_TAG_ID
FROM EJS_XML_PARENT_TAG_VALUES PT
,EJS_XML_TAG_VALUES TV
,EJS_XML_ROW_TAGS RT
WHERE PT.XML_PARENT_ID=TV.XML_PARENT_ID
AND TV.ROW_TAG_ID=RT.ROW_TAG_ID
Possibly Referenced Tables/Views:
