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

RHN_SCHEDULE_DAYS

Description:

schdy individual day records for schedules

DDL script

Columns

NameTypeNullableDefault valueComment
RECIDNUMBER(12)N  
SCHEDULE_IDNUMBER(12)Y  
ORDNUMBER(3)Y  
START_1DATEY  
END_1DATEY  
START_2DATEY  
END_2DATEY  
START_3DATEY  
END_3DATEY  
START_4DATEY  
END_4DATEY  
LAST_UPDATE_USERVARCHAR2(40)Y  
LAST_UPDATE_DATEVARCHAR2(40)Y  

Primary key:

Constraint NameColumns
RHN_SCHDY_RECID_PKRECID

Check Constraints:

Constraint NameCheck Condition
RHN_SCHDY_RECID_CKrecid > 0

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_SCHDY_SCHED_SCHEDULE_ID_FKSCHEDULE_ID RHN_SCHEDULES RHN_SCHED_RECID_PK CASCADE

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_SCHDY_RECID_PKNORMALUNIQUERECID DDL script
RHN_SCHDY_SCHEDULE_ID_IDXNORMALNONUNIQUESCHEDULE_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:24 2008