DC_Data

DC_Data

Logical Entity Name	DC_Data
Default Table Name	DC_Data
Definition	Coefficients of a response

DC_Data Columns

ColumnName Domain Datatype NULL Definition

key (PK)(FK) NUMBER(8, 0) NO This attribute denotes a unique identifier for a response (digital coefficients)

row_key (PK) NUMBER(8, 0) NO Row key for responses

type VARCHAR2(1) YES This attribute denotes whether a value is associated with a numerator/denominator

coefficient DOUBLE PRECISION NO The numerator/denominator coefficient value

error DOUBLE PRECISION YES This attribute denotes the numerator/denominator error

DC_Data Primary and Unique Keys

Key Name Key Type Keys

DCD00 PrimaryKey key, row_key

DC_Data Foreign Keys

Parent Relationships:

Table Name Type Cardinality Constraint Name VerbPhrase InversePhrase Foreign Keys Is Supertype Deferrable

DC Identifying One To Zero or More DC_Dat_DC key NO NO

Child Relationships:

Table Name Type Cardinality Constraint Name VerbPhrase InversePhrase Foreign Keys Is Subtype Deferrable

DC_Data Check Constraints

Check Constraint Name CheckConstraint

DCD01 row_key >= 0

DCD02 type IN ('P','Z','N','D')

ColumnName	Domain	Datatype	NULL	Definition
key		NUMBER(8, 0)	NO	This attribute denotes a unique identifier for a response (digital coefficients)
row_key		NUMBER(8, 0)	NO	Row key for responses
type		VARCHAR2(1)	YES	This attribute denotes whether a value is associated with a numerator/denominator
coefficient		DOUBLE PRECISION	NO	The numerator/denominator coefficient value
error		DOUBLE PRECISION	YES	This attribute denotes the numerator/denominator error

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable
DC	Identifying	One To Zero or More	DC_Dat_DC			key	NO	NO

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