airavata Layout with Groups

1 airavata Layout with Groups HTML5 interactive image documentation. Move the mouse over tables to read the comments. Powered by DbSchema EXPERIMENT PROCESS EXPERIMENT_STATUS TASK PROJECT EXPERIMENT_ERROR COMMUNITY_USER Fk EXPERIMENT_ibfk_1 EXPERIMENT ref PROJECT ( PROJECT_ID ) PROJECT_ID Fk EXPERIMENT_ERROR_ibfk_1 EXPERIMENT_ERROR ref EXPERIMENT ( EXPERIMENT_ID ) EXPERIMENT_ID Fk EXPERIMENT_INPUT_ibfk_1 EXPERIMENT_INPUT ref EXPERIMENT ( EXPERIMENT_ID ) EXPERIMENT_ID Fk EXPERIMENT_OUTPUT_ibfk_1 EXPERIMENT_OUTPUT ref EXPERIMENT ( EXPERIMENT_ID ) EXPERIMENT_ID Fk EXPERIMENT_STATUS_ibfk_1 EXPERIMENT_STATUS ref EXPERIMENT ( EXPERIMENT_ID ) EXPERIMENT_ID Fk GATEWAY_WORKER_ibfk_1 GATEWAY_WORKER ref GATEWAY ( GATEWAY_ID ) GATEWAY_ID Fk GATEWAY_WORKER_ibfk_2 GATEWAY_WORKER ref USERS ( USER_NAME ) USER_NAME Fk JOB_ibfk_1 JOB ref TASK ( TASK_ID ) TASK_ID Fk JOB_STATUS_ibfk_1 JOB_STATUS ref JOB ( JOB_ID, TASK_ID ) JOB_ID,TASK_ID Fk PROCESS_ibfk_1 PROCESS ref EXPERIMENT ( EXPERIMENT_ID ) EXPERIMENT_ID Fk PROCESS_ERROR_ibfk_1 PROCESS_ERROR ref PROCESS ( PROCESS_ID ) PROCESS_ID Fk PROCESS_INPUT_ibfk_1 PROCESS_INPUT ref PROCESS ( PROCESS_ID ) PROCESS_ID Fk PROCESS_OUTPUT_ibfk_1 PROCESS_OUTPUT ref PROCESS ( PROCESS_ID ) PROCESS_ID Fk PROCESS_RESOURCE_SCHEDULE_ibfk_1 PROCESS_RESOURCE_SCHEDULE ref PROCESS ( PROCESS_ID ) PROCESS_ID Fk PROCESS_STATUS_ibfk_1 PROCESS_STATUS ref PROCESS ( PROCESS_ID ) PROCESS_ID Fk PROJECT_ibfk_1 PROJECT ref GATEWAY ( GATEWAY_ID ) GATEWAY_ID Fk PROJECT_ibfk_2 PROJECT ref USERS ( USER_NAME ) USER_NAME Fk PROJECT_USER_ibfk_1 PROJECT_USER ref PROJECT ( PROJECT_ID ) PROJECT_ID Fk PROJECT_USER_ibfk_2 PROJECT_USER ref USERS ( USER_NAME ) USER_NAME Fk TASK_ibfk_1 TASK ref PROCESS ( PARENT_PROCESS_ID -> PROCESS_ID ) PARENT_PROCESS_ID Fk TASK_ERROR_ibfk_1 TASK_ERROR ref TASK ( TASK_ID ) TASK_ID Fk TASK_STATUS_ibfk_1 TASK_STATUS ref TASK ( TASK_ID ) TASK_ID Fk USER_CONFIGURATION_DATA_ibfk_1 USER_CONFIGURATION_DATA ref EXPERIMENT ( EXPERIMENT_ID ) EXPERIMENT_ID COMMUNITY_USERTable airavata.COMMUNITY_USER Pk pk_community_user ( GATEWAY_ID, COMMUNITY_USER_NAME, TOKEN_ID ) GATEWAY_IDGATEWAY_ID * varchar(256) Pk pk_community_user ( GATEWAY_ID, COMMUNITY_USER_NAME, TOKEN_ID ) COMMUNITY_USER_NAMECOMMUNITY_USER_NAME * varchar(256) Pk pk_community_user ( GATEWAY_ID, COMMUNITY_USER_NAME, TOKEN_ID ) TOKEN_IDTOKEN_ID * varchar(256) COMMUNITY_USER_EMAILCOMMUNITY_USER_EMAIL * varchar(256) CONFIGURATIONTable airavata.CONFIGURATION Pk pk_configuration ( CONFIG_KEY, CONFIG_VAL, CATEGORY_ID ) CONFIG_KEYCONFIG_KEY * varchar(255) default '' Pk pk_configuration ( CONFIG_KEY, CONFIG_VAL, CATEGORY_ID ) CONFIG_VALCONFIG_VAL * varchar(255) default '' Pk pk_configuration ( CONFIG_KEY, CONFIG_VAL, CATEGORY_ID ) CATEGORY_IDCATEGORY_ID * varchar(255) default '' EXPIRE_DATEEXPIRE_DATE * timestamp default CURRENT_TIMESTAMP CREDENTIALSTable airavata.CREDENTIALS Pk pk_credentials ( GATEWAY_ID, TOKEN_ID ) GATEWAY_IDGATEWAY_ID * varchar(256) Pk pk_credentials ( GATEWAY_ID, TOKEN_ID ) TOKEN_IDTOKEN_ID * varchar(256) CREDENTIALCREDENTIAL * blob PORTAL_USER_IDPORTAL_USER_ID * varchar(256) TIME_PERSISTEDTIME_PERSISTED * timestamp default CURRENT_TIMESTAMP EXPERIMENTTable airavata.EXPERIMENT Pk pk_experiment ( EXPERIMENT_ID ) EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' Referred by EXPERIMENT_ERROR ( EXPERIMENT_ID ) Referred by EXPERIMENT_INPUT ( EXPERIMENT_ID ) Referred by EXPERIMENT_OUTPUT ( EXPERIMENT_ID ) Referred by EXPERIMENT_STATUS ( EXPERIMENT_ID ) Referred by PROCESS ( EXPERIMENT_ID ) Referred by USER_CONFIGURATION_DATA ( EXPERIMENT_ID ) PROJECT_ID ( PROJECT_ID ) PROJECT_IDPROJECT_ID varchar(255) References PROJECT ( PROJECT_ID ) GATEWAY_IDGATEWAY_ID varchar(255) EXPERIMENT_TYPEEXPERIMENT_TYPE varchar(255) USER_NAMEUSER_NAME varchar(255) EXPERIMENT_NAMEEXPERIMENT_NAME varchar(255) CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP DESCRIPTIONDESCRIPTION varchar(255) EXECUTION_IDEXECUTION_ID varchar(255) GATEWAY_EXECUTION_IDGATEWAY_EXECUTION_ID varchar(255) ENABLE_EMAIL_NOTIFICATIONENABLE_EMAIL_NOTIFICATION bit EMAIL_ADDRESSESEMAIL_ADDRESSES text GATEWAY_INSTANCE_IDGATEWAY_INSTANCE_ID varchar(255) ARCHIVEARCHIVE bit EXPERIMENT_ERRORTable airavata.EXPERIMENT_ERROR Pk pk_experiment_error ( ERROR_ID, EXPERIMENT_ID ) ERROR_IDERROR_ID * varchar(255) default '' Pk pk_experiment_error ( ERROR_ID, EXPERIMENT_ID ) EXPERIMENT_ID ( EXPERIMENT_ID ) EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' References EXPERIMENT ( EXPERIMENT_ID ) CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP ACTUAL_ERROR_MESSAGEACTUAL_ERROR_MESSAGE text USER_FRIENDLY_MESSAGEUSER_FRIENDLY_MESSAGE text TRANSIENT_OR_PERSISTENTTRANSIENT_OR_PERSISTENT bit ROOT_CAUSE_ERROR_ID_LISTROOT_CAUSE_ERROR_ID_LIST text EXPERIMENT_INPUTTable airavata.EXPERIMENT_INPUT Pk pk_experiment_input ( EXPERIMENT_ID, INPUT_NAME ) EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' References EXPERIMENT ( EXPERIMENT_ID ) Pk pk_experiment_input ( EXPERIMENT_ID, INPUT_NAME ) INPUT_NAMEINPUT_NAME * varchar(255) default '' INPUT_VALUEINPUT_VALUE text DATA_TYPEDATA_TYPE varchar(255) APPLICATION_ARGUMENTAPPLICATION_ARGUMENT varchar(255) STANDARD_INPUTSTANDARD_INPUT bit USER_FRIENDLY_DESCRIPTIONUSER_FRIENDLY_DESCRIPTION varchar(255) METADATAMETADATA varchar(255) INPUT_ORDERINPUT_ORDER int IS_REQUIREDIS_REQUIRED bit REQUIRED_TO_ADDED_TO_CMDREQUIRED_TO_ADDED_TO_CMD bit DATA_STAGEDDATA_STAGED bit STORAGE_RESOURCE_IDSTORAGE_RESOURCE_ID varchar(255) EXPERIMENT_OUTPUTTable airavata.EXPERIMENT_OUTPUT Pk pk_experiment_output ( EXPERIMENT_ID, OUTPUT_NAME ) EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' References EXPERIMENT ( EXPERIMENT_ID ) Pk pk_experiment_output ( EXPERIMENT_ID, OUTPUT_NAME ) OUTPUT_NAMEOUTPUT_NAME * varchar(255) default '' OUTPUT_VALUEOUTPUT_VALUE text DATA_TYPEDATA_TYPE varchar(255) APPLICATION_ARGUMENTAPPLICATION_ARGUMENT varchar(255) IS_REQUIREDIS_REQUIRED bit REQUIRED_TO_ADDED_TO_CMDREQUIRED_TO_ADDED_TO_CMD bit DATA_MOVEMENTDATA_MOVEMENT bit LOCATIONLOCATION varchar(255) SEARCH_QUERYSEARCH_QUERY varchar(255) OUTPUT_STREAMINGOUTPUT_STREAMING smallint STORAGE_RESOURCE_IDSTORAGE_RESOURCE_ID varchar(255) EXPERIMENT_STATUSTable airavata.EXPERIMENT_STATUS Pk pk_experiment_status ( STATUS_ID, EXPERIMENT_ID ) STATUS_IDSTATUS_ID * varchar(255) default '' Pk pk_experiment_status ( STATUS_ID, EXPERIMENT_ID ) EXPERIMENT_ID ( EXPERIMENT_ID ) EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' References EXPERIMENT ( EXPERIMENT_ID ) STATESTATE varchar(255) TIME_OF_STATE_CHANGETIME_OF_STATE_CHANGE * timestamp default CURRENT_TIMESTAMP REASONREASON longtext GATEWAYTable airavata.GATEWAY Pk pk_gateway ( GATEWAY_ID ) GATEWAY_IDGATEWAY_ID * varchar(255) default '' Referred by GATEWAY_WORKER ( GATEWAY_ID ) Referred by PROJECT ( GATEWAY_ID ) GATEWAY_NAMEGATEWAY_NAME varchar(255) DOMAINDOMAIN varchar(255) EMAIL_ADDRESSEMAIL_ADDRESS varchar(255) GATEWAY_ACRONYMGATEWAY_ACRONYM varchar(255) GATEWAY_ADMIN_EMAILGATEWAY_ADMIN_EMAIL varchar(255) GATEWAY_ADMIN_FIRST_NAMEGATEWAY_ADMIN_FIRST_NAME varchar(255) GATEWAY_APPROVAL_STATUSGATEWAY_APPROVAL_STATUS varchar(255) GATEWAY_PUBLIC_ABSTRACTGATEWAY_PUBLIC_ABSTRACT varchar(255) GATEWAY_URLGATEWAY_URL varchar(255) GATEWAY_ADMIN_LAST_NAMEGATEWAY_ADMIN_LAST_NAME varchar(255) IDENTITY_SERVER_PASSWORD_TOKENIDENTITY_SERVER_PASSWORD_TOKEN varchar(255) IDENTITY_SERVER_USERNAMEIDENTITY_SERVER_USERNAME varchar(255) GATEWAY_REVIEW_PROPOSAL_DESCRIPTIONGATEWAY_REVIEW_PROPOSAL_DESCRIPTION varchar(255) DECLINED_REASONDECLINED_REASON varchar(255) OAUTH_CLIENT_SECRETOAUTH_CLIENT_SECRET varchar(255) OAUTH_CLIENT_IDOAUTH_CLIENT_ID varchar(255) REQUEST_CREATION_TIMEREQUEST_CREATION_TIME datetime default CURRENT_TIMESTAMP REQUESTER_USERNAMEREQUESTER_USERNAME varchar(255) GATEWAY_DOMAINGATEWAY_DOMAIN varchar(255) GATEWAY_WORKERTable airavata.GATEWAY_WORKER Pk pk_gateway_worker ( GATEWAY_ID, USER_NAME ) GATEWAY_IDGATEWAY_ID * varchar(255) default '' References GATEWAY ( GATEWAY_ID ) Pk pk_gateway_worker ( GATEWAY_ID, USER_NAME ) USER_NAME ( USER_NAME ) USER_NAMEUSER_NAME * varchar(255) default '' References USERS ( USER_NAME ) JOBTable airavata.JOB Pk pk_job ( JOB_ID, TASK_ID ) JOB_IDJOB_ID * varchar(255) default '' Referred by JOB_STATUS ( JOB_ID, TASK_ID ) Pk pk_job ( JOB_ID, TASK_ID ) TASK_ID ( TASK_ID ) TASK_IDTASK_ID * varchar(255) default '' References TASK ( TASK_ID ) Referred by JOB_STATUS ( JOB_ID, TASK_ID ) PROCESS_IDPROCESS_ID varchar(255) JOB_DESCRIPTIONJOB_DESCRIPTION * longtext CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP COMPUTE_RESOURCE_CONSUMEDCOMPUTE_RESOURCE_CONSUMED varchar(255) JOB_NAMEJOB_NAME varchar(255) WORKING_DIRWORKING_DIR varchar(255) STD_OUTSTD_OUT longtext STD_ERRSTD_ERR longtext EXIT_CODEEXIT_CODE int JOB_STATUSTable airavata.JOB_STATUS Pk pk_job_status ( STATUS_ID, JOB_ID, TASK_ID ) STATUS_IDSTATUS_ID * varchar(255) default '' Pk pk_job_status ( STATUS_ID, JOB_ID, TASK_ID ) JOB_ID ( JOB_ID, TASK_ID ) JOB_IDJOB_ID * varchar(255) default '' References JOB ( JOB_ID, TASK_ID ) Pk pk_job_status ( STATUS_ID, JOB_ID, TASK_ID ) JOB_ID ( JOB_ID, TASK_ID ) TASK_IDTASK_ID * varchar(255) default '' References JOB ( JOB_ID, TASK_ID ) STATESTATE varchar(255) TIME_OF_STATE_CHANGETIME_OF_STATE_CHANGE * timestamp default CURRENT_TIMESTAMP REASONREASON longtext NOTIFICATIONTable airavata.NOTIFICATION Pk pk_notification ( NOTIFICATION_ID ) NOTIFICATION_IDNOTIFICATION_ID * varchar(255) EXPIRATION_DATEEXPIRATION_DATE datetime GATEWAY_IDGATEWAY_ID varchar(255) PUBLISHED_DATEPUBLISHED_DATE datetime TITLETITLE varchar(255) NOTIFICATION_MESSAGENOTIFICATION_MESSAGE * varchar(4096) CREATION_DATECREATION_DATE datetime PRIORITYPRIORITY varchar(255) PROCESSTable airavata.PROCESS Pk pk_process ( PROCESS_ID ) PROCESS_IDPROCESS_ID * varchar(255) default '' Referred by PROCESS_ERROR ( PROCESS_ID ) Referred by PROCESS_INPUT ( PROCESS_ID ) Referred by PROCESS_OUTPUT ( PROCESS_ID ) Referred by PROCESS_RESOURCE_SCHEDULE ( PROCESS_ID ) Referred by PROCESS_STATUS ( PROCESS_ID ) Referred by TASK ( PARENT_PROCESS_ID -> PROCESS_ID ) EXPERIMENT_ID ( EXPERIMENT_ID ) EXPERIMENT_IDEXPERIMENT_ID varchar(255) References EXPERIMENT ( EXPERIMENT_ID ) CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP LAST_UPDATE_TIMELAST_UPDATE_TIME * timestamp default '0000-00-00 00:00:00' PROCESS_DETAILPROCESS_DETAIL text APPLICATION_INTERFACE_IDAPPLICATION_INTERFACE_ID varchar(255) TASK_DAGTASK_DAG text APPLICATION_DEPLOYMENT_IDAPPLICATION_DEPLOYMENT_ID varchar(255) COMPUTE_RESOURCE_IDCOMPUTE_RESOURCE_ID varchar(255) GATEWAY_EXECUTION_IDGATEWAY_EXECUTION_ID varchar(255) ENABLE_EMAIL_NOTIFICATIONENABLE_EMAIL_NOTIFICATION bit EMAIL_ADDRESSESEMAIL_ADDRESSES text STORAGE_RESOURCE_IDSTORAGE_RESOURCE_ID varchar(255) USER_DNUSER_DN varchar(255) GENERATE_CERTGENERATE_CERT smallint EXPERIMENT_DATA_DIREXPERIMENT_DATA_DIR varchar(512) ARCHIVEARCHIVE bit USERNAMEUSERNAME varchar(255) PROCESS_ERRORTable airavata.PROCESS_ERROR Pk pk_process_error ( ERROR_ID, PROCESS_ID ) ERROR_IDERROR_ID * varchar(255) default '' Pk pk_process_error ( ERROR_ID, PROCESS_ID ) PROCESS_ID ( PROCESS_ID ) PROCESS_IDPROCESS_ID * varchar(255) default '' References PROCESS ( PROCESS_ID ) CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP ACTUAL_ERROR_MESSAGEACTUAL_ERROR_MESSAGE text USER_FRIENDLY_MESSAGEUSER_FRIENDLY_MESSAGE text TRANSIENT_OR_PERSISTENTTRANSIENT_OR_PERSISTENT bit ROOT_CAUSE_ERROR_ID_LISTROOT_CAUSE_ERROR_ID_LIST text PROCESS_INPUTTable airavata.PROCESS_INPUT Pk pk_process_input ( PROCESS_ID, INPUT_NAME ) PROCESS_IDPROCESS_ID * varchar(255) default '' References PROCESS ( PROCESS_ID ) Pk pk_process_input ( PROCESS_ID, INPUT_NAME ) INPUT_NAMEINPUT_NAME * varchar(255) default '' INPUT_VALUEINPUT_VALUE text DATA_TYPEDATA_TYPE varchar(255) APPLICATION_ARGUMENTAPPLICATION_ARGUMENT varchar(255) STANDARD_INPUTSTANDARD_INPUT bit USER_FRIENDLY_DESCRIPTIONUSER_FRIENDLY_DESCRIPTION varchar(255) METADATAMETADATA varchar(255) INPUT_ORDERINPUT_ORDER int IS_REQUIREDIS_REQUIRED bit REQUIRED_TO_ADDED_TO_CMDREQUIRED_TO_ADDED_TO_CMD bit DATA_STAGEDDATA_STAGED bit STORAGE_RESOURCE_IDSTORAGE_RESOURCE_ID varchar(255) PROCESS_OUTPUTTable airavata.PROCESS_OUTPUT Pk pk_process_output ( PROCESS_ID, OUTPUT_NAME ) PROCESS_IDPROCESS_ID * varchar(255) default '' References PROCESS ( PROCESS_ID ) Pk pk_process_output ( PROCESS_ID, OUTPUT_NAME ) OUTPUT_NAMEOUTPUT_NAME * varchar(255) default '' OUTPUT_VALUEOUTPUT_VALUE longtext DATA_TYPEDATA_TYPE varchar(255) APPLICATION_ARGUMENTAPPLICATION_ARGUMENT varchar(255) IS_REQUIREDIS_REQUIRED bit REQUIRED_TO_ADDED_TO_CMDREQUIRED_TO_ADDED_TO_CMD bit DATA_MOVEMENTDATA_MOVEMENT bit LOCATIONLOCATION varchar(255) SEARCH_QUERYSEARCH_QUERY varchar(255) OUTPUT_STREAMINGOUTPUT_STREAMING smallint STORAGE_RESOURCE_IDSTORAGE_RESOURCE_ID varchar(255) PROCESS_RESOURCE_SCHEDULETable airavata.PROCESS_RESOURCE_SCHEDULE Pk pk_process_resource_schedule ( PROCESS_ID ) PROCESS_IDPROCESS_ID * varchar(255) default '' References PROCESS ( PROCESS_ID ) RESOURCE_HOST_IDRESOURCE_HOST_ID varchar(255) TOTAL_CPU_COUNTTOTAL_CPU_COUNT int NODE_COUNTNODE_COUNT int NUMBER_OF_THREADSNUMBER_OF_THREADS int QUEUE_NAMEQUEUE_NAME varchar(255) WALL_TIME_LIMITWALL_TIME_LIMIT int TOTAL_PHYSICAL_MEMORYTOTAL_PHYSICAL_MEMORY int STATIC_WORKING_DIRSTATIC_WORKING_DIR varchar(255) OVERRIDE_ALLOCATION_PROJECT_NUMBEROVERRIDE_ALLOCATION_PROJECT_NUMBER varchar(255) OVERRIDE_LOGIN_USER_NAMEOVERRIDE_LOGIN_USER_NAME varchar(255) OVERRIDE_SCRATCH_LOCATIONOVERRIDE_SCRATCH_LOCATION varchar(255) PROCESS_STATUSTable airavata.PROCESS_STATUS Pk pk_process_status ( STATUS_ID, PROCESS_ID ) STATUS_IDSTATUS_ID * varchar(255) default '' Pk pk_process_status ( STATUS_ID, PROCESS_ID ) PROCESS_ID ( PROCESS_ID ) PROCESS_IDPROCESS_ID * varchar(255) default '' References PROCESS ( PROCESS_ID ) STATESTATE varchar(255) TIME_OF_STATE_CHANGETIME_OF_STATE_CHANGE * timestamp default CURRENT_TIMESTAMP REASONREASON longtext PROJECTTable airavata.PROJECT Pk pk_project ( PROJECT_ID ) PROJECT_IDPROJECT_ID * varchar(255) default '' Referred by EXPERIMENT ( PROJECT_ID ) Referred by PROJECT_USER ( PROJECT_ID ) GATEWAY_ID ( GATEWAY_ID ) GATEWAY_IDGATEWAY_ID varchar(255) References GATEWAY ( GATEWAY_ID ) USER_NAME ( USER_NAME ) USER_NAMEUSER_NAME varchar(255) References USERS ( USER_NAME ) PROJECT_NAMEPROJECT_NAME varchar(255) DESCRIPTIONDESCRIPTION varchar(255) CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP PROJECT_USERTable airavata.PROJECT_USER Pk pk_project_user ( PROJECT_ID, USER_NAME ) PROJECT_IDPROJECT_ID * varchar(255) default '' References PROJECT ( PROJECT_ID ) Pk pk_project_user ( PROJECT_ID, USER_NAME ) USER_NAME ( USER_NAME ) USER_NAMEUSER_NAME * varchar(255) default '' References USERS ( USER_NAME ) TASKTable airavata.TASK Pk pk_task ( TASK_ID ) TASK_IDTASK_ID * varchar(255) default '' Referred by JOB ( TASK_ID ) Referred by TASK_ERROR ( TASK_ID ) Referred by TASK_STATUS ( TASK_ID ) TASK_TYPETASK_TYPE varchar(255) PARENT_PROCESS_ID ( PARENT_PROCESS_ID ) PARENT_PROCESS_IDPARENT_PROCESS_ID varchar(255) References PROCESS ( PARENT_PROCESS_ID -> PROCESS_ID ) CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP LAST_UPDATE_TIMELAST_UPDATE_TIME * timestamp default '0000-00-00 00:00:00' TASK_DETAILTASK_DETAIL text TASK_INTERNAL_STORETASK_INTERNAL_STORE tinyint SUB_TASK_MODELSUB_TASK_MODEL blob TASK_ERRORTable airavata.TASK_ERROR Pk pk_task_error ( ERROR_ID, TASK_ID ) ERROR_IDERROR_ID * varchar(255) default '' Pk pk_task_error ( ERROR_ID, TASK_ID ) TASK_ID ( TASK_ID ) TASK_IDTASK_ID * varchar(255) default '' References TASK ( TASK_ID ) CREATION_TIMECREATION_TIME * timestamp default CURRENT_TIMESTAMP ACTUAL_ERROR_MESSAGEACTUAL_ERROR_MESSAGE text USER_FRIENDLY_MESSAGEUSER_FRIENDLY_MESSAGE text TRANSIENT_OR_PERSISTENTTRANSIENT_OR_PERSISTENT bit ROOT_CAUSE_ERROR_ID_LISTROOT_CAUSE_ERROR_ID_LIST text TASK_STATUSTable airavata.TASK_STATUS Pk pk_task_status ( STATUS_ID, TASK_ID ) STATUS_IDSTATUS_ID * varchar(255) default '' Pk pk_task_status ( STATUS_ID, TASK_ID ) TASK_ID ( TASK_ID ) TASK_IDTASK_ID * varchar(255) default '' References TASK ( TASK_ID ) STATESTATE varchar(255) TIME_OF_STATE_CHANGETIME_OF_STATE_CHANGE * timestamp default CURRENT_TIMESTAMP REASONREASON longtext USERSTable airavata.USERS Pk pk_users ( USER_NAME, GATEWAY_ID ) USER_NAMEUSER_NAME * varchar(255) default '' Referred by GATEWAY_WORKER ( USER_NAME ) Referred by PROJECT_USER ( USER_NAME ) Referred by PROJECT ( USER_NAME ) Pk pk_users ( USER_NAME, GATEWAY_ID ) GATEWAY_IDGATEWAY_ID * varchar(255) default '' Unq AIRAVATA_INTERNAL_USER_ID ( AIRAVATA_INTERNAL_USER_ID ) AIRAVATA_INTERNAL_USER_IDAIRAVATA_INTERNAL_USER_ID * varchar(255) PASSWORDPASSWORD varchar(255) USER_CONFIGURATION_DATATable airavata.USER_CONFIGURATION_DATA Pk pk_user_configuration_data ( EXPERIMENT_ID ) EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' References EXPERIMENT ( EXPERIMENT_ID ) AIRAVATA_AUTO_SCHEDULEAIRAVATA_AUTO_SCHEDULE bit OVERRIDE_MANUAL_SCHEDULED_PARAMSOVERRIDE_MANUAL_SCHEDULED_PARAMS bit SHARE_EXPERIMENT_PUBLICALLYSHARE_EXPERIMENT_PUBLICALLY bit THROTTLE_RESOURCESTHROTTLE_RESOURCES bit USER_DNUSER_DN varchar(255) GENERATE_CERTGENERATE_CERT bit RESOURCE_HOST_IDRESOURCE_HOST_ID varchar(255) TOTAL_CPU_COUNTTOTAL_CPU_COUNT int NODE_COUNTNODE_COUNT int NUMBER_OF_THREADSNUMBER_OF_THREADS int QUEUE_NAMEQUEUE_NAME varchar(255) WALL_TIME_LIMITWALL_TIME_LIMIT int TOTAL_PHYSICAL_MEMORYTOTAL_PHYSICAL_MEMORY int STATIC_WORKING_DIRSTATIC_WORKING_DIR varchar(255) STORAGE_RESOURCE_IDSTORAGE_RESOURCE_ID varchar(255) EXPERIMENT_DATA_DIREXPERIMENT_DATA_DIR varchar(512) OVERRIDE_ALLOCATION_PROJECT_NUMBEROVERRIDE_ALLOCATION_PROJECT_NUMBER varchar(255) OVERRIDE_LOGIN_USER_NAMEOVERRIDE_LOGIN_USER_NAME varchar(255) OVERRIDE_SCRATCH_LOCATIONOVERRIDE_SCRATCH_LOCATION varchar(255) EXPERIMENT_SUMMARYView airavata.EXPERIMENT_SUMMARY EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' PROJECT_IDPROJECT_ID varchar(255) GATEWAY_IDGATEWAY_ID varchar(255) USER_NAMEUSER_NAME varchar(255) EXECUTION_IDEXECUTION_ID varchar(255) EXPERIMENT_NAMEEXPERIMENT_NAME varchar(255) CREATION_TIMECREATION_TIME * timestamp default '0000-00-00 00:00:00' DESCRIPTIONDESCRIPTION varchar(255) STATESTATE varchar(255) RESOURCE_HOST_IDRESOURCE_HOST_ID varchar(255) TIME_OF_STATE_CHANGETIME_OF_STATE_CHANGE timestamp default '0000-00-00 00:00:00' LATEST_EXPERIMENT_STATUSView airavata.LATEST_EXPERIMENT_STATUS EXPERIMENT_IDEXPERIMENT_ID * varchar(255) default '' STATESTATE varchar(255) TIME_OF_STATE_CHANGETIME_OF_STATE_CHANGE * timestamp default '0000-00-00 00:00:00' In DbSchema you may create multiple layouts with the same or different tables. Layouts will be saved to project file. Double-click any column, foreign key or table headers to edit.


