ATS_Practice/database.puml at main · RemiSeg/ATS_Practice · 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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
@startuml
skinparam linetype ortho
skinparam shadowing false

title CV Job AI Matcher - PostgreSQL Schema

entity users {
  * id : BIGSERIAL <<PK>>
  --
  * username : VARCHAR(100) <<UNIQUE>>
  * password_hash : VARCHAR(255)
  * role : VARCHAR(30)
  * created_at : TIMESTAMP
}

entity cv_documents {
  * id : BIGSERIAL <<PK>>
  --
  * user_id : BIGINT <<FK>>
  * file_name : VARCHAR(255)
  * extracted_text : TEXT
  * created_at : TIMESTAMP
}

entity job_descriptions {
  * id : BIGSERIAL <<PK>>
  --
  * created_by_user_id : BIGINT <<FK>>
  * title : VARCHAR(255)
  * company : VARCHAR(255)
  * description_text : TEXT
  * created_at : TIMESTAMP
}

entity match_reports {
  * id : BIGSERIAL <<PK>>
  --
  * user_id : BIGINT <<FK>>
  * cv_document_id : BIGINT <<FK>>
  * job_description_id : BIGINT <<FK>>
  * overall_score : INTEGER
  * matched_skills : JSONB
  * missing_skills : JSONB
  * strengths : JSONB
  * weaknesses : JSONB
  * experience_match : TEXT
  * education_match : TEXT
  * recommendation : TEXT
  * ai_explanation : TEXT
  * status : VARCHAR(30)
  * created_at : TIMESTAMP
}

entity reviewer_feedback {
  * id : BIGSERIAL <<PK>>
  --
  * match_report_id : BIGINT <<FK>>
  * reviewer_id : BIGINT <<FK>>
  * reviewer_score : INTEGER
  * reviewer_notes : TEXT
  * decision : VARCHAR(30)
  * created_at : TIMESTAMP
}

users ||--o{ cv_documents
users ||--o{ job_descriptions
users ||--o{ match_reports
users ||--o{ reviewer_feedback

cv_documents ||--o{ match_reports
job_descriptions ||--o{ match_reports
match_reports ||--o| reviewer_feedback

@enduml