[jira] [Commented] (AIRAVATA-994) Craft Airavata Execution Management API

[Chathuri Wimalasena (JIRA)]

    [ 
https://issues.apache.org/jira/browse/AIRAVATA-994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13885491#comment-13885491
 ] 

Chathuri Wimalasena commented on AIRAVATA-994:
----------------------------------------------

Thanks for the feedback Raman. How about adding these two table to keep 
workflow inputs and outputs ?

CREATE TABLE WORKFLOW_INPUTS
(
    EXPERIMENT_ID VARCHAR(255) NOT NULL,
    KEY VARCHAR (255) NOT NULL,
    VALUE VARCHAR (255),
    PRIMARY KEY (EXPERIMENT_ID, KEY),
    FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT_METADATA(EXPERIMENT_ID) 
ON DELETE CASCADE
)

CREATE TABLE WORKFLOW_OUTPUTS
(
    EXPERIMENT_ID VARCHAR(255) NOT NULL,
    KEY VARCHAR (255) NOT NULL,
    VALUE VARCHAR (255),
    PRIMARY KEY (EXPERIMENT_ID, KEY),
    FOREIGN KEY (EXPERIMENT_ID) REFERENCES EXPERIMENT_METADATA(EXPERIMENT_ID) 
ON DELETE CASCADE
)


> Craft Airavata Execution Management API 
> ----------------------------------------
>
>                 Key: AIRAVATA-994
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-994
>             Project: Airavata
>          Issue Type: Sub-task
>          Components: Airavata API
>            Reporter: Suresh Marru
>             Fix For: 1.0
>
>




--
This message was sent by Atlassian JIRA
(v6.1.5#6160)