Table COMMUNITY_USER

Columns
* GATEWAY_ID varchar( 256 )
* COMMUNITY_USER_NAME varchar( 256 )
* TOKEN_ID varchar( 256 )
* COMMUNITY_USER_EMAIL varchar( 256 )
Indexes
Pkpk_community_user ON GATEWAY_ID, COMMUNITY_USER_NAME, TOKEN_ID


Table CONFIGURATION

Columns
* CONFIG_KEY varchar( 255 ) DEFO ''
* CONFIG_VAL varchar( 255 ) DEFO ''
* CATEGORY_ID varchar( 255 ) DEFO ''
* EXPIRE_DATE timestamp DEFO CURRENT_TIMESTAMP
Indexes
Pkpk_configuration ON CONFIG_KEY, CONFIG_VAL, CATEGORY_ID


Table CREDENTIALS

Columns
* GATEWAY_ID varchar( 256 )
* TOKEN_ID varchar( 256 )
* CREDENTIAL blob
* PORTAL_USER_ID varchar( 256 )
* TIME_PERSISTED timestamp DEFO CURRENT_TIMESTAMP
Indexes
Pkpk_credentials ON GATEWAY_ID, TOKEN_ID


Table EXPERIMENT

Columns
* EXPERIMENT_ID varchar( 255 ) DEFO ''
  PROJECT_ID varchar( 255 )
  GATEWAY_ID varchar( 255 )
  EXPERIMENT_TYPE varchar( 255 )
  USER_NAME varchar( 255 )
  EXPERIMENT_NAME varchar( 255 )
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
  DESCRIPTION varchar( 255 )
  EXECUTION_ID varchar( 255 )
  GATEWAY_EXECUTION_ID varchar( 255 )
  ENABLE_EMAIL_NOTIFICATION bit
  EMAIL_ADDRESSES text
  GATEWAY_INSTANCE_ID varchar( 255 )
  ARCHIVE bit
