Database Schema

Database Schema

Users

column name	data type	details
ID	integer	primary key, not null
username	varchar	not null, unique
firstName	varchar	not null
lastName	varchar	not null
emailAddress	varchar	not null, unique
hashedPassword	varchar	not null, unique

Questions

column name	data type	details
ID	integer	primary key, not null
userId	integer	foreign key, not null
question	text	not null
category	varchar	not null
petType	varchar	not null

• userId references users table

Answers

column name	data type	details
ID	integer	primary key, not null
userId	integer	foreign key, not null
questionId	integer	foreign key, not null
answer	text	not null

• userId references users table
• questionId references questions table

Comments

column name	data type	details
ID	integer	primary key, not null
userId	integer	foreign key, not null
answerId	integer	foreign key, not null
content	text	not null

• userId references users table
• userId references answers table