상담플랫폼(23-10-12)

테이블 (14)

clientUserCategory

  • clientUserCategorySeq (client_user_category_seq) — autoincreament — 기본 키 — NOT NULL
  • userSeq (user_seq) — autoincreament — 외래 키 → 회원.userSeq — NOT NULL
  • counselCategorySeq (counsel_category_seq) — autoincreament — 외래 키 → counsleCategory.counselCategorySeq — NOT NULL

counsleCategory (counsel_category)

  • counselCategorySeq (counsel_category_seq) — autoincreament — 기본 키 — NOT NULL
  • counselCategoryType (counsel_category_type) — varchar(50)

post(상담카드) (post)

  • postSeq (post_seq) — autoincreament — 기본 키 — NOT NULL
  • title — varchar(50)
  • content — varchar(1000)
  • counselingTime (counseling_time) — varchar
  • createdAt (created_at) — date
  • modifiedAt (modified_at) — date
  • deletedAt (deleted_at) — date
  • like — int
  • price — int
  • open — boolean
  • isExpert (is_expert) — boolean
  • career — int
  • userSeq (user_seq) — autoincreament — 외래 키 → 회원.userSeq — NOT NULL

postCategory (Untitled)

  • postCategorySeq (postCategory_seq) — autoincreament — 기본 키 — NOT NULL
  • postSeq (post_seq) — autoincreament — 외래 키 → post(상담카드).postSeq — NOT NULL
  • counselCategorySeq (counsel_category_seq) — autoincreament — 외래 키 → counsleCategory.counselCategorySeq — NOT NULL

price

  • priceSeq (Key) — autoincreament — 기본 키 — NOT NULL
  • counselingTime (counseling_time) — int
  • price — int
  • detailSeq (detail_seq) — autoincreament — 외래 키 → post(상담카드).postSeq — NOT NULL

support(응원하기) (support)

  • supportSeq (support_seq) — autoincreament — 기본 키 — NOT NULL
  • createdAt (created_at) — date
  • isClick (is_click) — boolean
  • boardSeq (board_seq) — autoincreament — 외래 키 → 커뮤니티 게시글.boardSeq — NOT NULL
  • userSeq (user_seq) — autoincreament — 외래 키 → 회원.userSeq — NOT NULL

댓글 (comment)

  • commentSeq (comment_seq) — autoincreament — 기본 키 — NOT NULL
  • commentContent (comment_content) — varchar(500)
  • createdAt (create_date) — date
  • modifyDate (modify_date) — date
  • deleteDate — date
  • deleteOk (delete_ok) — boolean
  • boardSeq (counseling_id) — autoincreament — 외래 키 → 커뮤니티 게시글.boardSeq — NOT NULL
  • commentSeq (comment_seq2) — autoincreament — 외래 키 → 댓글.commentSeq — NOT NULL

상담 현황 (counseling)

  • counselingSeq (counseling_seq) — autoincreament — 기본 키 — NOT NULL
  • counselingUrl (counseling_url) — varchar(1000)
  • counselingMethod (counseling_method) — varchar(50)
  • createdAt (created_at) — date
  • userSeq (user_seq) — autoincreament — 외래 키 → 회원.userSeq — NOT NULL
  • postSeq (post_seq) — autoincreament — 외래 키 → post(상담카드).postSeq — NOT NULL
  • status — varchar(10)

신고 (report)

  • reportId (report_id) — autoincreament — 기본 키 — NOT NULL
  • reportDate (report_date) — date
  • reporter — varchar(10)
  • reportStatus (report_status) — varchar(20)
  • reportContent — varchar(500)
  • counselingSeq (counseling_seq) — autoincreament — 외래 키 → 상담 현황.counselingSeq — NOT NULL

찜하기(좋아요) (best)

  • bestSeq (best_seq) — autoincreament — 기본 키 — NOT NULL
  • createdAt (created_at) — date
  • postSeq (post_seq) — autoincreament — 외래 키 → post(상담카드).postSeq — NOT NULL
  • userSeq (user_seq) — autoincreament — 외래 키 → 회원.userSeq — NOT NULL

커뮤니티 게시글 (board)

  • boardSeq (board_seq) — autoincreament — 기본 키 — NOT NULL
  • boardTitle (board_title) — varchar(50)
  • boardContent (boardContent_content) — varchar(1000)
  • createDate (create_date) — date
  • modifedAt (modified_at) — date
  • deletedAt (deleted_date) — date
  • viewCount (view_count) — int
  • isDelete (is_delete) — boolean
  • cheerup — int
  • counselCategorySeq (counsel_category_seq) — autoincreament — 외래 키 → counsleCategory.counselCategorySeq — NOT NULL

회원 (user)

  • userSeq (user_seq) — autoincreament — 기본 키 — NOT NULL
  • createdAt (created_at) — datetime(6)
  • email — varchar(512)
  • emailVerifiedYn (email_verified_yn) — varchar(1)
  • modifiedAt (modified_at) — datetime(6)
  • password — varchar(128)
  • profileImageUrl (profile_image_url) — varchar(512)
  • providerType (provider_type) — varchar(20)
  • nickName (nick_name) — varchar(100)
  • gender — varchar(10)
  • isWithdraw (is_withdraw) — boolean
  • userId (user_id) — varchar(50)

회원탈퇴(withdraw ) (Withdraw)

  • withdrawUserSeq (withdraw_user_seq) — autoincreament — 기본 키 — NOT NULL
  • withdrawAt (withdraw_at) — date
  • reasonForWithdraw (reason_for_withdraw) — varchar(100)
  • userSeq (user_seq) — autoincreament — 외래 키 → 회원.userSeq — NOT NULL

후기 (review)

  • reviewSeq (review_seq) — autoincreament — 기본 키 — NOT NULL
  • reviewContent (review_content) — varchar(500)
  • createdAt — date
  • modifiedAt (modified_at) — date
  • deletedAt — date
  • starScore — int
  • counselingSeq (counseling_seq) — autoincreament — 외래 키 → 상담 현황.counselingSeq — NOT NULL