PZ Columns

ColumnName	Domain	Datatype	NULL	Definition
key		NUMBER(8, 0)	NO	This attribute denotes a unique identifier for a response (poles & zeros)
name		VARCHAR2(80)	YES	Descriptive name
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

PZ Primary and Unique Keys

Key Name	Key Type	Keys
PZ00	PrimaryKey	key

PZ Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable
Poles_Zeros	Non-Identifying	One To Zero or More	Pol_Zer_PZ				NO	NO
PZ_Data	Identifying	One To Zero or More	PZ_Dat_PZ				NO	NO

PZ Check Constraints

Check Constraint Name

CheckConstraint