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


TABLE: ORDDATA.ORDDCM_PRV_ATTRS_WRK

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_PRV_ATTRS_W_PK
  1. ColumnPA_ID
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_PRV_ATTRS_W_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_PRV_ATTRS_WRK ORDDCM_PRV_ATTRS_W_FK1 TableORDDCM_DOCS_WRK ORDDCM_PRV_ATTRS_WRK DOC_ID
ORDDCM_PRV_ATTRS_WRK ORDDCM_PRV_ATTRS_W_FK2 TableORDDCM_VR_DT_MAP ORDDCM_PRV_ATTRS_WRK VR
TableORDDCM_DICT_ATTRS_WRK ORDDCM_DICT_ATTRS_W_FK2 ORDDCM_PRV_ATTRS_WRK ORDDCM_DICT_ATTRS_WRK PA_ID
Columns
Name Datatype Length Mandatory Comments
PA_ID NUMBER
Yes
TAG VARCHAR2 (8)
DEFINER_NAME VARCHAR2 (64) Yes
NAME VARCHAR2 (128) Yes
START_TAG VARCHAR2 (8)
END_TAG VARCHAR2 (8)
DEFINER_UID VARCHAR2 (128)
DOC_ID NUMBER
Yes
VR VARCHAR2 (5)
VM VARCHAR2 (128)
ISRETIRED NUMBER (1) Yes
ISWILDCARD NUMBER (1) Yes
Query Text

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


SELECT PA_ID
,      TAG
,      DEFINER_NAME
,      NAME
,      START_TAG
,      END_TAG
,      DEFINER_UID
,      DOC_ID
,      VR
,      VM
,      ISRETIRED
,      ISWILDCARD
FROM ORDDATA.ORDDCM_PRV_ATTRS_WRK;

Dependencies

[top of page]

ORDDATA.ORDDCM_PRV_ATTRS_WRK does not reference any database object

ORDDATA.ORDDCM_PRV_ATTRS_WRK is referenced by following:

SchemaORDSYS
Package BodyORD_DICOM_ADMIN_PRV - show dependent code