board

Tables (6)

Alarm (Untitled6)

  • uuid — uuid — Primary key — NOT NULL
  • 댓글Id (commentId) — uuid — Foreign key → Comment.uuid — NOT NULL
  • uuid (uuid2) — uuid — Foreign key → Comment.댓글작성자 — NOT NULL
  • 알림대상 (targetId) — varcha(50) — NOT NULL
  • 발생일시 (createdDate) — date — NOT NULL
  • 조회여부 (readAt) — char(1) — NOT NULL — 0 - 조회안함, 1 - 조회완료

Board (Untitled2)

  • uuid — uuid — Primary key — NOT NULL
  • 작성자 (member_uuid) — uuid — Foreign key → Member.uuid — NOT NULL — ref Member - userId
  • 글번호 (contentNum) — integer — NOT NULL
  • 제목 (title) — varchar(50) — NOT NULL
  • 내용 (content) — text — NOT NULL
  • 조회수 (views) — integer — NOT NULL
  • 태그 (tag) — varchar(30) — NOT NULL
  • 생성일시 (cretedDate) — date — NOT NULL
  • 수정일시 (modifiedDate) — date
  • 삭제일시 (deletedDate) — date
  • 상태 (state) — varchar(50) — NOT NULL — 일반/신고당함/삭제
  • uuid (uuid2) — uuid — Foreign key → Member.uuid — NOT NULL
  • 게시글Id (board_uuid) — uuid — Foreign key → Member.게시글Id — NOT NULL

Comment (Untitled3)

  • uuid — uuid — Primary key — NOT NULL
  • 게시글Id (board_uuid) — uuid — Foreign key → Board.uuid — NOT NULL
  • 댓글작성자 (member_uuid) — uuid — Foreign key → Board.uuid — NOT NULL
  • 댓글번호 (commentNum) — integer
  • 내용 (content) — text — NOT NULL
  • 생성일시 (createdDate) — date — NOT NULL
  • 수정일시 (modifiedDate) — date
  • 삭제일시 (deletedDate) — date
  • 상태 (deleteFlag) — char(1) — NOT NULL — 0 - 조회가능, 1 - 조회불가능

Member (Untitled)

  • uuid — uuid — Primary key — NOT NULL
  • uuid (uuid2) — uuid — Foreign key → Comment.uuid — NOT NULL
  • 게시글Id (board_uuid) — uuid — Foreign key → Comment.게시글Id — NOT NULL
  • 이메일 (email) — varchar(50) — NOT NULL — unique
  • 아이디 (userId) — varchar(50) — NOT NULL
  • 패스워드 (password) — varchar(50) — NOT NULL
  • 닉네임 (nickname) — varchar(50) — NOT NULL
  • 권한 (role) — varchar(50) — NOT NULL — 0 - 이메일 인증 전
  • 생성일시 (createdDate) — date — NOT NULL — 현재시간
  • 활성화여부 (deleteFlag) — boolean — NOT NULL — t - 비활성화 / f - 활성화
  • 수정일시 (modifiedDate) — date
  • 삭제일시 (deletedDate) — date
  • 경고 (declaration) — integer — 경고 먹을 시 count+
  • 정지 (suspension) — integer — 정지 될 시 count+
  • 상태 (state) — varchar(50) — NOT NULL — 정상 : ok / 정지 : Nok

Reported_board (Untitled4)

  • uuid — uuid — Primary key — NOT NULL
  • 신고자 (reporter) — uuid — Foreign key → Member.uuid — NOT NULL — ref Member - userId
  • 게시글Id (boardId) — uuid — Foreign key → Board.uuid — NOT NULL
  • uuid (uuid2) — uuid — Foreign key → Member.uuid — NOT NULL
  • 게시글Id (board_uuid) — uuid — Foreign key → Member.게시글Id — NOT NULL

Reported_comment (Untitled5)

  • uuid — uuid — Primary key — NOT NULL
  • 신고자 (reporter) — uuid — Foreign key → Member.uuid — NOT NULL
  • 댓글Id (commentId) — uuid — Foreign key → Comment.uuid — NOT NULL
  • uuid (uuid2) — uuid — Foreign key → Member.uuid — NOT NULL
  • 게시글Id (board_uuid) — uuid — Foreign key → Member.게시글Id — NOT NULL