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

CRM_STATES

Columns

NameTypeNullableDefault valueComment
STATE_NAMEVARCHAR2(50.0)N  
DESCRIPTIONVARCHAR2(1000.0)N  
INITIAL_STATE_PCHAR(1.0)Y'f'  

Primary key:

Constraint NameColumns
SYS_C002088048STATE_NAME

Check Constraints:

Constraint NameCheck Condition
SYS_C002088045"STATE_NAME" IS NOT NULL
SYS_C002088046"DESCRIPTION" IS NOT NULL
SYS_C002088047initial_state_p in ('t', 'f')

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088048NORMALUNIQUESTATE_NAME

Referenced by:

TableConstraint
CRM_STATE_TRANSITIONS SYS_C002088054
CRM_STATE_TRANSITIONS SYS_C002088055


Generated by OraSchemaDoc, (c) Aram Kananov, 2002