team9

Tables (5)

COMMENT

  • commentId (Key) — long — Primary key — NOT NULL
  • postId (Key3) — long — Foreign key → POST.postId — NOT NULL
  • content (Field) — String
  • username (Field2) — boolean

LIKECOMMENT

  • likepostId (Key) — long — Primary key — NOT NULL
  • commentId (Key2) — long — Foreign key → COMMENT.commentId — NOT NULL
  • postId (Key3) — long — Foreign key → COMMENT.postId — NOT NULL
  • username (Field) — String

LIKEPOST

  • likepostId (Key) — long — Primary key — NOT NULL
  • postId (Key2) — long — Foreign key → POST.postId — NOT NULL
  • username (Field) — String

POST

  • postId (Key) — long — Primary key — NOT NULL
  • title (Field) — text
  • content (Field2) — String
  • username (Field3) — String

USER

  • userId (Key) — long — Primary key — NOT NULL
  • username (Field1) — String
  • password (Field2) — int
  • role (Field3) — UserRoleEnum