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_WEEKS

Description:

schwk individual week records for schedules

DDL script

Columns

NameTypeNullableDefault valueComment
RECIDNUMBER(12)N  
SCHEDULE_IDNUMBER(12)N  
COMPONENT_SCHEDULE_IDNUMBER(12)Y  
ORDNUMBER(3)Y  
LAST_UPDATE_USERVARCHAR2(40)Y  
LAST_UPDATE_DATEDATEY  

Primary key:

Constraint NameColumns
RHN_SCHWK_RECID_PKRECID

Check Constraints:

Constraint NameCheck Condition
RHN_SCHWK_RECID_CKrecid > 0

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_SCHWK_SCHED_COMP_SCHED_FKCOMPONENT_SCHEDULE_ID RHN_SCHEDULES RHN_SCHED_RECID_PK NO ACTION
RHN_SCHWK_SCHED_SCHED_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_SCHWK_COMP_SCHED_ID_IDXNORMALNONUNIQUECOMPONENT_SCHEDULE_ID DDL script
RHN_SCHWK_RECID_PKNORMALUNIQUERECID DDL script
RHN_SCHWK_SCHEDULE_ID_IDXNORMALNONUNIQUESCHEDULE_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:24 2008