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

TABLE: ORDSYS.ORDDCM_CT_PRED_SET_WRK

Object Details
Object Name: ORDDCM_CT_PRED_SET_WRK
Object Type: TABLE
Owner: ORDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: ORDDCM_CT_PS_W_PK
  1. ColumnPSID
Unique Key: ORDDCM_CT_PS_W_UQ
  1. ColumnNAME
  2. ColumnPSTYPE
  3. ColumnSUPER
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_CT_PS_W_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPSID
ORDDCM_CT_PS_W_UQ NORMAL UNIQUE TablespaceSYSTEM ColumnNAME
ColumnPSTYPE
ColumnSUPER
Foreign Keys
Table
Foreign Table Foreign Key Column
ORDDCM_CT_PRED_SET_WRK ORDDCM_CT_PS_W_FK2 TableORDDCM_CT_PRED_SET_WRK ORDDCM_CT_PRED_SET_WRK SUPER
ORDDCM_CT_PRED_SET_WRK ORDDCM_CT_PS_W_FK1 TableORDDCM_CT_PRED_WRK ORDDCM_CT_PRED_SET_WRK PID
TableORDDCM_CT_MACRO_PAR_WRK ORDDCM_CT_MP_W_FK ORDDCM_CT_PRED_SET_WRK ORDDCM_CT_MACRO_PAR_WRK PSID
TableORDDCM_CT_PRED_SET_WRK ORDDCM_CT_PS_W_FK2 ORDDCM_CT_PRED_SET_WRK ORDDCM_CT_PRED_SET_WRK SUPER
Columns
Name Datatype Length Mandatory Comments
PSID NUMBER (38) Yes
NAME VARCHAR2 (64)
PSTYPE NUMBER (1) Yes
PID NUMBER (38)
SUPER NUMBER (38)
DESCRIPTION VARCHAR2 (1999)
Query Text

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


SELECT PSID
,      NAME
,      PSTYPE
,      PID
,      SUPER
,      DESCRIPTION
FROM ORDSYS.ORDDCM_CT_PRED_SET_WRK;

Dependencies

[top of page]

ORDSYS.ORDDCM_CT_PRED_SET_WRK does not reference any database object

ORDSYS.ORDDCM_CT_PRED_SET_WRK is not referenced by any database object