톡터
테이블 (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