Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

CURRICULUM

Columns

NameTypeNullableDefault valueComment
CURRICULUM_ELEMENT_IDNUMBER(38)N  
ELEMENT_INDEXNUMBER(38)Y  
URLVARCHAR2(200.0)N  
VERY_VERY_SHORT_NAMEVARCHAR2(30.0)N  
ONE_LINE_DESCRIPTIONVARCHAR2(200.0)N  
FULL_DESCRIPTIONVARCHAR2(4000.0)Y  

Primary key:

Constraint NameColumns
SYS_C002088066CURRICULUM_ELEMENT_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088063"URL" IS NOT NULL
SYS_C002088064"VERY_VERY_SHORT_NAME" IS NOT NULL
SYS_C002088065"ONE_LINE_DESCRIPTION" IS NOT NULL

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088066NORMALUNIQUECURRICULUM_ELEMENT_ID

Referenced by:

TableConstraint
USER_CURRICULUM_MAP SYS_C002088072

Generated by OraSchemaDoc, (c) Aram Kananov, 2002