Registry Data Structure Guide

Following is the registry data structure from Airavata 0.5 upwards.

Gateway *
  |- Descriptors *
  |- Published Workflows * 
  |- Users *
  |       |- Workspace
  |       |      |- Workflows
  |       |      |- Projects *
  |       |             |- Experiments *
  |       |                    
  |       |
  |
  |
  |
  |- Name
  |- Owner
  |
  |

* - Denotes many

According to the above structure, below table structure is designed for database. 

Gateway
    gateway_name
    owner

Configuration
    config_key
    config_val
    expire_date

Users
    user_name
    password

Gateway_Worker
    gateway_name
    user_name

Project
    gateway_name
    user_name
    project_name

Published_Workflow
    gateway_name
    created_user
    publish_workflow_name
    version
    published_date
    path
    workflow_content

User_Workflow
    gateway_name
    owner
    template_name
    last_updated_date
    path
    workflow_graph

Host_Descriptor
    gateway_name
    updated_user
    host_descriptor_ID
    host_descriptor_xml

Service_Descriptor
    gateway_name
    updated_user
    service_descriptor_ID
    service_descriptor_xml

Application_Descriptor
    gateway_name
    updated_user
    application_descriptor_ID
    host_descriptor_ID
    service_descriptor_ID
    application_descriptor_xml

Experiment
    project_name
    gateway_name
    user_name
    experiment_ID
    submitted_date

Experiment_Metadata
    experiment_ID
    metadata

Experiment_Data
    experiment_ID
    name
    user_name

Workflow_Data
    experiment_ID
    workflow_instanceID
    template_name
    status
    start_time
    last_update_time

Node_Data
    workflow_instanceID
    node_id
    node_type
    inputs
    outputs
    status
    start_time
    last_update_time

Gram_Data
    workflow_instanceID
    node_id
    rsl
    invoked_host
    local_Job_ID