Information Metadata System - airavata-courses/TeamAlpha GitHub Wiki

Our design includes five tables:

• job_details
• airavata_user
• host
• job_status
• job_type

The description is as follows:

• job_details: This table has all job related details specific to a certain job.
• airavata_user: This table holds all user specific details.
• host: This table holds all server specific details.
  Master Data:
  • karst
  • bigred2
• job_status: holds status details.
  Master Data:
  • Queued
  • Running
  • Completed
  • Cancelled
• job_type: holds all job types.
  Master Data:
  • LAMMPS
  • GENERAL
  • GROMACS

The database diagram for this information metadata system is as follows: