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

TABLE: ORDDATA.ORDDCM_CT_PRED_SET

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_CT_PS_PK
  1. ColumnPSID
Unique Key: ORDDCM_CT_PS_UQ
  1. ColumnNAME
  2. ColumnPSTYPE
  3. ColumnSUPER
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_CT_PS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPSID
ORDDCM_CT_PS_UQ NORMAL UNIQUE TablespaceSYSTEM ColumnNAME
ColumnPSTYPE
ColumnSUPER
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_CT_PRED_SET ORDDCM_CT_PS_FK1 TableORDDCM_CT_PRED ORDDCM_CT_PRED_SET PID
ORDDCM_CT_PRED_SET ORDDCM_CT_PS_FK2 TableORDDCM_CT_PRED_SET ORDDCM_CT_PRED_SET SUPER
ORDDCM_CT_PRED_SET ORDDCM_CT_PS_FK3 TableORDDCM_DOCS ORDDCM_CT_PRED_SET DOC_ID
TableORDDCM_CT_LOCATORPATHS ORDDCM_CT_LP_FK2 ORDDCM_CT_PRED_SET ORDDCM_CT_LOCATORPATHS PSID
TableORDDCM_CT_MACRO_DEP ORDDCM_CT_MD_FK1 ORDDCM_CT_PRED_SET ORDDCM_CT_MACRO_DEP PSID
TableORDDCM_CT_MACRO_DEP ORDDCM_CT_MD_FK2 ORDDCM_CT_PRED_SET ORDDCM_CT_MACRO_DEP DEP_PSID
TableORDDCM_CT_MACRO_PAR ORDDCM_CT_MP_FK ORDDCM_CT_PRED_SET ORDDCM_CT_MACRO_PAR PSID
TableORDDCM_CT_PRED_SET ORDDCM_CT_PS_FK2 ORDDCM_CT_PRED_SET ORDDCM_CT_PRED_SET SUPER
Columns
Name Datatype Length Mandatory Comments
PSID NUMBER
Yes
NAME VARCHAR2 (64)
PSTYPE NUMBER (1) Yes
PID NUMBER

STATUS NUMBER (1)
SUPER NUMBER

DOC_ID NUMBER

DESCRIPTION VARCHAR2 (1999)
Query Text

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


SELECT PSID
,      NAME
,      PSTYPE
,      PID
,      STATUS
,      SUPER
,      DOC_ID
,      DESCRIPTION
FROM ORDDATA.ORDDCM_CT_PRED_SET;

Dependencies

[top of page]

ORDDATA.ORDDCM_CT_PRED_SET does not reference any database object

ORDDATA.ORDDCM_CT_PRED_SET is referenced by following:

SchemaORDSYS
Package BodyORD_DICOM_ADMIN_PRV - show dependent code