jasieventlock Columns

ColumnName	Domain	Datatype	NULL	Definition
evid		NUMBER	NO	Event identifier. Each event is assigned a unique integer which identifies it in a database
hostname		VARCHAR2(40)	YES	URL of computer that has locked the event
application		VARCHAR2(20)	YES	Name of computer application that has locked the event
username		VARCHAR2(20)	YES	Username on remote computer that has locked the event
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

jasieventlock Primary and Unique Keys

Key Name	Key Type	Keys
PK3	PrimaryKey	evid

jasieventlock Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Initially Deferred

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

jasieventlock Check Constraints

Check Constraint Name

CheckConstraint