PRJCT_EXPRMT_CONTEXT 
Logical Entity Name  PRJCT_EXPRMT_CONTEXT 
Default Table Name  PRJCT_EXPRMT_CONTEXT 
Physical Only  NO 
Do Not Generate  False 
Owner  BARD_CAP_PROD 
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE BARD_CAP_PROD.PRJCT_EXPRMT_CONTEXT(
     PRJCT_EXPRMT_CONTEXT_ID     NUMBER(19, 0)     NOT NULL,
     CONTEXT_NAME                VARCHAR2(128),
     PROJECT_EXPERIMENT_ID       NUMBER(19, 0)     NOT NULL,
     CONTEXT_GROUP               VARCHAR2(256),
     DISPLAY_ORDER               NUMBER(5, 0)      DEFAULT 0 NOT NULL,
     VERSION                     NUMBER(38, 0)     DEFAULT 0 NOT NULL,
     DATE_CREATED                TIMESTAMP(6)      DEFAULT sysdate NOT NULL,
     LAST_UPDATED                TIMESTAMP(6),
     MODIFIED_BY                 VARCHAR2(40),
     CONTEXT_TYPE                VARCHAR2(25),
     CONSTRAINT CK_PRJCT_EXPRMT_CTX_TYPE CHECK (CONTEXT_TYPE is not null and CONTEXT_TYPE in ('Biology','Assay Protocol','Assay Design','Assay Readout','Assay Components','Experimental Variables','Unclassified')),
     CONSTRAINT PK_PRJCT_EXPRMT_CONTEXT PRIMARY KEY (PRJCT_EXPRMT_CONTEXT_ID)
     USING INDEX
         PCTFREE 10
         INITRANS 2
         MAXTRANS 255
         TABLESPACE BARD_CAP_PROD
         LOGGING
         STORAGE(INITIAL 64K
                 NEXT 1024K
                 MINEXTENTS 1
                 MAXEXTENTS UNLIMITED
                 PCTINCREASE 0
                 BUFFER_POOL DEFAULT
                 )
)
PCTFREE 10
INITRANS 1
MAXTRANS 255
TABLESPACE BARD_CAP_PROD
LOGGING
STORAGE(INITIAL 64K
         NEXT 1024K
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         BUFFER_POOL DEFAULT
         )
;
 
PostSQL   

PRJCT_EXPRMT_CONTEXT Columns 
ColumnName  Domain  Datatype  NULL  Definition 
PRJCT_EXPRMT_CONTEXT_ID(PK)    NUMBER(19, 0)  NO 
 
CONTEXT_NAME    VARCHAR2(128)  YES  
used as a title for the cards in the UI
 
PROJECT_EXPERIMENT_ID    NUMBER(19, 0)  NO 
 
CONTEXT_GROUP    VARCHAR2(256)  YES 
 
DISPLAY_ORDER    NUMBER(5, 0)  NO 
 
VERSION    NUMBER(38, 0)  NO 
 
DATE_CREATED    TIMESTAMP(6)  NO 
 
LAST_UPDATED    TIMESTAMP(6)  YES 
 
MODIFIED_BY    VARCHAR2(40)  YES 
 
CONTEXT_TYPE    VARCHAR2(25)  YES 
 

PRJCT_EXPRMT_CONTEXT Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_PRJCT_EXPRMT_CONTEXT  PrimaryKey  PRJCT_EXPRMT_CONTEXT_ID 

PRJCT_EXPRMT_CONTEXT Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
PRJCT_EXPRMT_CNTXT_ITEM  Non-Identifying  One To Zero or More  FK_PRJ_EXPT_CNTXT_ITM_PRJ_EXPT        NO  NO  NO 

PRJCT_EXPRMT_CONTEXT Check Constraints 
Check Constraint Name  CheckConstraint 

PRJCT_EXPRMT_CONTEXT Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  BARD_CAP_PROD 
PctFree  10 
PCTUSED   0 
MinExtents  1 
MaxExtents  2147483645 
Initial  64 
Next  1024 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging  Logged 
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS  FreeLists 
FREELIST GROUPS  FreeList Groups 
Buffer Pool  DEFAULT 
Table Compression  NO 
Row Movement  Disabled 

PRJCT_EXPRMT_CONTEXT Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  0 
Growth  Static 
Growth Type  N/A 
Growth Period  N/A 
Maximum Rows  0 

PRJCT_EXPRMT_CONTEXT Security Types 
Name  Current Value 

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

PRJCT_EXPRMT_CONTEXT Where Used - Submodel Usage 
Model  Submodel Usage 
BARD_Dev (Oracle)  Main Model 
Current Production (Oracle)  Main Model 
Current Production (Oracle)  Project Information