DC Columns

ColumnName	Domain	Datatype	NULL	Definition
key		NUMBER(8, 0)	NO	This attribute denotes a unique identifier for a response (digital coefficients)
name		VARCHAR2(80)	YES	Descriptive name
symmetry		VARCHAR2(1)	YES	This attribute denotes the eventual symmetry of a response
storage		VARCHAR2(1)	YES	This attribute denotes if half or all the coefficients are stored in the DC_Data table
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

DC Primary and Unique Keys

Key Name	Key Type	Keys
DC00	PrimaryKey	key

DC 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
Coefficients	Non-Identifying	One To Zero or More	Coe_DC				NO	NO
DC_Data	Identifying	One To Zero or More	DC_Dat_DC				NO	NO

DC Check Constraints

Check Constraint Name	CheckConstraint
DC01	dcstorage IN ('H','F')
DC02	symmetry IN ('E','O','N')