RankingBoard
Tables (4)
BOARD_TB (Untitled2)
- boardId (board_id) — int — Primary key — NOT NULL — 게시글 PK
- memberId (member_id) — int — Foreign key → MEMBER_TB.memberId — NOT NULL — PK
- regDate (reg_date) — datetime — NOT NULL — 등록날짜
- modDate (mod_date) — datetime — NOT NULL — 수정날짜
- category — varchar(30) — 카테고리
- title — varchar(30) — NOT NULL — 제목
- content — varchar(255) — NOT NULL — 내용
- image — varchar(255) — unsplash image
- visible — bool — NOT NULL — 공개 여부
- deleted — bool — NOT NULL — 삭제 여부
- commentAvailable (comment_available) — bool — NOT NULL — 댓글 작성 가능 여부
- like — int — NOT NULL — 좋아요 수
MEMBER_ATTENDANCE_TB (Untitled4)
- memberId (member_id) — int — Foreign key → MEMBER_TB.memberId — NOT NULL — PK
- attendanceCount (attendance_count) — int — NOT NULL — 출석일수
- lastAttendanceDate (last_attendance_date) — datetime — NOT NULL — 마지막 출석일자
MEMBER_TB (Untitled)
- memberId (member_id) — int — Primary key — NOT NULL — PK
- regDate (reg_date) — datetime — NOT NULL — 등록날짜
- email — varchar(30) — NOT NULL — 이메일
- modDate (mod_date) — datetime — NOT NULL — 수정날짜
- image — varchar(255) — NOT NULL — 프로필 이미지
- nickname — varchar(10) — NOT NULL — 사용자 닉네임
REPLY_TB (Untitled3)
- replyId (reply_id) — int — Primary key — NOT NULL — 댓글 PK
- memberId (member_id) — int — Foreign key → MEMBER_TB.memberId — NOT NULL — PK
- boardId (board_id) — int — Foreign key → BOARD_TB.boardId — NOT NULL — 게시글 PK
- content — varchar(255) — NOT NULL — 내용
- regDate (reg_date) — datetime — NOT NULL — 작성날짜
- modDate (mod_date) — datetime — NOT NULL — 수정날짜
- visible — bool — NOT NULL — 공개 여부(게시글 작성자한텐 보임)
- deleted — bool — NOT NULL — 삭제 여부