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

상담사Detail (Untitled)

    상담채팅 (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)