톡터

테이블 (19)

AvailableDate (예약가능날짜)

  • available_date_id (Key) — bigint — 기본 키 — NOT NULL
  • counselor_id (Key2) — bigint — 외래 키 → Counselor.counselor_id — NOT NULL
  • date (Field) — date

AvailableTime (예약가능시간대)

  • available_time_id (Key) — bigint — 기본 키 — NOT NULL
  • available_date_id (Key2) — bigint — 외래 키 → AvailableDate.available_date_id — NOT NULL
  • reservation_id (Key3) — bigint — 외래 키 → Reservation.reservation_id — NOT NULL
  • start_time (Field) — timpstamp
  • end_time (Field2) — timestmap

CallLog (통화로그)

  • log_id (Key) — bigint — 기본 키 — NOT NULL
  • room_id (Key2) — bigint — 외래 키 → ChatRoom.room_id — NOT NULL
  • file_url (Field) — varchar(255)
  • created_at (Field2) — timestamp

Career (경력사항)

  • career_id (Key) — bigint — 기본 키 — NOT NULL
  • counselor_id (Key2) — bigint — 외래 키 → Counselor.counselor_id — NOT NULL
  • classification (Field) — varchar
  • company_name (Field2) — varchar(30)
  • responsibilities (Field3) — text

ChatLog (채팅로그)

  • log_id (Key) — bigint — 기본 키 — NOT NULL
  • room_id (Key2) — bigint — 외래 키 → ChatRoom.room_id — NOT NULL
  • sender (Field) — varchar(20)
  • message (Field2) — text
  • created_at (Field3) — timestamp

ChatRoom (채팅방)

  • room_id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
  • counselor_id (Key3) — bigint — 외래 키 → Counselor.counselor_id — NOT NULL
  • room_status (Field) — varchar
  • call_status (Field2) — varchar
  • created_at (Field3) — timestamp

Counselor (상담원)

  • counselor_id (Key) — bigint — 기본 키 — NOT NULL
  • id (Field) — varchar(20)
  • password (Field2) — varchar(255)
  • phone (Field4) — varchar(13)
  • birth (Field5) — date
  • gender (Field6) — varchar
  • member_status (Field7) — varchar
  • name (Field3) — varchar(10)
  • company (Field9) — varchar(20)
  • chat_price (Field10) — int
  • call_price (Field11) — int

CounselorKeyword (상담원의키워드)

  • counselor_keyword_id (Key) — bigint — 기본 키 — NOT NULL
  • counselor_id (Key2) — bigint — 외래 키 → Counselor.counselor_id — NOT NULL
  • keyword_id (Key3) — bigint — 외래 키 → Keyword.keyword_id — NOT NULL

DailyMood (오늘의기분)

  • mood_id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
  • mood (Field) — varchar
  • date (Field2) — date

DefaultDay (요일기본값)

  • time_id (Key) — bigint — 기본 키 — NOT NULL
  • counselor_id (Key2) — bigint — 외래 키 → Counselor.counselor_id — NOT NULL
  • day_of_week (Field) — varchar

DetailTimeSlot (시간기본값)

  • slot_id (Key) — bigint — 기본 키 — NOT NULL
  • time_id (Key2) — bigint — 외래 키 → DefaultDay.time_id — NOT NULL
  • start_time (Field) — timpstamp
  • end_time (Field2) — timestmap

Keyword (키워드)

  • keyword_id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(10)

License (자격증정보)

  • license_id (Key) — bigint — 기본 키 — NOT NULL
  • counselor_id (Key2) — bigint — 외래 키 → Counselor.counselor_id — NOT NULL
  • license_name (Field) — varchar(30)
  • organization (Field2) — varchar(30)
  • issue_date (Field3) — date

Member (일반사용자)

  • member_id (Key) — bigint — 기본 키 — NOT NULL
  • userid (Field) — varchar(20)
  • password (Field2) — varchar(255)
  • nickname (Field3) — varchar(10)
  • birth (Field4) — date
  • gender (Field5) — varchar
  • member_status (Field6) — varchar
  • token (Field7) — varchar(255)
  • created_at (Field8) — timestamp
  • modified_at (Field9) — timestamp

Payment (결제정보)

  • payment_id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
  • payment_type (Field) — enum
  • amount (Field2) — int
  • order_id (Field3) — varchar(255)
  • paymente_key (Field5) — varchar(255)
  • pay_status (Field6) — varchar(255)
  • created_at (Field7) — timestamp

Report (상담보고서)

  • report_id (Key) — bigint — 기본 키 — NOT NULL
  • reservation_id (Key2) — bigint — 외래 키 → Reservation.reservation_id — NOT NULL
  • content (Field) — varchar(255)
  • created_at (Field2) — timestamp

Reservation (예약)

  • reservation_id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
  • reservation_status (Field) — enum
  • comment (Field2) — text
  • cancel_comment (Field3) — text
  • type (Field4) — varchar
  • created_at (Field5) — timestamp
  • modified_at (Field6) — timestamp
  • counselor_id (Field7) — bigint
  • counselor_name (Field8) — varchar(10)
  • fee (Field9) — int
  • date (Field10) — date
  • start_time (Field11) — time
  • end_time (Field12) — time

Review (후기)

  • review_id (Key) — bigint — 기본 키 — NOT NULL
  • reservation_id (Key2) — bigint — 외래 키 → Reservation.reservation_id — NOT NULL
  • content (Field) — varchar(255)
  • rating (Field2) — int
  • created_at (Field3) — timestamp

TestResult (테스트결과)

  • result_id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
  • score (Field) — int
  • test_level (Field2) — varchar
  • comment (Field3) — varchar(255)
  • created_at (Field4) — timestamp