jsp
테이블 (7)
게시글 추천 (board_like)
- brdSeq (brd_seq) — int — 외래 키 → 게시판.brdSeq — NOT NULL — auto increment
- userSeq (user_seq) — int — 외래 키 → 사용자.userSeq — NOT NULL — auto increment
게시판 (board)
- brdSeq (brd_seq) — int — 기본 키 — NOT NULL — auto increment
- brdTitle (brd_title) — varchar — NOT NULL
- brdContent (brd_content) — text — NOT NULL
- brdViewCount (brd_view_count) — int
- createdAt (created_at) — datetime — NOT NULL
- modifiedAt (modified_at) — datetime
- brdLikeCount (brd_like_count) — int
- brdCmtCount (brd_cmt_count) — int
- userSeq (user_seq) — int — 외래 키 → 사용자.userSeq — NOT NULL — auto increment
댓글 (comment)
- cmtSeq (cmt_seq) — int — 기본 키 — NOT NULL — auto increment
- cmtContent (cmt_content) — varchar(2000) — NOT NULL
- createdAt (created_at) — datetime — NOT NULL
- modifiedAt (modified_at) — datetime
- cmtLikeCount (cmt_like_count) — int
- cmtParentSeq (cmt_parent_seq) — int
- cmtIsDeleted (cmt_is_deleted) — tinyint — NOT NULL
- brdSeq (brd_seq) — int — 외래 키 → 게시판.brdSeq — NOT NULL — auto increment
- userSeq (user_seq) — int — 외래 키 → 사용자.userSeq — NOT NULL — auto increment
댓글 추천 (comment_like)
- userSeq (user_seq) — int — 외래 키 → 사용자.userSeq — NOT NULL — auto increment
- cmtSeq (cmt_seq) — int — 외래 키 → 댓글.cmtSeq — NOT NULL — auto increment
사용자 (member)
- userSeq (user_seq) — int — 기본 키 — NOT NULL — auto increment
- userId (user_id) — varchar(10) — NOT NULL
- userPassword (user_password) — varchar(65) — NOT NULL
- userName (user_name) — varchar(10) — NOT NULL
- userNickname (user_nickname) — varchar(10) — NOT NULL
- userEmail (user_email) — varchar(50) — NOT NULL
- createdAt (created_at) — datetime — NOT NULL
- userProfile (user_profile) — varchar(200)
이메일 인증 for 사용자 아이디, 비번 (in memory) (email check userId & password)
- emailCheckSeq (email_check_seq) — int — 기본 키 — NOT NULL
- category — varchar(10) — NOT NULL
- expirationDate (expiration_date) — datetime — NOT NULL
- checkCode (check_code) — varchar(10) — NOT NULL
- checkCount (check_count) — int — NOT NULL
- userName (user_name) — varchar(10) — NOT NULL
- userEmail (user_email) — varchar(50) — NOT NULL
이메일 인증 및 유저 정보 임시저장 (in memory) (email check user signup)
- emailTokenSeq (email_token_seq) — int — 기본 키 — NOT NULL
- emailToken (email_token) — varcahr(50) — NOT NULL
- emailExpirationDate (email_expiration_date) — datetime — NOT NULL
- userId (user_id) — varchar(10) — NOT NULL
- userPassword (user_password) — varchar(20) — NOT NULL
- userName (user_name) — varchar(10) — NOT NULL
- userNickname (user_nickname) — varchar(10) — NOT NULL
- userEmail (user_email) — varchar(50) — NOT NULL
- userProfile (user_profile) — varchar(200)