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 (입금예정)