Indexes
Pkpk_experiment ON EXPERIMENT_ID
 PROJECT_ID ON PROJECT_ID
Foreign Keys
 EXPERIMENT_ibfk_1 ( PROJECT_ID ) ref PROJECT (PROJECT_ID)


Table EXPERIMENT_ERROR

Columns
* ERROR_ID varchar( 255 ) DEFO ''
* EXPERIMENT_ID varchar( 255 ) DEFO ''
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
  ACTUAL_ERROR_MESSAGE text
  USER_FRIENDLY_MESSAGE text
  TRANSIENT_OR_PERSISTENT bit
  ROOT_CAUSE_ERROR_ID_LIST text
Indexes
Pkpk_experiment_error ON ERROR_ID, EXPERIMENT_ID
 EXPERIMENT_ID ON EXPERIMENT_ID
Foreign Keys
 EXPERIMENT_ERROR_ibfk_1 ( EXPERIMENT_ID ) ref EXPERIMENT (EXPERIMENT_ID)


Table EXPERIMENT_INPUT

Columns
* EXPERIMENT_ID varchar( 255 ) DEFO ''
* INPUT_NAME varchar( 255 ) DEFO ''
  INPUT_VALUE text
  DATA_TYPE varchar( 255 )
  APPLICATION_ARGUMENT varchar( 255 )
  STANDARD_INPUT bit
  USER_FRIENDLY_DESCRIPTION varchar( 255 )
  METADATA varchar( 255 )
  INPUT_ORDER int
  IS_REQUIRED bit
  REQUIRED_TO_ADDED_TO_CMD bit
  DATA_STAGED bit
  STORAGE_RESOURCE_ID varchar( 255 )
