상담플랫폼(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