Database Schema - OndreWilliams/TownSquare GitHub Wiki

users

column name	data type	details
id	integer	not null, serial, pk
username	string	not null, unique
email	string	not null, unique
hPassword	string	not null, unique
createdAt	datetime	not null
updatedAt	datetime	not null

cities

column name	data type	details
id	integer	not null, serial, pk
name	string	not null, unique
createdAt	datetime	not null
updatedAt	datetime	not null

questions

column name	data type	details
id	integer	not null, serial, pk
content	string	not null
userId	integer	not null, fk
cityId	integer	not null, fk
createdAt	datetime	not null
updatedAt	datetime	not null

• userId references users table
• cityId references city table

comments

column name	data type	details
id	integer	not null, serial, pk
content	string	not null
userId	integer	not null, fk
questionsId	integer	not null, fk
createdAt	datetime	not null
updatedAt	datetime	not null

• userId references users table
• questionId references questions table

votes

column name	data type	details
id	integer	not null, serial, pk
vote	integer	not null
userId	integer	not null, fk
commentId	integer	not null, fk
createdAt	datetime	not null
updatedAt	datetime	not null

• userId references users table
• commentId references comments table