Indexes
Pkpk_experiment_input ON EXPERIMENT_ID, INPUT_NAME
Foreign Keys
 EXPERIMENT_INPUT_ibfk_1 ( EXPERIMENT_ID ) ref EXPERIMENT (EXPERIMENT_ID)


Table EXPERIMENT_OUTPUT

Columns
* EXPERIMENT_ID varchar( 255 ) DEFO ''
* OUTPUT_NAME varchar( 255 ) DEFO ''
  OUTPUT_VALUE text
  DATA_TYPE varchar( 255 )
  APPLICATION_ARGUMENT varchar( 255 )
  IS_REQUIRED bit
  REQUIRED_TO_ADDED_TO_CMD bit
  DATA_MOVEMENT bit
  LOCATION varchar( 255 )
  SEARCH_QUERY varchar( 255 )
  OUTPUT_STREAMING smallint
  STORAGE_RESOURCE_ID varchar( 255 )
Indexes
Pkpk_experiment_output ON EXPERIMENT_ID, OUTPUT_NAME
Foreign Keys
 EXPERIMENT_OUTPUT_ibfk_1 ( EXPERIMENT_ID ) ref EXPERIMENT (EXPERIMENT_ID)


Table EXPERIMENT_STATUS

Columns
* STATUS_ID varchar( 255 ) DEFO ''
* EXPERIMENT_ID varchar( 255 ) DEFO ''
  STATE varchar( 255 )
