44 lines
807 B
Plaintext
44 lines
807 B
Plaintext
@startuml
|
||
!define table(x) entity x << (T,#FFAAAA) >>
|
||
!define pk(x) <b><u>x</u></b>
|
||
!define fk(x) <i>x</i>
|
||
|
||
skinparam entity {
|
||
BackgroundColor #F5F5F5
|
||
BorderColor #333333
|
||
}
|
||
|
||
table(history) {
|
||
pk(id) : int8 <<IDENTITY>>
|
||
--
|
||
deployment_id : uuid
|
||
content_uuid : uuid
|
||
created : timestamp
|
||
message : varchar(2048)
|
||
}
|
||
|
||
table(lms_content) {
|
||
pk(id) : int8 <<IDENTITY>>
|
||
--
|
||
deployment_id : uuid
|
||
content_uuid : uuid <<INDEX>>
|
||
created : timestamp
|
||
fk(task_id) : int8
|
||
}
|
||
|
||
table(task) {
|
||
pk(id) : int8 <<IDENTITY>>
|
||
--
|
||
data : jsonb
|
||
}
|
||
|
||
lms_content }o--|| task : "task_id → id"
|
||
|
||
note bottom of history
|
||
Нет явных FK связей,
|
||
но content_uuid может
|
||
логически связываться
|
||
с lms_content.content_uuid
|
||
end note
|
||
|
||
@enduml |