-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_schema
56 lines (48 loc) · 2.83 KB
/
db_schema
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
table: favs
Column Name | Type | Default | Primary | Null | Is Identity
------------------------------------------------------------------------
id | int8 | NULL | yes | no | yes
item_id | int8 | NULL | no | no | no
type | varchar | NULL | no | no | no
user_id | text | NULL | no | no | no
created_at | timestampz | now() | no | yes | no
updated_at | timestampz | now() | no | yes | no
------------------------------------------------------------------------
table: follows
Column Name | Type | Default | Primary | Null | Is Identity
------------------------------------------------------------------------
id | int8 | NULL | yes | no | yes
created_at | timestampz | now() | no | yes | no
updated_at | timestampz | now() | no | yes | no
following | text | NULL | no | no | no
followed | text | NULL | no | no | no
table: list_items
Column Name | Type | Default | Primary | Null | Is Identity
------------------------------------------------------------------------
id | int8 | NULL | yes | no | yes
item_id | int8 | NULL | no | no | no
user_id | text | NULL | no | no | no
list_id | int8 | NULL | no | no | no
type | varchar | NULL | no | no | no
created_at | timestampz | now() | no | yes | no
updated_at | timestampz | now() | no | yes | no
table: lists
Column Name | Type | Default | Primary | Null | Is Identity
------------------------------------------------------------------------
id | int8 | NULL | yes | no | yes
user_id | text | NULL | no | no | no
title | text | NULL | no | no | no
description | text | NULL | no | no | no
poster_url | text | NULL | no | no | no
created_at | timestampz | now() | no | yes | no
updated_at | timestampz | now() | no | yes | no
table: users
Column Name | Type | Default | Primary | Null | Is Identity
------------------------------------------------------------------------
id | int8 | NULL | yes | no | yes
username | text | NULL | no | no | no
profile_picture| text | NULL | no | no | no
bio | text | NULL | no | no | no
user_id | text | NULL | no | no | no
created_at | timestampz | now() | no | yes | no
updated_at | timestampz | now() | no | yes | no