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

PORTAL_TABLES_AUDIT

Columns

NameTypeNullableDefault valueComment
AUDIT_IDNUMBER(38)N  
TABLE_IDNUMBER(38)Y  
TABLE_NAMEVARCHAR2(4000.0)Y  
ADPCLOBN  
ADMIN_URLVARCHAR2(1000.0)Y  
MODIFIED_DATEDATEY  
CREATION_USERNUMBER(38)Y  
AUDIT_TIMEDATEY  

Primary key:

Constraint NameColumns
SYS_C002088043AUDIT_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088042"ADP" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088044CREATION_USER USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088043NORMALUNIQUEAUDIT_ID
SYS_IL0001976854C00004$$LOBUNIQUE 

Generated by OraSchemaDoc, (c) Aram Kananov, 2002