-
Notifications
You must be signed in to change notification settings - Fork 4
/
data_model.txt
43 lines (43 loc) · 4.11 KB
/
data_model.txt
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
+---------------------+
+--------------------+ | poems |
| user_poem_likes | | ------------------- |
| ------------------ | +----------+ id (PK) |
+------> | user (users.id) | | | date |
| | poem (poems.id) | <----+ | author (POETS.id) |
| | (user, poem) (PK) | | content |
| +--------------------+ +-----> | issue (ISSUES.id) |
| | | score |
| +---------------------+ | +---------------------+
| | user_issue_likes | |
| | ------------------ | |
+------> | user (users.id) | |
| | issue (issues.id) | <------+
| | (user, issue) (PK) | | +--------------+
| +---------------------+ | | issues |
| | | ------------ |
+-----------+ | +---------------------+ +-------+ id (PK) +--------------------+
| users | | | user_poet_likes | | date | |
| -------- | | | ------------------ | | description | |
| id (PK) +----------------> | user (users.id) | | upcoming | |
| username | | | poet (poets.id) | <------+ +--------------+ |
| password | | | (user, poet) (PK) | | |
| salt | | +---------------------+ | |
| email | | | |
+-----------+ | | |
| | +-----------------------------+ |
| | | issue_committee_membership | |
| +------------------------+ | | --------------------------- | |
| | poets | +----> | poet (POETS.id) | |
| | --------------------- | | | issue (ISSUES.id) | <----+
| | id (PK) +-----+ | (poet, issue) (PK) | |
+------> | designer (USERS.id) | | +-----------------------------+ |
| birthDate | | |
| deathDate | | |
| name | | |
| description | | +------------------------+ |
| language | | | issue_contributions | |
| programFileName | | | ---------------------- | |
| parameterFileName | +------> | poet (poets.id) | |
+----------> | parameterFileIncluded | | issue (issues.id) | <-------+
one-to-many | path | +------------------------+
+------------------------+