safe scan

Tables (5)

entity (Member)

  • Primary Key (memberId) — int — Primary key — NOT NULL
  • Field (id) — String
  • Field2 (password) — String

entity (URL)

  • Key (urlId) — int — Primary key — NOT NULL
  • Field (url) — String

entity (Board)

  • Key (boardId) — int — Primary key — NOT NULL
  • Field (boardName) — String

entity (Post)

  • Key (postId) — int — Primary key — NOT NULL
  • Primary Key (memberId) — int — Foreign key → entity.Primary Key — NOT NULL
  • Key (boardId) — int — Foreign key → entity.Key — NOT NULL
  • Field (title) — String
  • Field2 (content) — String
  • Field3 (imgFile) — BLOB
  • Field (postedAt) — datetime

entity (Comment)

  • Key (commentId) — int — Primary key — NOT NULL
  • Key (postId) — int — Foreign key → entity.Key — NOT NULL
  • Primary Key (memberId) — int — Foreign key → entity.Primary Key — NOT NULL
  • Field (comment) — String — NOT NULL
  • Field2 (commentedAt) — datetime