[Home] [Help] [Dependency Information]

TABLE: ORDDATA.ORDDCM_DOCS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_DOCS_PK

1. DOC_ID

Unique Key: ORDDCM_DOCS_UK1

1. DOC_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_DOCS_PK	NORMAL	UNIQUE	SYSTEM	DOC_ID
ORDDCM_DOCS_UK1	NORMAL	UNIQUE	SYSTEM	DOC_NAME
SYS_IL0000616487C00005$$	LOB	UNIQUE	SYSTEM

Foreign Keys

Table		Foreign Table	Foreign Key Column
ORDDCM_DOCS		ORDDCM_DOC_TYPES	ORDDCM_DOCS DOC_TYPE_ID
ORDDCM_ANON_ATTRS		ORDDCM_DOCS	ORDDCM_ANON_ATTRS DOC_ID
ORDDCM_ANON_RULES		ORDDCM_DOCS	ORDDCM_ANON_RULES DOC_ID
ORDDCM_CT_DAREFS		ORDDCM_DOCS	ORDDCM_CT_DAREFS DOC_ID
ORDDCM_CT_LOCATORPATHS		ORDDCM_DOCS	ORDDCM_CT_LOCATORPATHS DOC_ID
ORDDCM_CT_PRED_SET		ORDDCM_DOCS	ORDDCM_CT_PRED_SET DOC_ID
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS DOC_ID
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS REF_BY_DOC_NAME
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS DOC_NAME
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS REF_BY_DOC_ID
ORDDCM_MAPPING_DOCS		ORDDCM_DOCS	ORDDCM_MAPPING_DOCS DOC_ID
ORDDCM_PROTOCOL_METADATA		ORDDCM_DOCS	ORDDCM_PROTOCOL_METADATA DOC_NAME
ORDDCM_PRV_ATTRS		ORDDCM_DOCS	ORDDCM_PRV_ATTRS DOC_ID
ORDDCM_RT_PREF_PARAMS		ORDDCM_DOCS	ORDDCM_RT_PREF_PARAMS DOC_ID
ORDDCM_STD_ATTRS		ORDDCM_DOCS	ORDDCM_STD_ATTRS DOC_ID
ORDDCM_STORED_TAGS		ORDDCM_DOCS	ORDDCM_STORED_TAGS DOC_ID
ORDDCM_UID_DEFS		ORDDCM_DOCS	ORDDCM_UID_DEFS DOC_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT DOC_ID
,      DOC_NAME
,      DOC_TYPE_ID
,      DOC_CONTENT
,      ORACLE_INSTALL
,      CREATE_DATE
FROM ORDDATA.ORDDCM_DOCS;

Dependencies

[top of page]

SYS

STANDARD - show dependent code

XMLTYPE

ORDSYS

ORD_DICOM_ADMIN_PRV - show dependent code

SYS

VALIDATE_ORDIM - show dependent code