PZ_Data Columns

ColumnName	Domain	Datatype	NULL	Definition
key		NUMBER(8, 0)	NO	This attribute denotes a unique identifier for a response (poles & zeros)
row_key		NUMBER(8, 0)	NO	Row key for responses
type		VARCHAR2(1)	YES	This attribute denotes whether a value is associated with a pole/zero
r_value		BINARY_FLOAT	NO	The real portion of a complex pole/zero
r_error		BINARY_FLOAT	YES	The error value for the real portion of a complex pole/zero
i_value		BINARY_FLOAT	NO	The imaginary portion of a complex pole/zero
i_error		BINARY_FLOAT	YES	The error value for the imaginary portion of a complex pole/zero

PZ_Data Primary and Unique Keys

Key Name	Key Type	Keys
PZD00	PrimaryKey	key, row_key

PZ_Data Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
PZ	Identifying	One To Zero or More	PZ_Dat_PZ			key	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

PZ_Data Check Constraints

Check Constraint Name	CheckConstraint
PZD01	row_key >= 0
PZD02	type IN ('P','Z','N','D')