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

SURVSIMP_QUESTION_CHOICES

Columns

NameTypeNullableDefault valueComment
CHOICE_IDNUMBER(38)N  
QUESTION_IDNUMBER(38)N  
LABELVARCHAR2(500.0)N  
NUMERIC_VALUENUMBER(38)Y  
SORT_ORDERNUMBER(38)Y  

Primary key:

Constraint NameColumns
SYS_C002088578CHOICE_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088575"CHOICE_ID" IS NOT NULL
SYS_C002088576"QUESTION_ID" IS NOT NULL
SYS_C002088577"LABEL" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088579QUESTION_ID SURVSIMP_QUESTIONS SYS_C002088572 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088578NORMALUNIQUECHOICE_ID

Referenced by:

TableConstraint
SURVSIMP_QUESTION_RESPONSES SYS_C002088594

Generated by OraSchemaDoc, (c) Aram Kananov, 2002