Words/Database.plantuml at master · dlidstrom/Words · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
@startuml Database

legend top
* generating results, crash in middle => no ""Query.result_date""
* when running second time, use unique index
* when all results are stored, compute all
  involved Word's scores by summing among
  all results (not just the one from the
  current query).
end legend

entity Word {
    word_id
    ---
    text
    score INT NOT NULL DEFAULT 0
}

note right of Word
Imported.
end note

entity Query {
    query_id
    ---
    text
    result_date TIMESTAMP WITHOUT TIME ZONE NULL
}

note right of Query
Generated by users.
end note

entity ResultWord {
    result_word_id
    ---
    query_id
    word_id
}

note right of ResultWord
Generated by analysis. Once analysis is done,
""Query.result_date"" is updated.

""(query_id, word_id)"" combination is unique.
end note

Query ||--|{ ResultWord
ResultWord }|--|| Word

@enduml