Insurparts Request

Tables (16)

agent (업체정보)

  • id (고유번호) — Primary key — NOT NULL
  • name (업체명) — NOT NULL
  • activate (활성여부) — NOT NULL
  • memo (비고)
  • created (생성일시) — NOT NULL
  • created_by (생성자ID)
  • location (위경도)
  • grade (권한) — NOT NULL

car_maker (차종정보)

  • id (고유번호) — Primary key — NOT NULL
  • name (브랜드명)
  • code (브랜드코드명)
  • common (기본여부) — NOT NULL
  • thumb_img (브랜드이미지) — NOT NULL
  • created_at (생성일시) — NOT NULL
  • created_by_id (생성자아이디) — Foreign key → member.id
  • repair_estimated_period (수리실적)
  • updated_at (갱신일시) — NOT NULL

estimate

  • id — serial4 — Primary key — NOT NULL
  • pdf — varchar(500) — NOT NULL
  • created — timestamptz — NOT NULL
  • created_by — varchar(128) — NOT NULL
  • created_by_name — varchar(128) — NOT NULL
  • lasted — bool — NOT NULL
  • match_id (매칭번호) — Foreign key → parts_brok_match.id — NOT NULL
  • image — varchar(500) — NOT NULL

insurance_comp (보험사정보)

  • id (고유번호) — Primary key — NOT NULL
  • name (보험사명) — NOT NULL
  • order (순서) — NOT NULL
  • prefix_filing_number (접수번호양식)
  • able (활성여부) — NOT NULL
  • etc (비고) — NOT NULL

match_cacl (취소사유[삭제])

  • match_id (매칭번호) — Foreign key → parts_brok_match.id — NOT NULL
  • reason (사유) — NOT NULL
  • created (생성일시) — NOT NULL
  • created_by (생성자아이디) — NOT NULL
  • created_by_name (생성자명) — NOT NULL

match_chat (채팅정보)

  • id (고유번호) — Primary key — NOT NULL
  • seq (순번) — NOT NULL
  • created (생성일시) — NOT NULL
  • created_by (생성자아이디) — NOT NULL
  • created_by_name (생성자명) — NOT NULL
  • agent_name (업체명) — NOT NULL
  • mime (메시지타입) — NOT NULL
  • body (메시지내용)
  • uri (이미지링크)
  • agent_id (업체PK) — NOT NULL
  • sender_type (생성업체타입) — NOT NULL
  • match_id (매칭번호) — Foreign key → parts_brok_match.id — NOT NULL
  • parts_req_id (요청번호) — Foreign key → parts_req.id — NOT NULL

match_chat_readed (채팅읽음정보)

  • id (고유번호) — Primary key — NOT NULL
  • last_readed_seq (최근확인메시지) — NOT NULL
  • rejection (대화참여여부) — NOT NULL
  • member_id (대화참여자) — Foreign key → member.id — NOT NULL
  • parts_req_id (요청번호) — Foreign key → parts_req.id — NOT NULL

match_deli_comp (????)

  • match_id (매칭번호) — Foreign key → parts_brok_match.id — NOT NULL
  • created (생성일시) — NOT NULL
  • created_by (생성자아이디) — NOT NULL
  • created_by_name (생성자명) — NOT NULL

match_giveup (이름변경: match_deprecated)

  • match_id (매칭번호) — Foreign key → parts_brok_match.id — NOT NULL
  • reason (Field) — NOT NULL
  • created (생성일시) — NOT NULL
  • created_by (생성자아이디) — NOT NULL — FK 설정 필요
  • created_by_name (생성자명) — NOT NULL — 삭제 필요
  • type (Field2) — NOT NULL — GIVEUP, REMATCH
  • target (Field3) — [PARTS, REPAIR, INSUR]

match_insur_manager (이름변경: match_manager)

  • id — serial4 — Primary key — NOT NULL
  • manager — varchar(128) — NOT NULL
  • manager_phone — varchar(12) — NOT NULL
  • role — varchar(12) — NOT NULL
  • manager_fax — varchar(12) — NOT NULL
  • created — timestamptz — NOT NULL
  • match_id — Foreign key → parts_brok_match.id — NOT NULL
  • updated_by_id — varchar(128) — NOT NULL

member (회원정보)

  • id (아이디) — Primary key — NOT NULL
  • password (비밀번호) — NOT NULL
  • seq (순번) — NOT NULL
  • hand_phone (전화번호) — NOT NULL
  • name (이름) — NOT NULL
  • activate (활성여부) — NOT NULL
  • grade (직급)
  • pers_fax (팩스번호)
  • busi_card_img (명함사진)
  • profile_img (프로필사진)
  • memo (비고)
  • created (생성일시) — NOT NULL
  • carcenter_in_charge (담당공업사(보험사전용))
  • register_type (가입방법) — NOT NULL — "SELFCLAIM" code 추가
  • partner_id (협력업체PK)
  • partner_member_id (협럭업체사용자아이디) — NOT NULL