* TIME_OF_STATE_CHANGE timestamp DEFO CURRENT_TIMESTAMP
  REASON longtext
Indexes
Pkpk_experiment_status ON STATUS_ID, EXPERIMENT_ID
 EXPERIMENT_ID ON EXPERIMENT_ID
Foreign Keys
 EXPERIMENT_STATUS_ibfk_1 ( EXPERIMENT_ID ) ref EXPERIMENT (EXPERIMENT_ID)


Table GATEWAY

Columns
* GATEWAY_ID varchar( 255 ) DEFO ''
  GATEWAY_NAME varchar( 255 )
  DOMAIN varchar( 255 )
  EMAIL_ADDRESS varchar( 255 )
  GATEWAY_ACRONYM varchar( 255 )
  GATEWAY_ADMIN_EMAIL varchar( 255 )
  GATEWAY_ADMIN_FIRST_NAME varchar( 255 )
  GATEWAY_APPROVAL_STATUS varchar( 255 )
  GATEWAY_PUBLIC_ABSTRACT varchar( 255 )
  GATEWAY_URL varchar( 255 )
  GATEWAY_ADMIN_LAST_NAME varchar( 255 )
  IDENTITY_SERVER_PASSWORD_TOKEN varchar( 255 )
  IDENTITY_SERVER_USERNAME varchar( 255 )
  GATEWAY_REVIEW_PROPOSAL_DESCRIPTION varchar( 255 )
  DECLINED_REASON varchar( 255 )
  OAUTH_CLIENT_SECRET varchar( 255 )
  OAUTH_CLIENT_ID varchar( 255 )
  REQUEST_CREATION_TIME datetime DEFO CURRENT_TIMESTAMP
  REQUESTER_USERNAME varchar( 255 )
  GATEWAY_DOMAIN varchar( 255 )
