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