joon

Tables (4)

Board

  • id — SERIAL — Primary key — NOT NULL
  • name — "BoardName" — NOT NULL
  • label — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

LikedPost

  • id — SERIAL — NOT NULL
  • userId — TEXT — NOT NULL
  • postId — INTEGER — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

Post

  • id — SERIAL — Primary key — NOT NULL
  • authorId — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL
  • boardId — INTEGER — NOT NULL

_likedPosts

  • A — INTEGER — NOT NULL
  • B — TEXT — NOT NULL