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)