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

MANUAL_SECTIONS

Columns

NameTypeNullableDefault valueComment
SECTION_IDNUMBER(38)N  
MANUAL_IDNUMBER(38)N  
LABELVARCHAR2(100.0)Y  
SORT_KEYVARCHAR2(50.0)N  
SECTION_TITLEVARCHAR2(500.0)N  
CREATOR_IDNUMBER(38)N  
NOTIFY_PCHAR(1.0)Y'f'  
LAST_MODIFIED_BYNUMBER(38)Y  
CONTENT_PCHAR(1.0)Y'f'  
ACTIVE_PCHAR(1.0)Y't'  
DISPLAY_IN_TOC_PCHAR(1.0)Y't'  

Primary key:

Constraint NameColumns
SYS_C002088632SECTION_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088624"MANUAL_ID" IS NOT NULL
SYS_C002088625"SORT_KEY" IS NOT NULL
SYS_C002088626"SECTION_TITLE" IS NOT NULL
SYS_C002088627"CREATOR_ID" IS NOT NULL
SYS_C002088628notify_p in ('t','f')
SYS_C002088629content_p in ('t','f')
SYS_C002088630active_p in ('t','f')
SYS_C002088631display_in_toc_p in ('t','f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088634MANUAL_ID MANUALS SYS_C002088619 NO ACTION
SYS_C002088635CREATOR_ID USERS SYS_C002087135 NO ACTION
SYS_C002088636LAST_MODIFIED_BY USERS SYS_C002087135 NO ACTION

Unique Keys:

Constraint nameColumns
SYS_C002088633MANUAL_ID , SORT_KEY

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088632NORMALUNIQUESECTION_ID
SYS_C002088633NORMALUNIQUEMANUAL_ID , SORT_KEY

Generated by OraSchemaDoc, (c) Aram Kananov, 2002