parts_bill (청구정보)

  • id (고유번호) — Primary key — NOT NULL
  • status (청구상태) — NOT NULL
  • pdf (pdfURL)
  • manager (담당자명)
  • manager_phone (담당자연락처)
  • manager_fax (담당자팩스번호)
  • created (생성일시) — NOT NULL
  • created_by (생성자아이디)
  • created_by_name (생성자명)
  • lasted (최신여부)
  • bill_created (청구일시)
  • fax_receipt_num
  • match_id (매칭번호) — Foreign key → parts_brok_match.id — NOT NULL
  • carcenter_pdf (공업사용pdf)
  • bill_excel (청구엑셀)
  • image (Field14)
  • deposit_status (Field15) — NOT NULL
  • end_status (Field16) — NOT NULL

parts_brok_match (매칭정보)

  • id (고유번호) — Primary key — NOT NULL
  • status (매칭상태) — NOT NULL
  • match_type (매칭방법) — NOT NULL — null 허용 확정
  • created (생성일시) — NOT NULL
  • created_by — NOT NULL — 필요성 논의
  • created_by_name (생성자명) — NOT NULL — 필요성 논의
  • updated (수정일시)
  • updated_by (수정자ID) — FK 미설정 논의
  • updated_by_name (수정자명)
  • matched (활성여부) — NOT NULL
  • deleted (삭제여부) — NOT NULL — 삭제 확정
  • parts_agent_id (부품사PK) — Foreign key → agent.id — NOT NULL — null 허용
  • parts_req_id (요청번호) — Foreign key → parts_req.id — NOT NULL
  • estimated_delivery (배송예정일)
  • carcenter_agent_id (공업사PK) — 추가 필요
  • insurance_agent_id (보험사PK) — 추가 필요

parts_req (요청정보)

  • id (고유번호) — Primary key — NOT NULL
  • status (요청상태) — 상태값 재정의 필요, 필수값으로 변경
  • created_type (요청주체) — NOT NULL — 필수값
  • created (생성일시) — NOT NULL
  • deleted (삭제여부) — NOT NULL
  • created_by (생성자ID) — Foreign key → member.id — NOT NULL — null 허용 확정
  • car_num (차량번호) — NOT NULL — null 허용 확정
  • insurance_name (보험사명) — 삭제 확정
  • filing_number (접수번호) — parts_brok_match로 이동 확정
  • match_type (매칭방법) — NOT NULL — 삭제 확정
  • vehicle_id (차대번호)
  • vehicle_id_img (차대번호사진)
  • created_by_name (생성자명) — NOT NULL — 삭제 필요
  • warehousing (입고일시) — parts_brok_match로 이동 확정
  • insurance_id (보험사PK) — Foreign key → insurance_comp.id — NOT NULL — parts_brok_match로 이동 확정
  • req_agent_id (요청생성업체PK) — Foreign key → agent.id — NOT NULL — parts_brok_match로 이동 확정
  • car_model (차종)
  • vehicle_release (출고여부) — NOT NULL — parts_brok_match로 이동 확정
  • vehicle_released_at (출고일시) — parts_brok_match로 이동 확정
  • delivery_at (배송일시) — parts_brok_match로 이동 확정
  • from_web (플랫폼) — NOT NULL — 기획팀 논의 필요
  • owner_name (소유자명) — NOT NULL
  • owner_phone (소유자전화번호) — NOT NULL
  • car_color (차량색상)
  • booking_date (예약일시) — parts_brok_match로 이동 확정
  • booking_owner_name (예약자명) — NOT NULL — parts_brok_match로 이동 확정
  • booking_owner_phone (예약자전화번호) — NOT NULL — parts_brok_match로 이동 확정
  • car_maker_id (차종PK) — Foreign key → car_maker.id
  • memo (비고) — 기획팀 논의
  • updated_by (Field) — 추가 확정
  • cancel_reason (Field2) — 추가 확정

parts_req_halla (한라요청정보)

  • seq (고유번호) — Primary key — NOT NULL
  • created_at (생성일시) — NOT NULL
  • updated_at (갱신일시) — NOT NULL
  • guid (한라채널링고유아이디)
  • partner_id (헙력업체PK) — NOT NULL
  • parts_req_id (요청번호) — Foreign key → parts_req.id — NOT NULL

parts_req_insur (보상담당자[삭제])

  • id (고유번호) — Primary key — NOT NULL
  • created (생성일시) — NOT NULL
  • created_by (생성자아이디) — NOT NULL
  • member_id (담당자아이디) — Foreign key → member.id — NOT NULL
  • parts_req_id (요청번호) — Foreign key → parts_req.id — NOT NULL