Skip to content

Database Schema

Jump to bottom
Kevin Bartolome edited this page Apr 28, 2022 · 18 revisions

Schema of the PostgreSQL database

Associations

+ Users Table
  - fill in
  - fill in

+ Images Table
  - fill in
  - fill in

+ Comments Table
  - fill in
  - fill in

+ Favorites Table
  - fill in
  - fill in

+ Profile Table
  - fill in
  - fill in

users table

column names data type details
id integer PK, not null
username string(25) unique, not null
email string(50) unique, not null
hashedPassword string.binary unique, not null
  • username, unique: true
  • email, unique: true
Clone this wiki locally