Copyright © Cloud Software Group, Inc. All Rights Reserved

proc_event

The proc_event table stores definitions of procedure events.

Structure

The proc_event table has the following structure:

TABLE proc_event(
node_id number(5) NOT NULL,
proc_id number(5) NOT NULL,
major_vers number(5) NOT NULL,
minor_vers number(5) NOT NULL,
pd_version number(7) NOT NULL,
eventname varchar(32) NOT NULL,
user_event_name varchar(32) NOT NULL)

Column	Description
node_id	ID of the node that this case is hosted on, as defined in the nodes table.
proc_id	ID of the procedure that this event belongs to, as defined in the proc_index table.
major_vers	Major version number of the procedure version that this case belongs to, as defined in the proc_version table.
minor_vers	Minor version number of the procedure version that this case belongs to, as defined in the proc_version table.
pd_version	Instance number of the procedure definition, as defined in the proc_instance table.
eventname	The name of the procedure event. The value of this column is one of the following: • BeforePurge • BeforeClose • AfterClose • BeforeResurrect • AfterResurrect • BeforeSuspend • AfterSuspend • BeforeResume • AfterResume
user_event_name	The name of the event step which you set for the procedure event.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)	Index Tablespace
pk_proc_event	node_id proc_id pd_version eventname	BIGINDEXSPACE

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_proc_event1	node_id proc_id pd_version	proc_instance

---

1

This key enforces the DELETE CASCADE referential action.

Index

The following index is defined for this table.

Index Name	Column(s) Indexed	Tablespace
idx_proc_event_fk	node_id proc_id pd_version	BIGINDEXSPACE

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	BIGTABLESIZE
Percentage Increase	BIGTABLEPCTINCREASE
Tablespace	BIGINDEXSPACE

Table Activity

The proc_event table contains one or more rows for each instance of each procedure definition on the system. Rows are added, updated, and deleted in the following situations.

A row is...	When...
added	If one of the following conditions occurred: • A new procedure event is added. • A procedure event is modified. Note: When updating a procedure event, the record related to this event is deleted and then a new record with the event changes is added in the table. • A new version of a procedure is released.
updated	Never.
deleted	If one of the following conditions occurred: • A procedure event is deleted. • A procedure event is modified. Note: When updating a procedure event, the record related to this event is deleted and then a new record with the event changes is added in the table. • The version of this procedure is deleted.

 

Copyright © Cloud Software Group, Inc. All Rights Reserved