Board-TermProject

Tables (7)

board

  • id — BIGINT — Primary key — NOT NULL
  • createtime — DATETIME(6) — NOT NULL
  • modifiedDate — DATETIME(6) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • likes — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL

boardlike

  • id — BIGINT — Primary key — NOT NULL
  • createTime — DATETIME(6) — NOT NULL
  • modifiedDate — DATETIME(6) — NOT NULL
  • boardId — BIGINT — Foreign key → board.id — NOT NULL
  • userId — BIGINT — Foreign key → user.id — NOT NULL

comment

  • id — BIGINT — Primary key — NOT NULL
  • createTime — DATETIME(6) — NOT NULL
  • modifiedDate — DATETIME(6) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • likes — INT — NOT NULL
  • boardId — BIGINT — Foreign key → board.id — NOT NULL

commentlike

  • id — BIGINT — Primary key — NOT NULL
  • createTime — DATETIME(6) — NOT NULL
  • modifiedDate — DATETIME(6) — NOT NULL
  • commentId — BIGINT — Foreign key → comment.id — NOT NULL
  • userId — BIGINT — Foreign key → user.id — NOT NULL

recomment

  • id — BIGINT — Primary key — NOT NULL
  • createTime — DATETIME(6) — NOT NULL
  • modifiedDate — DATETIME(6) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • likes — INT — NOT NULL
  • commentId — BIGINT — Foreign key → comment.id — NOT NULL

recommentlike

  • id — BIGINT — Primary key — NOT NULL
  • recommentId — BIGINT — Foreign key → recomment.id — NOT NULL
  • userId — BIGINT — Foreign key → user.id — NOT NULL

user

  • id — BIGINT — Primary key — NOT NULL
  • createTime — DATETIME(6) — NOT NULL
  • modifiedDate — DATETIME(6) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(255) — NOT NULL