Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

RHNFILEDOWNLOAD

DDL script

Columns

NameTypeNullableDefault valueComment
FILE_IDNUMBER(38)N  
LOCATIONVARCHAR2(2000)N  
TOKENVARCHAR2(48)Y  
REQUESTOR_IPVARCHAR2(15)N  
START_TIMEDATEN(sysdate)  
USER_IDNUMBER(38)Y  

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_FILEDL_FID_FKFILE_ID RHNFILE RHN_FILE_ID_PK NO ACTION
RHN_FILEDL_UID_FKUSER_ID WEB_CONTACT WEB_CONTACT_PK SET NULL

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_FILEDL_START_IDXNORMALNONUNIQUESTART_TIME DDL script
RHN_FILEDL_TOKEN_IDXNORMALNONUNIQUETOKEN DDL script
RHN_FILEDL_UID_FID_IDXNORMALNONUNIQUEUSER_ID , FILE_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:19 2008