Indexes
Pkpk_gateway ON GATEWAY_ID


Table GATEWAY_WORKER

Columns
* GATEWAY_ID varchar( 255 ) DEFO ''
* USER_NAME varchar( 255 ) DEFO ''
Indexes
Pkpk_gateway_worker ON GATEWAY_ID, USER_NAME
 USER_NAME ON USER_NAME
Foreign Keys
 GATEWAY_WORKER_ibfk_1 ( GATEWAY_ID ) ref GATEWAY (GATEWAY_ID)
 GATEWAY_WORKER_ibfk_2 ( USER_NAME ) ref USERS (USER_NAME)


Table JOB

Columns
* JOB_ID varchar( 255 ) DEFO ''
* TASK_ID varchar( 255 ) DEFO ''
  PROCESS_ID varchar( 255 )
* JOB_DESCRIPTION longtext
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
  COMPUTE_RESOURCE_CONSUMED varchar( 255 )
  JOB_NAME varchar( 255 )
  WORKING_DIR varchar( 255 )
  STD_OUT longtext
  STD_ERR longtext
  EXIT_CODE int
Indexes
Pkpk_job ON JOB_ID, TASK_ID
 TASK_ID ON TASK_ID
Foreign Keys
 JOB_ibfk_1 ( TASK_ID ) ref TASK (TASK_ID)


Table JOB_STATUS

Columns
* STATUS_ID varchar( 255 ) DEFO ''
* JOB_ID varchar( 255 ) DEFO ''
* TASK_ID varchar( 255 ) DEFO ''
  STATE varchar( 255 )
* TIME_OF_STATE_CHANGE timestamp DEFO CURRENT_TIMESTAMP
  REASON longtext
Indexes
Pkpk_job_status ON STATUS_ID, JOB_ID, TASK_ID
 JOB_ID ON JOB_ID, TASK_ID
