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

IM_URL_TYPES

Columns

NameTypeNullableDefault valueComment
URL_TYPE_IDNUMBER(38)N  
URL_TYPEVARCHAR2(200.0)N  
TO_ASKVARCHAR2(1000.0)N  
TO_DISPLAYVARCHAR2(100.0)N  
DISPLAY_ORDERNUMBER(38)Y1  

Primary key:

Constraint NameColumns
SYS_C002088356URL_TYPE_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088352"URL_TYPE_ID" IS NOT NULL
SYS_C002088353"URL_TYPE" IS NOT NULL
SYS_C002088354"TO_ASK" IS NOT NULL
SYS_C002088355"TO_DISPLAY" IS NOT NULL

Unique Keys:

Constraint nameColumns
SYS_C002088357URL_TYPE

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088356NORMALUNIQUEURL_TYPE_ID
SYS_C002088357NORMALUNIQUEURL_TYPE

Referenced by:

TableConstraint
IM_PROJECT_URL_MAP SYS_C002088376


Generated by OraSchemaDoc, (c) Aram Kananov, 2002