stubox

Tables (5)

Board

  • boardId — BIGINT — Primary key — NOT NULL — PK, AUTO_INCREMENT
  • name — VARCHAR(30)
  • createdAt — NOT NULL
  • updatedAt

Comment

  • commentId — BIGINT — Primary key — NOT NULL — PK, AUTO_INCREMENT
  • postId — BIGINT — Foreign key → Post.postId — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6)

Post

  • postId — BIGINT — Primary key — NOT NULL — PK, AUTO_INCREMENT
  • userId — BIGINT — Foreign key → Users.userId — NOT NULL
  • boardId — BIGINT — Foreign key → Board.boardId — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

RefreshToken

  • refreshTokenId — BIGINT — Primary key — NOT NULL — PK, AUTO_INCREMENT
  • userId — BIGINT — Foreign key → Users.userId — NOT NULL
  • token — VARCHAR(512) — NOT NULL — UNIQUE, 길이 1000
  • expiredAt — NOT NULL
  • createdAt — NOT NULL
  • updatedAt

Users

  • userId — BIGINT — Primary key — NOT NULL — PK, AUTO_INCREMENT
  • nickname — VARCHAR(30) — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • password — VARCHAR(255) — NOT NULL — Hash
  • role — VARCHAR(30) — NOT NULL — DEFAULT 'USER' / USER, ADMIN
  • provider — NOT NULL
  • createdAt — NOT NULL
  • updatedAt
  • lastLoginAt