basketball_db
테이블 (3)
게시판 (article)
- boardId — int — 기본 키 — NOT NULL
- userId — int — 외래 키 → 유저.userId — NOT NULL
- title — varchar(255)
- content — varchar(255)
- createdAt — timestamp(6)
- updatedAt — timestamp(6)
- isDeleted — boolean
- category — int
댓글 (reply)
- replyId — int — 기본 키 — NOT NULL
- boardId — int — 외래 키 → 게시판.boardId — NOT NULL
- userId — int — 외래 키 → 게시판.userId — NOT NULL
- reply — varchar(255)
- createdAt — timestamp(6)
- updatedAt — timestamp(6)
유저 (user)
- userId — int — 기본 키 — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- phoneNumber — varchar(15)
- name — varchar(50) — NOT NULL
- birthDate — date
- profileImageUrl — varchar(255)
- role — varchar(20) — NOT NULL
- isActive — tinyint — NOT NULL — enum으로 변경
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
- lastLoginAt — timestamp