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