[Home] [Help] [Dependency Information]
Object Name: | MGD_IDENCODING_TYPE_TAB |
---|---|
Object Type: | TABLE |
Owner: | MGDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENCODING_TYPE_UIDX | NORMAL | UNIQUE | SYSTEM |
OWNER
TYPE_NAME PARTITION_VALUE CATEGORY_ID |
MGD_IDENCODING_TYPE$PK | NORMAL | UNIQUE | SYSTEM |
OWNER
TYPE_ID |
Table | |
Foreign Table | Foreign Key Column | MGD_IDENCODING_TYPE_TAB | MGD_IDENCODING_CATEGORY_TAB |
MGD_IDENCODING_TYPE_TAB
OWNER
MGD_IDENCODING_TYPE_TAB CATEGORY_ID |
MGD_IDENCODING_COMP_TAB | MGD_IDENCODING_TYPE_TAB |
MGD_IDENCODING_COMP_TAB
OWNER
MGD_IDENCODING_COMP_TAB TYPE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (64) | Yes | |
TYPE_ID | NUMBER | (6) | Yes | |
TYPE_NAME | VARCHAR2 | (32) | ||
PARTITION_VALUE | NUMBER | (1) | ||
CATEGORY_ID | NUMBER | (4) | ||
STRUCTURE_BITMASK | RAW | (32) | Yes | |
STRUCTURE_VALUE | RAW | (32) | Yes | |
MAX_CODE_BYTELEN | NUMBER | (4) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TYPE_ID
, TYPE_NAME
, PARTITION_VALUE
, CATEGORY_ID
, STRUCTURE_BITMASK
, STRUCTURE_VALUE
, MAX_CODE_BYTELEN
FROM MGDSYS.MGD_IDENCODING_TYPE_TAB;
MGDSYS.MGD_IDENCODING_TYPE_TAB does not reference any database object
MGDSYS.MGD_IDENCODING_TYPE_TAB is referenced by following:
|
|
|