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