Database Schema

This page documents the database schema in JDL Studio format. A database is required in this service for persisting requirement sets into ticket systems such as JIRA.

Copy the following code to JDL Studio to display the database diagram.

entity TicketSystemInstance {
    name String,
    type TicketSystem required,
    consumerKey String,
    url String required
}

entity AccessToken {
    token String required,
    salt String required,
    refreshToken String,
    expirationDate ZonedDateTime
}

enum TicketSystem {
    JIRASERVER
    JIRADATACENTER
    JIRACLOUD
}

relationship OneToMany {
    TicketSystemInstance to AccessToken{ticketInstance}
}

relationship ManyToOne {
    AccessToken{user} to User
}

// Set pagination options
paginate * with infinite-scroll
skipClient * except TicketSystemInstance

microservice * with caseManagement