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


TABLE: MGDSYS.MGD_IDENCODING_CATEGORY_TAB

Object Details
Object Name: MGD_IDENCODING_CATEGORY_TAB
Object Type: TABLE
Owner: MGDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MGD_IDENCODING_CATEGORY$PK
  1. ColumnOWNER
  2. ColumnCATEGORY_ID
Indexes
Index Type Uniqueness Tablespace Column
MGD_IDENCODING_CATEGORY$PK NORMAL UNIQUE TablespaceSYSTEM ColumnOWNER
ColumnCATEGORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableMGD_IDENCODING_TYPE_TAB MGD_IDENCODING_TYPE$FK MGD_IDENCODING_CATEGORY_TAB MGD_IDENCODING_TYPE_TAB OWNER
MGD_IDENCODING_TYPE_TAB CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (64) Yes
CATEGORY_ID NUMBER (4) Yes
NAME VARCHAR2 (256) Yes
AGENCY VARCHAR2 (256)
VERSION VARCHAR2 (256)
URI VARCHAR2 (256)
Query Text

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


SELECT OWNER
,      CATEGORY_ID
,      NAME
,      AGENCY
,      VERSION
,      URI
FROM MGDSYS.MGD_IDENCODING_CATEGORY_TAB;

Dependencies

[top of page]

MGDSYS.MGD_IDENCODING_CATEGORY_TAB does not reference any database object

MGDSYS.MGD_IDENCODING_CATEGORY_TAB is referenced by following:

SchemaMGDSYS
ViewMGD_IDENCODING_CATEGORY
ViewMGD_USR_IDENCODING_CATEGORY