[Home] [Help] [Dependency Information]
Object Name: | CSW_RECORD_TYPES$ |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00236188 | NORMAL | UNIQUE | SYSTEM | RECORDTYPEID |
SYS_IL0000489364C00005$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00007$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00008$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00009$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00012$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00014$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00016$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00017$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00021$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00022$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00023$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00027$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00028$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000489364C00029$$ | LOB | UNIQUE | SYSTEM | |
UNIQUE_CSW_RT_COND | NORMAL | UNIQUE | SYSTEM |
TYPENAMENS
TYPENAME |
Table | |
Foreign Table | Foreign Key Column | CSW_DOMAININFO$ | CSW_RECORD_TYPES$ | CSW_DOMAININFO$ RECORDTYPEID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORDTYPEID | NUMBER | Yes | ||
TYPENAME | VARCHAR2 | (80) | ||
TYPENAMENS | VARCHAR2 | (2083) | ||
DESCRIBERECORD | XMLTYPE | (2000) | ||
DATAPOINTER | VARCHAR2 | (61) | ||
IDPATHS | STRINGLIST | (3752) | ||
SPATIALPATHS | STRINGLIST | (3752) | ||
TSPATHS | STRINGLIST | (3752) | ||
LASTUPDATETS | TIMESTAMP(6) | (11) | ||
BRIEFXSLPATTERN | XMLTYPE | (2000) | ||
SUMMARYXSLPATTERN | XMLTYPE | (2000) | ||
DCMIXSLPATTERN | XMLTYPE | (2000) | ||
SRSPATHS | STRINGLIST | (3752) | ||
SRSNS | VARCHAR2 | (2083) | ||
SRSNSALIAS | VARCHAR2 | (80) | ||
RTXSDREFID | VARCHAR2 | (80) | ||
NUMCOLS | STRINGLIST | (3752) | ||
IDXPATHS | STRINGLIST | (3752) | ||
IDXPATHTYPES | STRINGLIST | (3752) | ||
XTIDXCREATED | VARCHAR2 | (1) | ||
IDEXTRACTORTYPE | VARCHAR2 | (20) | ||
ISGML3 | VARCHAR2 | (1) | ||
SPATIALARRLIST | STRINGLISTLIST | (3752) | ||
SPATIALPATHSSRSNSLIST | STRINGLISTLIST | (3752) | ||
SPATIALARRPATHSSRSNSLIST | STRINGLISTLIST | (3752) |
Cut, paste (and edit) the following text to query this object:
SELECT RECORDTYPEID
, TYPENAME
, TYPENAMENS
, DESCRIBERECORD
, DATAPOINTER
, IDPATHS
, SPATIALPATHS
, TSPATHS
, LASTUPDATETS
, BRIEFXSLPATTERN
, SUMMARYXSLPATTERN
, DCMIXSLPATTERN
, SRSPATHS
, SRSNS
, SRSNSALIAS
, RTXSDREFID
, NUMCOLS
, IDXPATHS
, IDXPATHTYPES
, XTIDXCREATED
, IDEXTRACTORTYPE
, ISGML3
, SPATIALARRLIST
, SPATIALPATHSSRSNSLIST
, SPATIALARRPATHSSRSNSLIST
FROM MDSYS.CSW_RECORD_TYPES$;
|
|
|