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


TABLE: ORDDATA.ORDDCM_PRV_ATTRS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_PRV_ATTRS_PK
  1. ColumnPA_ID
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_PRV_ATTRS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPA_ID
ORDDCM_PRV_A_IDX1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnTAG
ORDDCM_PRV_A_IDX2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnDEFINER_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_PRV_ATTRS ORDDCM_PRV_ATTRS_FK1 TableORDDCM_DOCS ORDDCM_PRV_ATTRS DOC_ID
ORDDCM_PRV_ATTRS ORDDCM_PRV_ATTRS_FK2 TableORDDCM_VR_DT_MAP ORDDCM_PRV_ATTRS VR
TableORDDCM_DICT_ATTRS ORDDCM_DICT_ATTRS_FK2 ORDDCM_PRV_ATTRS ORDDCM_DICT_ATTRS 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;

Dependencies

[top of page]

ORDDATA.ORDDCM_PRV_ATTRS does not reference any database object

ORDDATA.ORDDCM_PRV_ATTRS is referenced by following:

SchemaORDSYS
Package BodyORD_DICOM_ADMIN_PRV - show dependent code