Reviewers

Tables (3)

COMMENT (Untitled2)

  • Key (commentid) — Long — Primary key — NOT NULL
  • Key4 (content) — String — Primary key — NOT NULL
  • Key3 (date) — Timestamp — Primary key — NOT NULL
  • Key (userid) — Long — Foreign key → USER.Key — NOT NULL
  • Key (postid) — Long — Foreign key → POST.Key — NOT NULL
  • Key (username) — String — Foreign key → USER.Key — NOT NULL
  • Key (profile_image) — varchar

POST (Untitled)

  • Key (postid) — Long — Primary key — NOT NULL
  • Key2 (thumbnailURL) — String — Primary key — NOT NULL
  • Key4 (title) — String — Primary key — NOT NULL
  • Key5 (content) — String — Primary key — NOT NULL
  • Key (like) — Int — Primary key — NOT NULL
  • Key2 (date) — Timestamp — Primary key — NOT NULL
  • Key (userid) — String — Foreign key → USER.Key — NOT NULL
  • Key (username) — String — Foreign key → USER.Key — NOT NULL

USER (Untitled3)

  • Key (userid) — Long — Primary key — NOT NULL
  • Key2 (password) — String — Primary key — NOT NULL
  • Key3 (email) — String — Primary key — NOT NULL
  • Key4 (birth) — String — Primary key — NOT NULL
  • Key (username) — String — Primary key — NOT NULL
  • Key (profile_image) — varchar — Primary key — NOT NULL
  • Key (createddate) — Timestamp — Primary key — NOT NULL