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


TABLE: ORDDATA.ORDDCM_CT_PRED

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_CT_PRED_PK
  1. ColumnPID
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_CT_PRED_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPID
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_CT_PRED ORDDCM_CT_PRED_FK2 TableORDDCM_CT_PRED ORDDCM_CT_PRED REF_PID
ORDDCM_CT_PRED ORDDCM_CT_PRED_FK1 TableORDDCM_CT_PRED ORDDCM_CT_PRED FPID
TableORDDCM_CT_ACTION ORDDCM_CT_A_FK1 ORDDCM_CT_PRED ORDDCM_CT_ACTION PID
TableORDDCM_CT_PRED ORDDCM_CT_PRED_FK1 ORDDCM_CT_PRED ORDDCM_CT_PRED FPID
TableORDDCM_CT_PRED ORDDCM_CT_PRED_FK2 ORDDCM_CT_PRED ORDDCM_CT_PRED REF_PID
TableORDDCM_CT_PRED_OPRD ORDDCM_CT_PO_FK ORDDCM_CT_PRED ORDDCM_CT_PRED_OPRD PID
TableORDDCM_CT_PRED_PAR ORDDCM_CT_PP_FK ORDDCM_CT_PRED ORDDCM_CT_PRED_PAR PID
TableORDDCM_CT_PRED_SET ORDDCM_CT_PS_FK1 ORDDCM_CT_PRED ORDDCM_CT_PRED_SET PID
Columns
Name Datatype Length Mandatory Comments
PID NUMBER
Yes
FPID NUMBER

POS NUMBER (3) Yes
REF_PID NUMBER

OP NUMBER (3)
DESCRIPTION VARCHAR2 (1999)
Query Text

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


SELECT PID
,      FPID
,      POS
,      REF_PID
,      OP
,      DESCRIPTION
FROM ORDDATA.ORDDCM_CT_PRED;

Dependencies

[top of page]

ORDDATA.ORDDCM_CT_PRED does not reference any database object

ORDDATA.ORDDCM_CT_PRED is referenced by following:

SchemaORDSYS
Package BodyORD_DICOM_ADMIN_PRV - show dependent code