30 lines
720 B
Text
30 lines
720 B
Text
@startuml
|
|
|
|
!include ./schemes_setup.wsd
|
|
|
|
' Выдавать фронтам кол-во комментариев вычисляемым полем
|
|
|
|
$table("REQUEST", "request") {
|
|
$pk("ID") INTEGER NOT NULL
|
|
$fk("WORKFLOW") INTEGER NOT NULL
|
|
$column("CREATOR") INTEGER NOT NULL
|
|
$column("ASSIGNED") INTEGER NOT NULL
|
|
$enum_link("PRIORITY") VARCHAR
|
|
$column("NAME") VARCHAR
|
|
$column("DESCRIPTION") VARCHAR
|
|
$column("STEP") VARCHAR
|
|
$column("ASSIGNEE") VARCHAR
|
|
$column("LAST_CHANGE") DATE
|
|
$column("CREATED") DATE
|
|
}
|
|
|
|
$type("REQUEST_PRIORITY", "request_priority") {
|
|
$enum_field("High")
|
|
$enum_field("Medium")
|
|
$enum_field("Low")
|
|
}
|
|
|
|
request::PRIORITY -- request_priority
|
|
|
|
|
|
@enduml
|