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