|
|
| 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_DOC_ID |
number |
0 |
|
|
|
|
|
| DOCNAME |
varchar2 |
80 |
|
|
|
|
|
| STATUS_CODE |
varchar2 |
30 |
|
|
|
|
|
| REMARKS |
varchar2 |
255 |
√ |
|
null |
|
|
| DOC_CATEGORY_CODE |
varchar2 |
3 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| STATUS_DATE |
date |
7 |
√ |
|
null |
|
|
| BUSY_FLAG |
varchar2 |
1 |
√ |
|
null |
|
|
| AUTO_UPLOAD |
varchar2 |
1 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| KEY_NAME |
varchar2 |
80 |
|
|
|
|
|
| KEY_DESCRIPTION |
varchar2 |
80 |
√ |
|
null |
|
|
| KEY_VALUE |
varchar2 |
80 |
|
|
|
|
|
| SEARCHABLE |
varchar2 |
1 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
ED.XML_DOC_ID
, ED.DOCNAME
, ED.STATUS_CODE
, ED.REMARKS
, ED.DOC_CATEGORY_CODE
, ED.CREATOR_DATE
, ED.CREATOR_ID
, ED.STATUS_DATE
, ED.BUSY_FLAG
, CC.AUTO_UPLOAD
, ED.AGENCY_CODE
, DK.KEY_NAME
, DKC.KEY_DESCRIPTION
, DK.KEY_VALUE
, DKC.SEARCHABLE
FROM EJSXML_DOCS ED, XML_DOCUMENT_CATEGORY_CODES CC, EJS_XML_DOC_KEYS DK, EJS_XML_DOC_KEY_CODES DKC
WHERE ED.DOC_CATEGORY_CODE = CC.DOC_CATEGORY_CODE
AND ED.XML_DOC_ID = DK.XML_DOC_ID
AND DK.KEY_NAME = DKC.KEY_NAME
Possibly Referenced Tables/Views:
