miniProject-MBTI

Tables (4)

board

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • imageName — VARCHAR(255)
  • description — VARCHAR(255)

comment

  • id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(255)
  • createTime — DATETIME — NOT NULL
  • modifiedDate — DATETIME — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

post

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(100)
  • content — BLOB
  • post_syntax — BIGINT — NOT NULL
  • createTime — DATETIME — NOT NULL
  • modifiedDate — DATETIME — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL

user

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