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