Substance_ID 
Base Entity  Substance 
Attribute Name  Substance_ID 
Logical Rolename   
ColumnName  Substance_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Substance_ID Logical Attribute Properties 
Logical Attribute Name  Substance_ID 
Datatype  BIGINT 
Nullable  NO 

Substance_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Substance_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Substance
Substance_ID 
NO     
BARD - MySQL (MySQL)
Substance
Substance_ID 
NO     
BARD_Dev (Oracle)
SUBSTANCE
SUBSTANCE_ID 
NO     


SMILES 
Base Entity  Substance 
Attribute Name  SMILES 
Logical Rolename   
ColumnName  SMILES 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

SMILES Logical Attribute Properties 
Logical Attribute Name  SMILES 
Datatype  VARCHAR(4000) 
Nullable  YES 

SMILES Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
SMILES Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Substance
SMILES 
NO     
BARD - MySQL (MySQL)
Substance
SMILES 
NO     
BARD_Dev (Oracle)
SUBSTANCE
SMILES 
NO     


Version 
Base Entity  Substance 
Attribute Name  Version 
Logical Rolename   
ColumnName  Version 
RoleName   
Domain  Version 
Logical Only  NO 
Definition 
 
Note 
 

Version Logical Attribute Properties 
Logical Attribute Name  Version 
Datatype  INTEGER 
Nullable  NO 

Version Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default 
Bound Default   

Version Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Substance
Version 
NO     
BARD - MySQL (MySQL)
Substance
Version 
NO     
BARD_Dev (Oracle)
SUBSTANCE
VERSION 
NO     


Date_Created 
Base Entity  Substance 
Attribute Name  Date_Created 
Logical Rolename   
ColumnName  Date_Created 
RoleName   
Domain  Date_Created 
Logical Only  NO 
Definition 
 
Note 
 

Date_Created Logical Attribute Properties 
Logical Attribute Name  Date_Created 
Datatype  TIMESTAMP/DATE 
Nullable  NO 

Date_Created Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Date_Created Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Substance
Date_Created 
NO     
BARD - MySQL (MySQL)
Substance
Date_Created 
NO     
BARD_Dev (Oracle)
SUBSTANCE
DATE_CREATED 
NO     


Last_Updated 
Base Entity  Substance 
Attribute Name  Last_Updated 
Logical Rolename   
ColumnName  Last_Updated 
RoleName   
Domain  Last_Updated 
Logical Only  NO 
Definition 
 
Note 
 

Last_Updated Logical Attribute Properties 
Logical Attribute Name  Last_Updated 
Datatype  DATETIME 
Nullable  YES 

Last_Updated Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Last_Updated Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Substance
Last_Updated 
NO     
BARD - MySQL (MySQL)
Substance
Last_Updated 
NO     
BARD_Dev (Oracle)
SUBSTANCE
LAST_UPDATED 
NO     


Modified_by 
Base Entity  Substance 
Attribute Name  Modified_by 
Logical Rolename   
ColumnName  Modified_by 
RoleName   
Domain  Modified_by 
Logical Only  NO 
Definition 
 
Note 
 

Modified_by Logical Attribute Properties 
Logical Attribute Name  Modified_by 
Datatype  VARCHAR(40) 
Nullable  YES 

Modified_by Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modified_by Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Substance
Modified_by 
NO     
BARD - MySQL (MySQL)
Substance
Modified_by 
NO     
BARD_Dev (Oracle)
SUBSTANCE
MODIFIED_BY 
NO