DBA Data[Home] [Help] [Dependency Information]


TABLE: ORDDATA.ORDDCM_STORED_TAGS_WRK

Object Details
Object Name: ORDDCM_STORED_TAGS_WRK
Object Type: TABLE
Owner: ORDDATA
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_STORED_TAGS_W_PK1
  1. ColumnSTID
Unique Key: ORDDCM_STORED_TAGS_W_UK1
  1. ColumnATTR_TAG
  2. ColumnDOC_ID
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_STORED_TAGS_W_PK1 NORMAL UNIQUE TablespaceSYSTEM ColumnSTID
ORDDCM_STORED_TAGS_W_UK1 NORMAL UNIQUE TablespaceSYSTEM ColumnATTR_TAG
ColumnDOC_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_STORED_TAGS_WRK ORDDCM_STORED_TAGS_W_FK1 TableORDDCM_DOCS_WRK ORDDCM_STORED_TAGS_WRK DOC_ID
Columns
Name Datatype Length Mandatory Comments
STID NUMBER
Yes
ATTR_TAG VARCHAR2 (1999) Yes
DOC_ID NUMBER
Yes
Query Text

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


SELECT STID
,      ATTR_TAG
,      DOC_ID
FROM ORDDATA.ORDDCM_STORED_TAGS_WRK;

Dependencies

[top of page]

ORDDATA.ORDDCM_STORED_TAGS_WRK does not reference any database object

ORDDATA.ORDDCM_STORED_TAGS_WRK is referenced by following:

SchemaORDSYS
Package BodyORD_DICOM_ADMIN_PRV - show dependent code