hk-qa-test

Tables (12)

Board (RequestBoard)

  • boardId — uuid — Primary key — NOT NULL
  • title (titile) — TEXT
  • content — TEXT
  • createdAt — Date
  • updatedAt — Date
  • boardType (req || update)
  • userId (Author) — UUID/varchar — Foreign key → User.userId — NOT NULL
  • swTypeId (service Category) — UUID/varchar — Foreign key → Software Type.swTypeId — NOT NULL

Deploy Log

  • Key — Primary key — NOT NULL
  • id — Foreign key → Jenkins Deployment.id — NOT NULL
  • userId — UUID/varchar — Foreign key → User.userId — NOT NULL
  • createdAt
  • tag — text

Jenkins Deployment

  • id — Primary key — NOT NULL
  • swTypeId — UUID/varchar — Foreign key → Software Type.swTypeId — NOT NULL
  • deploymentUrl
  • title
  • desc

Reaction_Comment (Reaction)

  • reactionId — UUID/varchar — Primary key — NOT NULL
  • commentId — UUID/varchar — Foreign key → comment.commentId — NOT NULL
  • testUnitId — UUID/varchar — Foreign key → Test Unit.testUnitId — NOT NULL
  • userId — UUID/varchar — Foreign key → User.userId — NOT NULL
  • reactionType — varchar
  • createdAt — Date
  • updatedAt — Date

Software Type (only master create)

  • swTypeId — UUID/varchar — Primary key — NOT NULL
  • typeTitle — varchar
  • typeDesc — TEXT
  • userId — UUID/varchar — Foreign key → User.userId — NOT NULL

Software Version (admin / master create)

  • versionId — UUID/varchar — Primary key — NOT NULL
  • swTypeId — UUID/varchar — Foreign key → Software Type.swTypeId — NOT NULL
  • versionTitle — varchar
  • versionDesc (verisonDesc) — TEXT
  • fileSrc — varchar
  • tag — varchar
  • createdAt — Date
  • updatedAt — Date
  • userId — UUID/varchar — Foreign key → User.userId — NOT NULL

SwMaintainer (SwManager)

  • id — uuid — Primary key — NOT NULL
  • swTypeId — UUID/varchar — Foreign key → Software Type.swTypeId — NOT NULL
  • userId — UUID/varchar — Foreign key → User.userId — NOT NULL
  • createdAt — Date
  • updatedAt — Date

Test Session

  • sessionId — UUID/varchar — Primary key — NOT NULL
  • versionId — UUID/varchar — Foreign key → Software Version.versionId — NOT NULL
  • userId — UUID/varchar — Foreign key → User.userId — NOT NULL
  • status — varchar
  • finishedAt — Date
  • createdAt — Date
  • updatedAt — Date

Test Unit (TestUnit)

  • testUnitId — UUID/varchar — Primary key — NOT NULL
  • versionId — UUID/varchar — Foreign key → Software Version.versionId — NOT NULL
  • unitDesc — varchar
  • createdAt — Date
  • updatedAt — Date

User

  • userId — UUID/varchar — Primary key — NOT NULL
  • userName — varchar
  • email — varchar
  • role — varchar
  • pw — varchar
  • createdAt — Date
  • updatedAt — Date
  • status — varchar

comment

  • commentId — UUID/varchar — Primary key — NOT NULL
  • versionId — UUID/varchar — Foreign key → Software Version.versionId — NOT NULL
  • boardId — UUID/varchar — Foreign key → Board.boardId — NOT NULL
  • parentId — UUID/varchar — Foreign key → comment.commentId — NOT NULL
  • userId — UUID/varchar — Foreign key → User.userId — NOT NULL
  • content — TEXT
  • createdAt — Date
  • updatedAt — Date

status log

  • logId — UUID/varchar — Primary key — NOT NULL
  • sessionId — UUID/varchar — Foreign key → Test Session.sessionId — NOT NULL
  • userId — UUID/varchar
  • status — varchar
  • createdAt — Date