PCCOMPOUND Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
CD_ID		NUMERIC(19, 0)	NO
CID		NUMERIC(19, 0)	YES
H_BOND_ACCEPTORS		NUMERIC(10, 0)	YES
H_BOND_DONORS		NUMERIC(10, 0)	YES
IUPAC_NAME		VARCHAR(1000)	YES
TPSA		REAL/SMALLFLOAT	YES
XLOGP		REAL/SMALLFLOAT	YES
EXACT_WEIGHT		REAL/SMALLFLOAT	YES
CD_FORMULA		VARCHAR(255)	YES
CD_MOLWEIGHT		REAL/SMALLFLOAT	YES
ROTATABLE_BONDS		NUMERIC(10, 0)	YES
CD_SMILES		VARCHAR(255)	YES
CD_SORTABLE_FORMULA		VARCHAR(255)	YES
CD_STRUCTURE		VARCHAR(255)	YES
TOTAL_CHARGE		NUMERIC(10, 0)	YES
TRADITIONAL_NAME		VARCHAR(1000)	YES

PCCOMPOUND Keys

Key Name	Key Type	Keys
PK_PCCOMPOUND	PrimaryKey	CD_ID
AK_PCCOMPOUND_CID	Alternate Key	CID

PCCOMPOUND 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
PCCOMPOUND_SYNONYMS	Non-Identifying	Zero or One to Zero or More					NO

PCCOMPOUND Check Constraints

Check Constraint Name

CheckConstraint

PCCOMPOUND Security Types

Name	Current Value

PCCOMPOUND Where Used - Model Usage

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

PCCOMPOUND Where Used - Submodel Usage

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