Foreign Keys
 JOB_STATUS_ibfk_1 ( JOB_ID, TASK_ID ) ref JOB (JOB_ID, TASK_ID)


Table NOTIFICATION

Columns
* NOTIFICATION_ID varchar( 255 )
  EXPIRATION_DATE datetime
  GATEWAY_ID varchar( 255 )
  PUBLISHED_DATE datetime
  TITLE varchar( 255 )
* NOTIFICATION_MESSAGE varchar( 4096 )
  CREATION_DATE datetime
  PRIORITY varchar( 255 )
Indexes
Pkpk_notification ON NOTIFICATION_ID


Table PROCESS

Columns
* PROCESS_ID varchar( 255 ) DEFO ''
  EXPERIMENT_ID varchar( 255 )
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
* LAST_UPDATE_TIME timestamp DEFO '0000-00-00 00:00:00'
  PROCESS_DETAIL text
  APPLICATION_INTERFACE_ID varchar( 255 )
  TASK_DAG text
  APPLICATION_DEPLOYMENT_ID varchar( 255 )
  COMPUTE_RESOURCE_ID varchar( 255 )
  GATEWAY_EXECUTION_ID varchar( 255 )
  ENABLE_EMAIL_NOTIFICATION bit
  EMAIL_ADDRESSES text
  STORAGE_RESOURCE_ID varchar( 255 )
  USER_DN varchar( 255 )
  GENERATE_CERT smallint
  EXPERIMENT_DATA_DIR varchar( 512 )
  ARCHIVE bit
  USERNAME varchar( 255 )
Indexes
Pkpk_process ON PROCESS_ID
 EXPERIMENT_ID ON EXPERIMENT_ID
Foreign Keys
 PROCESS_ibfk_1 ( EXPERIMENT_ID ) ref EXPERIMENT (EXPERIMENT_ID)


Table PROCESS_ERROR

Columns
* ERROR_ID varchar( 255 ) DEFO ''
* PROCESS_ID varchar( 255 ) DEFO ''
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
  ACTUAL_ERROR_MESSAGE text
  USER_FRIENDLY_MESSAGE text
  TRANSIENT_OR_PERSISTENT bit
  ROOT_CAUSE_ERROR_ID_LIST text
Indexes
Pkpk_process_error ON ERROR_ID, PROCESS_ID
 PROCESS_ID ON PROCESS_ID
Foreign Keys
 PROCESS_ERROR_ibfk_1 ( PROCESS_ID ) ref PROCESS (PROCESS_ID)


Table PROCESS_INPUT

Columns
* PROCESS_ID varchar( 255 ) DEFO ''
* INPUT_NAME varchar( 255 ) DEFO ''
  INPUT_VALUE text
  DATA_TYPE varchar( 255 )
  APPLICATION_ARGUMENT varchar( 255 )
  STANDARD_INPUT bit
  USER_FRIENDLY_DESCRIPTION varchar( 255 )
  METADATA varchar( 255 )
  INPUT_ORDER int
  IS_REQUIRED bit
  REQUIRED_TO_ADDED_TO_CMD bit
  DATA_STAGED bit
  STORAGE_RESOURCE_ID varchar( 255 )
Indexes
Pkpk_process_input ON PROCESS_ID, INPUT_NAME
Foreign Keys
 PROCESS_INPUT_ibfk_1 ( PROCESS_ID ) ref PROCESS (PROCESS_ID)


Table PROCESS_OUTPUT

Columns
* PROCESS_ID varchar( 255 ) DEFO ''
* OUTPUT_NAME varchar( 255 ) DEFO ''
  OUTPUT_VALUE longtext
  DATA_TYPE varchar( 255 )
  APPLICATION_ARGUMENT varchar( 255 )
  IS_REQUIRED bit
  REQUIRED_TO_ADDED_TO_CMD bit
  DATA_MOVEMENT bit
  LOCATION varchar( 255 )
  SEARCH_QUERY varchar( 255 )
  OUTPUT_STREAMING smallint
  STORAGE_RESOURCE_ID varchar( 255 )
Indexes
Pkpk_process_output ON PROCESS_ID, OUTPUT_NAME
Foreign Keys
 PROCESS_OUTPUT_ibfk_1 ( PROCESS_ID ) ref PROCESS (PROCESS_ID)


Table PROCESS_RESOURCE_SCHEDULE

Columns
* PROCESS_ID varchar( 255 ) DEFO ''
  RESOURCE_HOST_ID varchar( 255 )
  TOTAL_CPU_COUNT int
  NODE_COUNT int
  NUMBER_OF_THREADS int
  QUEUE_NAME varchar( 255 )
  WALL_TIME_LIMIT int
  TOTAL_PHYSICAL_MEMORY int
  STATIC_WORKING_DIR varchar( 255 )
  OVERRIDE_ALLOCATION_PROJECT_NUMBER varchar( 255 )
  OVERRIDE_LOGIN_USER_NAME varchar( 255 )
  OVERRIDE_SCRATCH_LOCATION varchar( 255 )
Indexes
Pkpk_process_resource_schedule ON PROCESS_ID
Foreign Keys
 PROCESS_RESOURCE_SCHEDULE_ibfk_1 ( PROCESS_ID ) ref PROCESS (PROCESS_ID)


Table PROCESS_STATUS

Columns
* STATUS_ID varchar( 255 ) DEFO ''
* PROCESS_ID varchar( 255 ) DEFO ''
  STATE varchar( 255 )
* TIME_OF_STATE_CHANGE timestamp DEFO CURRENT_TIMESTAMP
  REASON longtext
Indexes
Pkpk_process_status ON STATUS_ID, PROCESS_ID
 PROCESS_ID ON PROCESS_ID
Foreign Keys
 PROCESS_STATUS_ibfk_1 ( PROCESS_ID ) ref PROCESS (PROCESS_ID)


Table PROJECT

Columns
* PROJECT_ID varchar( 255 ) DEFO ''
  GATEWAY_ID varchar( 255 )
  USER_NAME varchar( 255 )
  PROJECT_NAME varchar( 255 )
  DESCRIPTION varchar( 255 )
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
Indexes
Pkpk_project ON PROJECT_ID
 GATEWAY_ID ON GATEWAY_ID
 USER_NAME ON USER_NAME
Foreign Keys
 PROJECT_ibfk_1 ( GATEWAY_ID ) ref GATEWAY (GATEWAY_ID)
 PROJECT_ibfk_2 ( USER_NAME ) ref USERS (USER_NAME)


