Post

Tables (5)

Untitled (users)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (nickname) — varchar(40)
  • Field (email) — varchar(40)

Untitled (photos)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (filename) — varchar(50)
  • Key (user_id) — bigint — Foreign key → Untitled.Key

Untitled (likes)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (photo_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (settings)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (private) — boolean
  • Field (adding_photos) — varchar(40)
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (comments)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (body) — varchar(40)
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (photo_id) — bigint — Foreign key → Untitled.Key — NOT NULL