Remote Care

Tables (5)

Remote_Care_History (리모트 케어 내역)

  • id (Key) — bigint — Primary key — NOT NULL
  • sound_optimize_left (사운드 최적화 left값) — varchar
  • sound_optimize_right (사운드 최적화 right값) — varchar
  • device_type (보청기 종류) — varchar
  • fitting_left (피팅 left값) — text
  • fitting_right (피팅 right값) — text
  • pushStatus (푸시 성공 여부) — char
  • fittingYN (실제 피팅 여부) — char
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime
  • remote_care_reservation_id (리모트 케어 예약 id) — bigint — Foreign key → Remote_Care_Reservation.id — NOT NULL

Remote_Care_Reservation (리모트 케어 예약)

  • id (Key) — bigint — Primary key — NOT NULL
  • comment (사용자 요청) — varchar
  • type (상담 종류) — varchar
  • reservate_date (예약일자) — varchar
  • reservate_time (예약시각) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime
  • customer_id (고객 id) — int — Foreign key → cs_customer.id — NOT NULL

agency (대리점)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (대리점 이름) — varchar
  • phone_number (대리점 전화번호) — varchar
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

cs_customer (방문고객)

  • id (Key) — int — Primary key — NOT NULL
  • phone_number (전화번호) — varchar
  • agency_id (대리점id) — bigint — Foreign key → agency.id — NOT NULL

employee (관리자)

  • id (Key) — bigint — Primary key — NOT NULL
  • agency_id (대리점id) — bigint — Foreign key → agency.id — NOT NULL