RestAPI
Tables (6)
Untitled (Post)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (userid) — BIGINT — Foreign key → User.id — NOT NULL
- Field (title) — VARCHAR
- Field2 (body) — VARCHAR
Untitled (Comment)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (postid) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR
- Field (email) — VARCHAR
- Field2 (body) — VARCHAR
Untitled (Album)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (userid) — BIGINT — Foreign key → User.id — NOT NULL
- Field (title) — VARCHAR
Untitled (Photo)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (albumid) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (title) — VARCHAR
- Field (url) — VARCHAR
- Field (thumbnailUrl) — VARCHAR
Untitled (Todo)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (userid) — BIGINT — Foreign key → User.id — NOT NULL
- Field (title) — VARCHAR
- Field2 (completed) — BOOLEAN
User
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- username — VARCHAR
- Field (email) — VARCHAR
- address — VARCHAR
- Field (phone) — VARCHAR
- Field2 (website) — VARCHAR
- Field (company) — VARCHAR