app-deployment

Tables (5)

User

  • id — uuid — Primary key — NOT NULL
  • email — varchar
  • role — varchar
  • createdDate — date
  • updatedDate — date

app

  • id — uuid — Primary key — NOT NULL
  • appName — varchar
  • description — varchar
  • createdDate — date
  • updatedDate — date

app_qalist

  • id — uuid — Primary key — NOT NULL
  • appId — uuid — Foreign key → app.id — NOT NULL
  • userId — uuid — Foreign key → User.id — NOT NULL
  • createdDate — date
  • updatedDate — date

app_version

  • id — uuid — Primary key — NOT NULL
  • appId — uuid — Foreign key → app.id — NOT NULL
  • version — varchar
  • buildNumber — integer
  • deployCate — varchar
  • filePath — varchar
  • createdDate — date
  • updatedDate — date

version_qa_check

  • id — uuid — Primary key — NOT NULL
  • versionId — uuid — Foreign key → app_version.id — NOT NULL
  • qaUserId — uuid — Foreign key → app_qalist.id — NOT NULL
  • approve — Boolean
  • createdDate — date
  • updatedDate — date