DC Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
key		NUMERIC(8, 0)	NO	This attribute denotes a unique identifier for a response (digital coefficients)
name		VARCHAR(80)	YES	Descriptive name
symmetry		VARCHAR(1)	YES	This attribute denotes the eventual symmetry of a response
storage		VARCHAR(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 Keys

Key Name	Key Type	Keys
DC00	PrimaryKey	key

DC Relationships

Parent Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Coefficients	Non-Identifying	One To Zero or More					NO
DC_Data	Identifying	One To Zero or More					NO

DC Check Constraints

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