Table PROJECT_USER

Columns
* PROJECT_ID varchar( 255 ) DEFO ''
* USER_NAME varchar( 255 ) DEFO ''
Indexes
Pkpk_project_user ON PROJECT_ID, USER_NAME
 USER_NAME ON USER_NAME
Foreign Keys
 PROJECT_USER_ibfk_1 ( PROJECT_ID ) ref PROJECT (PROJECT_ID)
 PROJECT_USER_ibfk_2 ( USER_NAME ) ref USERS (USER_NAME)


Table TASK

Columns
* TASK_ID varchar( 255 ) DEFO ''
  TASK_TYPE varchar( 255 )
  PARENT_PROCESS_ID varchar( 255 )
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
* LAST_UPDATE_TIME timestamp DEFO '0000-00-00 00:00:00'
  TASK_DETAIL text
  TASK_INTERNAL_STORE tinyint
  SUB_TASK_MODEL blob
Indexes
Pkpk_task ON TASK_ID
 PARENT_PROCESS_ID ON PARENT_PROCESS_ID
Foreign Keys
 TASK_ibfk_1 ( PARENT_PROCESS_ID ) ref PROCESS (PROCESS_ID)


Table TASK_ERROR

Columns
* ERROR_ID varchar( 255 ) DEFO ''
* TASK_ID varchar( 255 ) DEFO ''
* CREATION_TIME timestamp DEFO CURRENT_TIMESTAMP
  ACTUAL_ERROR_MESSAGE text
  USER_FRIENDLY_MESSAGE text
  TRANSIENT_OR_PERSISTENT bit
  ROOT_CAUSE_ERROR_ID_LIST text
Indexes
Pkpk_task_error ON ERROR_ID, TASK_ID
 TASK_ID ON TASK_ID
Foreign Keys
 TASK_ERROR_ibfk_1 ( TASK_ID ) ref TASK (TASK_ID)


Table TASK_STATUS

Columns
* STATUS_ID varchar( 255 ) DEFO ''
* TASK_ID varchar( 255 ) DEFO ''
  STATE varchar( 255 )
* TIME_OF_STATE_CHANGE timestamp DEFO CURRENT_TIMESTAMP
  REASON longtext
Indexes
Pkpk_task_status ON STATUS_ID, TASK_ID
 TASK_ID ON TASK_ID
Foreign Keys
 TASK_STATUS_ibfk_1 ( TASK_ID ) ref TASK (TASK_ID)


Table USERS

Columns
* USER_NAME varchar( 255 ) DEFO ''
* GATEWAY_ID varchar( 255 ) DEFO ''
* AIRAVATA_INTERNAL_USER_ID varchar( 255 )
  PASSWORD varchar( 255 )
Indexes
Pkpk_users ON USER_NAME, GATEWAY_ID
UAIRAVATA_INTERNAL_USER_ID ON AIRAVATA_INTERNAL_USER_ID


Table USER_CONFIGURATION_DATA

Columns
* EXPERIMENT_ID varchar( 255 ) DEFO ''
  AIRAVATA_AUTO_SCHEDULE bit
  OVERRIDE_MANUAL_SCHEDULED_PARAMS bit
  SHARE_EXPERIMENT_PUBLICALLY bit
  THROTTLE_RESOURCES bit
  USER_DN varchar( 255 )
  GENERATE_CERT bit
  RESOURCE_HOST_ID varchar( 255 )
  TOTAL_CPU_COUNT int
  NODE_COUNT int
  NUMBER_OF_THREADS int
  QUEUE_NAME varchar( 255 )
  WALL_TIME_LIMIT int
  TOTAL_PHYSICAL_MEMORY int
  STATIC_WORKING_DIR varchar( 255 )
  STORAGE_RESOURCE_ID varchar( 255 )
  EXPERIMENT_DATA_DIR varchar( 512 )
  OVERRIDE_ALLOCATION_PROJECT_NUMBER varchar( 255 )
  OVERRIDE_LOGIN_USER_NAME varchar( 255 )
  OVERRIDE_SCRATCH_LOCATION varchar( 255 )
Indexes
Pkpk_user_configuration_data ON EXPERIMENT_ID
Foreign Keys
 USER_CONFIGURATION_DATA_ibfk_1 ( EXPERIMENT_ID ) ref EXPERIMENT (EXPERIMENT_ID)


View EXPERIMENT_SUMMARY

Query
select `E`.`EXPERIMENT_ID` AS `EXPERIMENT_ID`,`E`.`PROJECT_ID` AS `PROJECT_ID`,`E`.`GATEWAY_ID` AS `GATEWAY_ID`,`E`.`USER_NAME` AS `USER_NAME`,`E`.`EXECUTION_ID` AS `EXECUTION_ID`,`E`.`EXPERIMENT_NAME` AS `EXPERIMENT_NAME`,`E`.`CREATION_TIME` AS `CREATION_TIME`,`E`.`DESCRIPTION` AS `DESCRIPTION`,`ES`.`STATE` AS `STATE`,`UD`.`RESOURCE_HOST_ID` AS `RESOURCE_HOST_ID`,`ES`.`TIME_OF_STATE_CHANGE` AS `TIME_OF_STATE_CHANGE` from ((`airavata`.`EXPERIMENT` `E` left join `airavata`.`LATEST_EXPERIMENT_STATUS` `ES` on((`E`.`EXPERIMENT_ID` = `ES`.`EXPERIMENT_ID`))) left join `airavata`.`USER_CONFIGURATION_DATA` `UD` on((`E`.`EXPERIMENT_ID` = `UD`.`EXPERIMENT_ID`))) where 1


View LATEST_EXPERIMENT_STATUS

Query
select `ES1`.`EXPERIMENT_ID` AS `EXPERIMENT_ID`,`ES1`.`STATE` AS `STATE`,`ES1`.`TIME_OF_STATE_CHANGE` AS `TIME_OF_STATE_CHANGE` from (`airavata`.`EXPERIMENT_STATUS` `ES1` left join `airavata`.`EXPERIMENT_STATUS` `ES2` on(((`ES1`.`EXPERIMENT_ID` = `ES2`.`EXPERIMENT_ID`) and (`ES1`.`TIME_OF_STATE_CHANGE` < `ES2`.`TIME_OF_STATE_CHANGE`)))) where isnull(`ES2`.`TIME_OF_STATE_CHANGE`)

Powered by DbSchema