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(3, 256) unique, not null
email string(3, 60) unique, not null
hashedPassword string.binary unique, not null
  • username, unique: true
  • email, unique: true
Clone this wiki locally