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 — 삭제 여부