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