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

AD_PARTNER_URL

Columns

NameTypeNullableDefault valueComment
URL_IDNUMBER(38)N  
PARTNER_IDNUMBER(38)N  
URL_STUBVARCHAR2(50.0)N  

Primary key:

Constraint NameColumns
SYS_C002088094URL_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088092"PARTNER_ID" IS NOT NULL
SYS_C002088093"URL_STUB" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088096PARTNER_ID AD_PARTNER SYS_C002088090 NO ACTION

Unique Keys:

Constraint nameColumns
SYS_C002088095PARTNER_ID , URL_STUB

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
AD_PARTNER_URL_URL_STUBNORMALNONUNIQUEURL_STUB
SYS_C002088094NORMALUNIQUEURL_ID
SYS_C002088095NORMALUNIQUEPARTNER_ID , URL_STUB

Referenced by:

TableConstraint
AD_PARTNER_PROCS SYS_C002088104

Generated by OraSchemaDoc, (c) Aram Kananov, 2002