PN 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
poly_type		VARCHAR2(1)	YES	This attribute represents the type of polynomial approximation
lower_bound		BINARY_FLOAT	YES	This attribute denotes the polynomial lower bound
upper_bound		BINARY_FLOAT	YES	This attribute denotes the polynomial upper bound
max_error		BINARY_FLOAT	YES	This attribute represents the maximum error of polynomial approximation
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

PN Primary and Unique Keys

Key Name	Key Type	Keys
PN00	PrimaryKey	key

PN 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
PN_Data	Identifying	One To Zero or More	PN_Data_PN				NO	NO	NO
Polynomial	Non-Identifying	One To Zero or More	Pol_PN				NO	NO	NO

PN Check Constraints

Check Constraint Name	CheckConstraint
PN01	poly_type IN ('C','L','M')