상담플랫폼 수정(23-06-29)
테이블 (14)
choiceKeyword (choice_keyword)
- keywordSeq — autoincreament — 기본 키 — NOT NULL
- Field (keywordNum) — int
- Field (keywordName) — varchar(50)
- Key (categorySeq) — 외래 키 → keywordName.Key — NOT NULL
clientInquiry (client_Inquiry)
- clientInquirySeq (client_inquiry_seq) — autoincreament — 기본 키 — NOT NULL
- clientInquiryCategory (client_inquiry_category) — varchar(20)
- clientInquiryTitle (client_inquiry_title) — varchar(50)
- clientInquiryContent (client_inquiry_content) — varchar(500)
- inquiryCreateDate (inquiry_create_date) — date
- inquiryModifyDate (inquiry_modify_date) — date
- clientSeq (client_seq) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
- counselorSeq (counselor_seq) — autoincreament — 외래 키 → 내담자.counselorSeq — NOT NULL
- clientSeq (client_seq2) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
counselCategory (counsel_category)
- counselCategorySeq (counsel_category_seq) — autoincreament — 기본 키 — NOT NULL
- counselCategoryNum (counsel_category_num) — int
- counselCategoryType (counsel_category_type) — varchar(50)
- counselorSeq (counselor_seq) — autoincreament — 외래 키 → 상담사.counselorSeq — NOT NULL
keywordName (category)
- Key (categorySeq) — autoincreament — 기본 키 — NOT NULL
- keywordName (categoryName) — varchar(50)
reportCategory (report_category)
- reportcategorySeq (report_category_seq) — autoincreament — 기본 키 — NOT NULL
- reportCategory (report_category) — varchar(20)
내담자 (client)
- clientSeq (client_seq) — autoincreament — 기본 키 — NOT NULL
- createdAt (created_at) — datetime(6)
- clientEmail (client_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)
- roleType (role_type) — varchar(20)
- userId (user_id) — varchar(100)
- userName (user_name) — varchar(100)
- counselorSeq (counselor_seq) — autoincreament — 외래 키 → 스위칭.counselorSeq — NOT NULL
- clientSeq (client_seq2) — autoincreament — 외래 키 → 스위칭.clientSeq — NOT NULL
상담 (counseling)
- counselingId (counseling_id) — autoincreament — 기본 키 — NOT NULL
- counselingTitle (counseling_title) — varchar(50)
- counselingContent (counseling_content) — varchar(500)
- counselingKeyword (counseling_keyword) — varchar(20)
- registerDate (request_date) — date
- counselDate (counsel_date) — date
- counselingStatus (counseling_status) — varchar(10)
- counselorSeq (counselor_seq) — autoincreament — 외래 키 → 상담사.counselorSeq — NOT NULL
- clientSeq (client_seq) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
- counselCategorySeq (counsel_category_seq) — autoincreament — 외래 키 → counselCategory.counselCategorySeq — NOT NULL
상담사 (counselor)
- counselorSeq (counselor_seq) — autoincreament — 기본 키 — NOT NULL
- counselorEmail (counselor_email) — varchar(512)
- password — varchar(128)
- counselorName (counselor_name) — varchar(10)
- createdAt (created_at) — datetime(6)
- technical — boolean
- modifiedAt (modified_at) — datetime(6)
- gender — varchar(10)
- profileImageUrl (profile_image_url) — varchar(512)
- userId (user_id) — varchar(100)
- switching (switching_yn) — boolean
- immediate — boolean
- price (Field)
상담채팅 (counselchat)
- chatSeq (chat_seq) — autoincreament — 기본 키 — NOT NULL
- counsultingId (counsulting_id) — autoincreament — 외래 키 → 상담.counselingId — NOT NULL
- chatNo (chat_no) — int
- transferDate (transfer_date) — datetime
- writer — varchar(50)
- chatContent (content) — varchar(1000)
- counselorSeq (counselor_seq2) — autoincreament — 외래 키 — NOT NULL
- clientSeq (client_seq2) — autoincreament — 외래 키 — NOT NULL
스위칭 (switching)
- switchingSeq (switching_seq) — autoincreament — 기본 키 — NOT NULL
- counselorSeq (counselor_seq) — autoincreament — 외래 키 → 상담사.counselorSeq — NOT NULL
- clientSeq (client_seq) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
- createdAt (created_at) — datetime(6)
- iscounselor (Field) — boolean
신고 (report)
- reportId (report_id) — autoincreament — 기본 키 — NOT NULL
- categorySeq (category_seq) — autoincreament — 외래 키 → reportCategory.reportcategorySeq — NOT NULL
- reportDate (report_date) — date
- reporter — varchar(10)
- reportStatus (report_status) — varchar(20)
- counsulting Id (counsulting_id) — autoincreament — 외래 키 → 상담.counselingId — NOT NULL
- counselorSeq (counselor_seq2) — autoincreament — 외래 키 — NOT NULL
- clientSeq (client_seq2) — autoincreament — 외래 키 — NOT NULL
최고에요(좋아요) (best)
- bestSeq (best_seq) — autoincreament — 기본 키 — NOT NULL
- createDate (create_date) — date
- counselorSeq (counselor_seq) — autoincreament — 외래 키 → 상담사.counselorSeq — NOT NULL
- clientSeq (client_seq) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
- counselorSeq (counselor_seq2) — autoincreament — 외래 키 → 내담자.counselorSeq — NOT NULL
- clientSeq (client_seq2) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
후기 (review)
- reviewSeq (review_seq) — autoincreament — 기본 키 — NOT NULL
- counselorSeq (counselor_seq) — autoincreament — 외래 키 → 상담사.counselorSeq — NOT NULL
- reviewContent (review_content) — varchar(500)
- writeDate (write_date) — date
- clientSeq (client_seq) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
- counselorSeq (counselor_seq2) — autoincreament — 외래 키 → 내담자.counselorSeq — NOT NULL
- clientSeq (client_seq2) — autoincreament — 외래 키 → 내담자.clientSeq — NOT NULL
- starScore (Field)