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_PROCEDURE_EVENTS

Columns

NameTypeNullableDefault valueComment
EVENT_IDNUMBER(38)N  
PROCEDURE_IDNUMBER(38)N  
USER_IDNUMBER(38)N  
SUPERVISING_USERNUMBER(38)N  
EVENT_DATEDATEN  
NOTEVARCHAR2(1000.0)Y  

Primary key:

Constraint NameColumns
SYS_C002088499EVENT_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088494"EVENT_ID" IS NOT NULL
SYS_C002088495"PROCEDURE_ID" IS NOT NULL
SYS_C002088496"USER_ID" IS NOT NULL
SYS_C002088497"SUPERVISING_USER" IS NOT NULL
SYS_C002088498"EVENT_DATE" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088500PROCEDURE_ID IM_PROCEDURES SYS_C002088483 NO ACTION
SYS_C002088501USER_ID USERS SYS_C002087135 NO ACTION
SYS_C002088502SUPERVISING_USER USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088499NORMALUNIQUEEVENT_ID

Generated by OraSchemaDoc, (c) Aram Kananov, 2002