ecms_model
Tables (29)
bizgroup
- Idno — nvarchar(255) — Foreign key → customer.Idno
- StartDate — nvarchar(255)
- ApplDate — nvarchar(255)
- EndDate — vachar
- ExclYn — vachar
- ExclPrice — int
- PrePostYn — nvarchar(255)
- PrePoint — int
- OrzCd1 — nvarchar(255)
- OrzCd2 — nvarchar(255)
- OrzCd3 — nvarchar(255)
- InclSID — nvarchar(255)
- InclCID — nvarchar(255)
charger
- ChargerProdSrno — intPK
- ModelNo — nvarchar(255)
- MakerCd — nvarchar(255)
- MaxWatt — int
- SID — int — Foreign key → station.SID
- CID — int — Foreign key → station.CID
- LTE_IMEI — nvarchar(255)
- LTE_phno — nvarchar(255)
- LTE_ProdSrno — nvarchar(255)
- Voltage — float4
- Current — float4
- Power — float4
- Temerature — float4
- CurrStatus — nvarchar(255)
- LastSatus — nvarchar(255)
- FWChargerVer — nvarchar(255)
- FWLteOcppVer — nvarchar(255)
- FWICOcppVer — nvarchar(255)
- FWICReaderVer — nvarchar(255)
- FWLCDVer — nvarchar(255)
- FWVoiceVer — nvarchar(255)
- FWPowerMeterVer — nvarchar(255)
- ConnectorCnt — int
- ConnectorType — nvarchar(255)
- ConnectorWireLen — int
- Charger_type — nvarchar(255)
- ServiceType — nvarchar(255)
- ServiceDate — nvarchar(255)
- UpdateDt — datetime
- CreatedDt — datetime
- CreateUser — nvarchar(255)
charger_Service
- ChargerProdSrno — intPK — Foreign key → charger.ChargerProdSrno
- RouterSrno — nvarchar(255)
- USIMNo — nvarchar(255)
- CommInfo — nvarchar(255)
- UserKey — nvarchar(255)
- ASMemo — nvarchar(255)
- UserId — nvarchar(255)
- FilePath — nvarchar(255)
- McMemo — nvarchar(255)
- UcMemo — nvarchar(255)
- MagName — nvarchar(255)
- AsName — nvarchar(255)
- OrderType — nvarchar(255)
- status — nvarchar(255)
- Regdt — datetime
- LastUserId — nvarchar(255)
charger_Update
- ChargerProdSrno — intPK — Foreign key → charger_Service.ChargerProdSrno
- UpdateDt — varcharPK
- Ip — nvarchar(255)
- FWChargerVer — nvarchar(255)
- FWLteOcppVer — nvarchar(255)
- FWICOcppVer — nvarchar(255)
- FWICReaderVer — nvarchar(255)
- FWLCDVer — nvarchar(255)
- FWVoiceVer — nvarchar(255)
- FWPowerMeteVer — nvarchar(255)
- McMemo — nvarchar(255)
- UcMemo — nvarchar(255)
- MagName — nvarchar(255)
- AsName — nvarchar(255)
- OrderType — nvarchar(255)
- status — nvarchar(255)
- Regdt — datetime
- LastUserId — nvarchar(255)
charger_activity
- ChargerProdSrno — intPK — Foreign key → charger.ChargerProdSrno
- ActionDate — varcharIDX
- ActionId — varcharIDX
- OccurDt — datetime
- ActCode — varchar(3)
- Message — nvarchar(255)
- Version — varchar(10)
- CustomerId — varchar(20)
charger_log
- OrderNo — int — Foreign key → charging.OrderNo
- ChargerProdSrno — int
- Idno — int
- ChgStartDt — datetime
- ChgEndDt — datetime
charging
- OrderNo — int
- ChargerProdSrno — int — Foreign key → charger.ChargerProdSrno
- Idno — int — Foreign key → customer.Idno
- ChgStartDt — datetime
- ChgEndDt — datetime
- ReqKWatt — float4
- ReqAmount — integer
- FinalAmount — long
- Current — float4
- Voltage — float4
- Wattage — float4
- temperature — float4
- CurrCap — float4
- CurrMain — float4
- CurrTemp — float4
- RFCardNo — long
- PayCardNo — long
- PayPeriodMo — integer
- PayPeriodYr — integer
- AffilType — nvarchar(255)
- PayCompany — nvarchar(255)
- ServiceType — nvarchar(255)
- BizCompanyCd — nvarchar(255)
- BizCompanyName — nvarchar(255)
- LastTxStatus — nvarchar(255)
- UpdateDt — datetime
- UpdateUser — nvarchar(255)
common_code
- CodeType — varchar(4)
- StartDate — varchar(8)
- EndDate — varchar(8)
- CmCd — varchar(4)
- CdName — varchar(100)
- Memo — varchar(100)
consideration
- EventId — intIDX
- SID — nvarchar(255)
- CID — nvarchar(255)
- AffilType — nvarchar(255)
- PayCompany — nvarchar(255)
- ServiceType — nvarchar(255)
- BizCompanyCd — nvarchar(255)
- BizCompanyName — nvarchar(255)
- LastTxStatus — nvarchar(255)
- UpdateDt — datetime
- UpdateUser — nvarchar(255)
- OrderNo — int
- ChargerProdSrno — int
- Idno — int
customer
- Idno — int
- UserId — nvarchar(255)
- UserName — nvarchar(255)
- UserPswd — nvarchar(255)
- BirthDate — date
- Addr1 — nvarchar(255)
- Addr2 — nvarchar(255)
- Zipcode — nvarchar(255)
- RFCardNo — long
- PayCardNo — long
- PayPeriodMo — integer
- PayPeriodYr — integer
- PayCompany — nvarchar(255)
- PrePaid — int
- PostCard — boolean
- ChargeMileage — int
- ExpreDate — date
- MECardNo — long
- ServiceType — nvarchar(255)
- CreatedDt — datetime
- BizCompanyCd — nvarchar(255)
- BizCompanyName — nvarchar(255)
customer_point
- Idno — int
- UserId — varcharIDX
- OccrType — varcharIDX
- OccrDate — varcharIDX
- LastPoint — integer
- CreatedPoint — integer
- ReturnPoint — integer
- CurrPoint — integer
- PointType — nvarchar(255)
- Memo — nvarchar(255)
- ValidYn — vachar
- LastUserId — nvarchar(255)
- LastDt — datetime
division
- CorpCd — nvarchar(255)
- CorpName — nvarchar(255)
- Division — nvarchar(255)
- DivisionName — nvarchar(255)
- ActiveYn — nvarchar(255)
fair_calc
- MstType — varcharIDX
- PriceType — varcharIDX
- MemberType — varcharIDX
- OrderNo — varcharIDX — Foreign key → charging.OrderNo
- CalcDate — varcharIDX
- CalcSrno — intidx
- ValidYn — varcharIDX
- PayDt — datetime
- PayType — nvarchar(255)
- PayMethod — nvarchar(255)
- PayAmount — int
- PayResult — nvarchar(255)
- PgType — nvarchar(255)
- PgKey — nvarchar(255)
- CreditKey — nvarchar(255)
- Idno — nvarchar(255)
- UnitPrice — int
- PaymentId — int
message_log
- LogIdx — int
- LogDt — datetime
- LogType — nvarchar(255)
- MessageCnt — longtext
- ChargerProdSrno — int
- Idno — int
- ResrCmd — nvarchar(255)
- ReqCmd — nvarchar(255)
- RespCmd — nvarchar(255)
- ChgStartDt — datetime
- ChgEndDt — datetime
notify_info
- NotifyNo — intPK
- NotifyDate — nvarchar(255)
- ReceptNo — nvarchar(255)
- NotifyerName — nvarchar(255)
- NotifyerPhone — nvarchar(255)
- ProcStat — nvarchar(255)
- NotifyCd — nvarchar(255)
- NotifyMemo — varchar(400)
- Attachment — blob
- SID — nvarchar(255)
- CID — nvarchar(255)
- ChargerProdSrno — int
- Regdt — datetime
ocpp_code
- ActionId — varchar(4)
- activity — varchar(100)
- Version — varchar(10)
- Memo — varchar(400)
- LastUserId — varchar(10)
- LastDt — datetime
payment
- PaymentId — int — Foreign key → fair_calc.PaymentId
- PermitDate — date
- PayDate — date
- Idno — nvarchar(255)
- UnitPrice — int — Foreign key → unit_price.UnitPrice1
- PayAmount — int
- MemberType — nvarchar(255)
- PostPaidDate — date
- PrePaidNo — long
- PrePaidNoVt — long
- ChargerProdSrno — nvarchar(255)
- RFCardNo — long
- PayCardNo — long
- PayPeriodMo — integer
- PayPeriodYr — integer
- AffilType — nvarchar(255)
- PayCompany — nvarchar(255)
- ServiceType — nvarchar(255)
- BizCompanyCd — nvarchar(255)
- BizCompanyName — nvarchar(255)
- CreatedDt — datetime
- CreateUser — nvarchar(255)
pm_master
- templatId — intPK
- TemplateType — varcharIDX
- ApplDate — varcharIDX
- Cat1No — intPK
- Cat2No — intPK
- Cat3No — intPK
- SeqNo — intPK
- ItemName — nvarchar(255)
- ItemLength — int(4)
- ItemType — nvarchar(255)
- Regdt — datetime
- RegId — varchar(10)
pm_reception
- ReceptNo — intPK — Foreign key → pm_request.ReceptNo
- ReceptType — varcharPK
- ReceptDate — varcharPK
- ReceptId — nvarchar(255)
- RequestCd — nvarchar(255)
- RequestNo — int
- NotifyNo — int
- RequestMemo — varchar(400)
- SID — nvarchar(255)
- CID — nvarchar(255)
- ChargerProdSrno — int
- ProcStat — nvarchar(255)
- ResultCd — nvarchar(255)
- ResultMemo — varchar(400)
- RespId — nvarchar(255)
- Regdt — datetime
- ConfirmId — nvarchar(255)
- ConfirmDt — datetime
- ConfirmStat — nvarchar(255)
- ConfirmMemo — varchar(400)
pm_request
- RequestNo — intPK
- RequestType — varcharPK
- ReqestDate — varcharPK
- RequestId — nvarchar(255) — Foreign key → pm_user.UserId
- RequestCd — nvarchar(255)
- RequestMemo — varchar(400)
- ReceptNo — int
- SID — nvarchar(255)
- CID — nvarchar(255)
- ChargerProdSrno — int
- Regdt — datetime
- RegId — nvarchar(255)
pm_result_FD
- templatId — intPK — Foreign key → pm_templet_common.templatId
- ReceptNo — intPK
- CheckCompleteYN — varchar(1)
- InspValu101 — varchar(10)
- InspValu102 — varchar(10)
- InspValu103 — varchar(10)
- InspValu104 — varchar(10)
- InspValu105 — varchar(10)
- InspValu106 — varchar(10)
- InspValu107 — varchar(10)
- InspValu603 — varchar(200)
- InspValu701 — varchar(200)
- InspValu801 — varchar(200)
pm_result_VD
- templatId — intPK — Foreign key → pm_result_doc.templatId
- ReceptNo — intPK
- Cat1No — intPK
- Cat2No — intPK
- Cat3No — intPK
- CheckDate — varcharIDX
- CheckId — varcharIDX
- ProcStat — varcharIDX
- CheckVal101 — varchar(200)
- Regdt — datetime
- RegId — varchar(10)
pm_result_attach
- templatId — intPK
- ReceptNo — intPK
- AttachIdx — intPK
- AttachFile — blob
- CheckDate — varcharIDX
- CheckId — varcharIDX
- ProcStat — varcharIDX
- CheckVal101 — varchar(200)
- Regdt — datetime
- RegId — varchar(10)
pm_result_doc
- templatId — intPK — Foreign key → pm_templet_common.templatId
- ReceptNo — intPK — Foreign key → pm_reception.ReceptNo
- Cat1No — intPK
- Cat2No — intPK
- Cat3No — intPK
- CheckDate — varcharIDX
- CheckId — varcharIDX
- ProcStat — varcharIDX
- CheckVal — nvarchar(255)
- Regdt — datetime
- RegId — varchar(10)
pm_templet_D
- templatId — intPK — Foreign key → pm_templet_common.templatId
- TemplateType — varcharIDX
- ApplDate — varcharIDX
- CheckCompleteYN — varchar(1)
- InspItem101 — varchar(200)
- InspValu101 — varchar(10)
- InspItem107 — varchar(200)
- InspValu107 — varchar(10)
- InspItem201 — varchar(200)
- InspValu201 — varchar(10)
- InspItem208 — varchar(200)
- InspValu208 — varchar(10)
- InspItem301 — varchar(200)
- InspValu301 — varchar(1)
- InspItem302 — varchar(200)
- InspValu302 — varchar(4)
- InspItem319 — varchar(200)
- InspValu319 — varchar(1)
- InspItem401 — varchar(200)
- InspValu401 — varchar(10)
- InspItem427 — varchar(200)
- InspValu427 — varchar(10)
- InspItem501 — varchar(200)
- InspValu501 — varchar(10)
- InspItem502 — varchar(200)
- InspValu502 — varchar(10)
- InspItem601 — varchar(200)
- InspValu602 — varchar(10)
- InspItem701 — varchar(200)
- InspValu701 — varchar(10)
- InspItem801 — varchar(200)
- InspValu801 — varchar(200)
- InspType — nvarchar(255)
pm_templet_common
- templatId — intPK
- TemplateType — varcharIDX
- ApplDate — varcharIDX
- CheckDate — varchar(8)
- EnvTemp — int(3)
- EnvHumid — int(3)
- InspType — nvarchar(255)
pm_user
- UserId — varcharPK
- UserName — nvarchar(255)
- CorpCd — nvarchar(255) — Foreign key → division.CorpCd
- Division — nvarchar(255)
- Class — nvarchar(255)
- PhoneNo — nvarchar(255)
- Passwd — nvarchar(255)
- AuthRank — nvarchar(255)
- LastLgDt — datetime
- LastAddress — nvarchar(255)
- LockYn — nvarchar(255)
station
- StationId — int
- StationName — nvarchar(255)
- SID — int
- CID — int
- ChrgerCnt — int
- LastAmont — long
- ThisAmout — long
- addr1 — nvarchar(255)
- addr2 — nvarchar(255)
- zipcode — nvarchar(255)
- OprStat — nvarchar(255)
- PermitStat — nvarchar(255)
- MaxWatt — long
- LaunchDate — date
- MgmntCompany — nvarchar(255)
- MgrCheafNo — varhcar
- MgrPhNo1 — varhcar
- MgrPhNo2 — varhcar
- MgrPhNo3 — varhcar
- ConstCompany — nvarchar(255)
- ConstCheafNo — nvarchar(255)
- BizCompanyCd — nvarchar(255)
- BizCompanyName — nvarchar(255)
- ServiceType — nvarchar(255)
- ServiceDate — nvarchar(255)
- UpdateDt — datetime
- CreatedDt — datetime
- CreateUser — nvarchar(255)
unit_price
- PriceType — varcharIDX
- MemberType — varcharIDX
- Region — varcharIDX
- Season — varcharIDX
- LoadType — varcharIDX
- ApplTime — varcharIDX
- StartDate — varcharIDX
- EndDate — nvarchar(255)
- FairDesc — nvarchar(255)
- WattLimit1 — float4
- UnitPrice1 — float4
- WattLimit2 — float4
- UnitPrice2 — float4
- WattLimit3 — float4
- UnitPrice3 — float4
- PolcyDesc — nvarchar(255)
- UpdateDt — datetime
- UpdateUser — nvarchar(255)