-
Notifications
You must be signed in to change notification settings - Fork 0
Database Schema
ljmurill edited this page Jan 18, 2022
·
6 revisions
name | data type | constraints |
---|---|---|
id | serial | primary key, not null |
username | string(50) | not null, unique |
string | not null, unique | |
hashPassword | string | not null |
createdAt | datetime | not null |
updatedAt | datetime | not null |
name | data type | constraints |
---|---|---|
id | serial | primary key, not null |
content | text | not null |
userId | integer | not null, foreign key references Users |
createdAt | datetime | not null |
updatedAt | datetime | not null |
name | data type | constraints |
---|---|---|
id | serial | primary key, not null |
content | text | not null |
userId | integer | not null, foreign key references Users |
postId | integer | not null, foreign key references Posts |
createdAt | datetime | not null |
updatedAt | datetime | not null |
name | data type | constraints |
---|---|---|
id | serial | primary key, not null |
userId | integer | not null, foreign key references Users |
postId | integer | not null, foreign key references Posts |
commentId | integer | not null, foreign key references Comments |
name | data type | constraints |
---|---|---|
followedId | integer | not null, foreign key references Users |
followerId | integer | not null, foreign key references Users |