Project 
EntityType  Independent 
Logical Entity Name  Project 
Default Table Name  Project 
Logical Only  NO 
Owner   
Definition 
 
Note 
 

Project Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Project_ID(PK)  Identifier  BIGINT  NO 
 
Project_Name    VARCHAR(256)  NO 
 
Group_Type    VARCHAR(20)  NO 
 
Description  Description  VARCHAR(1000)  YES 
 
Project_Status    VARCHAR(10)  YES 
 
ready_for_extraction  dirty flag  VARCHAR(20)  NO 
 
Version  Version  INTEGER  NO 
 
Date_Created  Date_Created  TIMESTAMP/DATE  NO 
 
Last_Updated  Last_Updated  DATETIME  NO 
 
Modified_by  Modified_by  VARCHAR(40)  YES 
 
NCGC_WAREHOUSE_ID    NUMERIC(19, 0)  YES 
 
OWNER_ROLE_ID(FK)    NUMERIC(19, 0)  YES 
 

Project Keys 
Key Name  Key Type  Keys 
PK_Project  PrimaryKey  Project_ID 
FK_PROJECT_OWNER_ROLE_ID  Inversion Entry  OWNER_ROLE_ID 

Project Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Role  Non-Identifying  Zero or One to Zero or More        OWNER_ROLE_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
External_Reference  Non-Identifying  One To Zero or More          NO 
Project_Context  Non-Identifying  One To Zero or More          NO 
Project_Experiment  Non-Identifying  One To Zero or More          NO 
PROJECT_DOCUMENT  Non-Identifying  One To Zero or More          NO 

Project Check Constraints 
Check Constraint Name  CheckConstraint 
CK_PROJECT_OWNER_ROLE_ID  OWNER_ROLE_ID IS NOT NULL 

Project Security Types 
Name  Current Value 

Project Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
Project 
NO       
BARD - MySQL (MySQL)
Project 
NO       
BARD_Dev (Oracle)
PROJECT 
NO       
Current Production (Oracle)
Does Not Exist 
NO       

Project Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Panels 
Logical  Project Information 
Logical  RI hierarchy 
Logical  Security 
BARD - MySQL (MySQL)  Main Model 
BARD - MySQL (MySQL)  CAP 
BARD - MySQL (MySQL)  Data Entry 
BARD - MySQL (MySQL)  Project Management 
BARD_Dev (Oracle)  Main Model 
BARD_Dev (Oracle)  Panels 
BARD_Dev (Oracle)  Project Information 
BARD_Dev (Oracle)  RI hierarchy 
BARD_Dev (Oracle)  Security