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)