EXPERIMENT_FILE 
Logical Entity Name  EXPERIMENT_FILE 
Default Table Name  EXPERIMENT_FILE 
Physical Only  NO 
Do Not Generate  False 
Owner   
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE EXPERIMENT_FILE(
     EXPERIMENT_FILE_ID     NUMBER(19, 0)      NOT NULL,
     EXPERIMENT_ID          NUMBER(19, 0)      NOT NULL,
     SUBMISSION_VERSION     NUMBER(19, 0)      NOT NULL,
     ORIGINAL_FILE          VARCHAR2(1000 CHAR) NOT NULL,
     EXPORT_FILE            VARCHAR2(1000 CHAR),
     VERSION                NUMBER(38, 0)      DEFAULT 0 NOT NULL,
     DATE_CREATED           TIMESTAMP(6)       DEFAULT sysdate NOT NULL,
     LAST_UPDATED           TIMESTAMP(6),
     MODIFIED_BY            VARCHAR2(40),
     SUBSTANCE_COUNT        NUMBER(19, 0),
     CONSTRAINT PK_EXPERIMENT_FILE PRIMARY KEY (EXPERIMENT_FILE_ID),
     CONSTRAINT FK_EXPERIMENT_FILE FOREIGN KEY (EXPERIMENT_ID)
     REFERENCES EXPERIMENT(EXPERIMENT_ID)
)
;



CREATE INDEX FK_EXPERIMENT_FILE ON EXPERIMENT_FILE(EXPERIMENT_ID)
;
 
PostSQL   

EXPERIMENT_FILE Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXPERIMENT_FILE_ID(PK)    NUMBER(19, 0)  NO 
 
EXPERIMENT_ID(FK)  Identifier  NUMBER(19, 0)  NO 
 
SUBMISSION_VERSION    NUMBER(19, 0)  NO 
 
ORIGINAL_FILE    VARCHAR2(1000)  NO 
 
EXPORT_FILE    VARCHAR2(1000)  YES 
 
VERSION    NUMBER(38, 0)  NO 
 
DATE_CREATED    TIMESTAMP(6)  NO 
 
LAST_UPDATED    TIMESTAMP(6)  YES 
 
MODIFIED_BY    VARCHAR2(40)  YES 
 
SUBSTANCE_COUNT    NUMBER(19, 0)  YES 
 

EXPERIMENT_FILE Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_EXPERIMENT_FILE  PrimaryKey  EXPERIMENT_FILE_ID 

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

EXPERIMENT_FILE Check Constraints 
Check Constraint Name  CheckConstraint 

EXPERIMENT_FILE Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  DATA_MIG 
PctFree  10 
PCTUSED   0 
MinExtents  0 
MaxExtents  0 
Initial  0 
Next  0 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging  Logged 
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS   
FREELIST GROUPS   
Buffer Pool  DEFAULT 
Table Compression  NO 
Row Movement  Disabled 

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

EXPERIMENT_FILE Security Types 
Name  Current Value 

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

EXPERIMENT_FILE Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Experiment Specification 
Logical  Results 
Logical  RI hierarchy 
BARD_Dev (Oracle)  Main Model 
BARD_Dev (Oracle)  Experiment Specification 
BARD_Dev (Oracle)  Results 
BARD_Dev (Oracle)  RI hierarchy 
Current Production (Oracle)  Main Model 
Current Production (Oracle)  Results Deposition