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