sun_station

Tables (7)

Customer (고객)

  • Id (Key) — Primary key — NOT NULL
  • KCN (한전고객번호) — char(12)
  • Name (이름) — char(20)
  • RRN (주민등록번호) — char(14)
  • Phone (연락처) — char(14)
  • Address (신청주소) — varchar
  • Memo (Field) — varchar

KEPCO (한전지사)

  • Id (Key) — Primary key — NOT NULL
  • Name (지사이름)
  • HQName (본부이름)
  • Distrcit (관할)
  • Address (주소)
  • ZipCode (우편번호)
  • Field (상계업무번호)
  • Field2 (상계업무메일)
  • Field (기술검토번호)
  • Field (증설번호)
  • Memo (Field)

Partner (파트너)

  • Id (Key) — Primary key — NOT NULL
  • Name (이름)
  • Phone (전화번호)
  • Memo (Field)

SalesPerson (영업인)

  • Id (Key) — Primary key — NOT NULL
  • Name (이름)
  • Phone (전화번호)
  • Memo (Field)

SunContract (계약)

  • id (Key) — Primary key — NOT NULL
  • CustomerId (고객번호) — Foreign key → Customer.Id — NOT NULL
  • KEPCOId (한전지사번호) — Foreign key → KEPCO.Id — NOT NULL
  • SalesPersonId (영업사원번호) — Foreign key → SalesPerson.Id — NOT NULL
  • PartnerId (파트너번호) — Foreign key → Partner.Id — NOT NULL
  • ContractDate (Field8)
  • Module (Field2)
  • ModuleCount (Field5)
  • Phase (Field3)
  • Voltage (Field4)
  • Price (Field6)
  • SalesPrice (Field7)
  • Memo (Field)

SunContractProcess (계약진행)

  • id (Key) — Foreign key → SunContract.id — NOT NULL
  • Field (승압신청)
  • Field (승압점검)
  • Field (상계신청)
  • Field (기술검토확인)
  • Field (설치일)
  • Field (사용전점검일)
  • Field (입금일)

SunContractProcessPlan (Untitled)

  • id (Key) — Foreign key → SunContract.id — NOT NULL
  • Field (승압점검예정)
  • Field (기술검토확인예정)
  • Field (설치예정)
  • Field (사용전점검예정)
  • Field (입금예정)