ERD

Tables (10)

ArrangeSurvey (상담내용정의)

  • caseID — Foreign key → Survey.caseID — NOT NULL
  • ArrangeSurvey_start (Field)
  • ArrangeSurvey_end (Field2)
  • ArrangeSurvey_originator (Field3)

ExternRepair (외부업체 수리)

  • caseID (caseID2) — Foreign key → ArrangeSurvey.caseID — NOT NULL
  • ExternRepair (Field)
  • ExternRepair_originator (Field2)

FirstContact (최초 연락)

  • caseID — Primary key — NOT NULL
  • FirstContact (최초 연락 시간)
  • FirstContact_type (연락 방법)
  • FirstContact_originator (담당자)

ImmediateRepair (당업체 직접 수리)

  • caseID (caseID2) — Foreign key → ArrangeSurvey.caseID — NOT NULL
  • ImmediateRepair_start (Field)
  • ImmediateRepair_start_originator (Field2)
  • ImmediateRepair_end (Field3)
  • ImmediateRepair_end_originator (Field4)

InformClientSurvey (고객문의전산처리)

  • caseID (caseID2) — Foreign key → ArrangeSurvey.caseID — NOT NULL
  • InformClientSurvey (Field)
  • InformClientSurvey_originator (Field2)
  • Field3

InformClientWrongPlace (고객의 잘못된 정보)

  • caseID — Primary key — NOT NULL
  • Field (처리 시간)
  • InformClientWrongPlace_originator (담당자)

InternRepair (단순 수리)

  • caseID (caseID2) — Foreign key → ArrangeSurvey.caseID — NOT NULL
  • InternRepair_start (Field)
  • InternRepair_start_originator (Field2)
  • InternRepair_end (Field3)
  • InternRepair_end_originator (Field4)

MakeTicket (청구서생성)

  • caseID — Primary key — NOT NULL
  • MakeTicket_start (생성 시작 시간)
  • MakeTicket_end (생성 끝 시간)
  • MakeTicket_originator (Field)
  • MakeTicket_originator:1 (Field2)

SendTicketToFinAdmin (청구서발송 to 관리자)

  • caseID (caseID2) — Foreign key → MakeTicket.caseID — NOT NULL
  • SendTicketToFinAdmin (Field)

Survey (상담진행)

  • caseID — Foreign key → FirstContact.caseID — NOT NULL
  • Survey_start (Field)
  • Survey_end (Field2)
  • EstimatedRepairTime (Field3)
  • Survey_originator (Field4)