applications Columns

ColumnName	Domain	Datatype	NULL	Definition
progid		NUMBER(8, 0)	NO	Primary Key
name		VARCHAR2(16)	NO	Program name used in sql_chanloader system. Example: AmpGen
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

applications Primary and Unique Keys

Key Name	Key Type	Keys
progkey01_1	PrimaryKey	progid

applications 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
appchannels	Identifying	One To Zero or More					NO	NO	YES

applications Check Constraints

Check Constraint Name	CheckConstraint
prog02_1	progid > 0