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

BM_URLS

Columns

NameTypeNullableDefault valueComment
URL_IDNUMBER(38)N  
URL_TITLEVARCHAR2(500.0)Y  
HOST_URLVARCHAR2(100.0)N  
COMPLETE_URLVARCHAR2(500.0)N  
META_KEYWORDSVARCHAR2(4000.0)Y  
META_DESCRIPTIONVARCHAR2(4000.0)Y  
LAST_CHECKED_DATEDATEY  
LAST_LIVE_DATEDATEY  

Primary key:

Constraint NameColumns
SYS_C002087859URL_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002087857"HOST_URL" IS NOT NULL
SYS_C002087858"COMPLETE_URL" IS NOT NULL

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002087859NORMALUNIQUEURL_ID

Referenced by:

TableConstraint
BM_LIST SYS_C002087870

Generated by OraSchemaDoc, (c) Aram Kananov, 2002