PCASSAY_COLUMN Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
COLUMN_ID		NUMERIC(10, 0)	NO
COLUMN_TID		NUMERIC(10, 0)	NO
COLUMN_ACTIVE_CONC		NUMERIC(1, 0)	YES
COLUMN_CURVE_PLOT_LABEL		NUMERIC(10, 0)	YES
COLUMN_DESCRIPTION		VARCHAR(1250)	YES
COLUMN_NAME		VARCHAR(255)	NO
COLUMN_PANEL_READOUT_TYPE		VARCHAR(255)	YES
COLUMN_TESTED_CONC		REAL/SMALLFLOAT	YES
COLUMN_TESTED_CONC_UNIT		VARCHAR(255)	YES
COLUMN_TYPE		VARCHAR(255)	YES
COLUMN_UNIT		VARCHAR(255)	YES
ASSAY_ASSAY_ID		NUMERIC(10, 0)	NO
PANEL_PANEL_ID		NUMERIC(10, 0)	YES

PCASSAY_COLUMN Keys

Key Name	Key Type	Keys
PK_PCASSAY_COLUMN	PrimaryKey	COLUMN_ID

PCASSAY_COLUMN Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
PCASSAY	Non-Identifying	One To Zero or More				ASSAY_ASSAY_ID	NO
PCASSAY_PANEL	Non-Identifying	Zero or One to Zero or More				PANEL_PANEL_ID	NO

Child Relationships:

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

PCASSAY_COLUMN Check Constraints

Check Constraint Name

CheckConstraint

PCASSAY_COLUMN Security Types

Name	Current Value

PCASSAY_COLUMN Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical PCASSAY_COLUMN	NO
BARD - MySQL (MySQL) Does Not Exist	NO
BARD_Dev (Oracle) PCASSAY_COLUMN	NO
Current Production (Oracle) Does Not Exist	NO

PCASSAY_COLUMN Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Migration
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	Migration