HDO ERD

Tables (77)

AppConfig

  • id — int(11) — NOT NULL
  • app_version — varchar(50)
  • force_update_flag — tinyint(4) — 1: true, 0: false
  • dynamic_link — varchar(255)
  • popup_title — varchar(255)
  • popup_body — varchar(255)

AppSetting

  • id — int — 차량 id
  • auto_login_enabled — boolean — NOT NULL
  • notifications_enabled — boolean — NOT NULL
  • ads_enabled — boolean — NOT NULL
  • app_version — varchar(64) — NOT NULL
  • map_app — int — NOT NULL — 0 is a disable
  • app_display — int — NOT NULL
  • usersNewId — string — Foreign key → UsersNew.id
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL

BankCard

  • id — int — id
  • cardNo — string — NOT NULL — card number
  • billingKey — string — Billing key for card automatic payment approval
  • cardBrand — string — Card brand differentiation, e.g., Visa, MasterCard
  • cardIssuer — string — Card issuer, e.g., Shinhan, Kookmin
  • is_favorited — boolean — NOT NULL — use as main card
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • userId — string — Foreign key → UsersNew.id

BannerModel

  • id — UUID — NOT NULL — banner title
  • title — string
  • number — int
  • image — string — banner image
  • secondaryImage — JSON
  • view — int — total viewed
  • bannerPosition — string
  • banner_sliding_yn — BOOLEAN — enable slide for banner (true/false)
  • startdate — DATE — start date show banner
  • enddate — DATE — end date show banner
  • option — string — 자사, 제휴
  • url — string — Image url
  • createdAt — string
  • updatedAt — string

Booking

  • id — int — booking id
  • b_time_in — DATE — start time of reservation
  • b_time_out — DATE — end time of reservation
  • b_date — DATE — reservation date
  • b_status — string — booking status
  • scanType — int
  • chargeType — int
  • maxParkFee — DECIMAL
  • unitPrice — DECIMAL
  • totalPrice — DECIMAL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • userId — string — Foreign key → UsersNew.id
  • vehicleId — string — Foreign key → Vehicle.id
  • chgs_id — string — Foreign key → sb_charging_station.chgs_id
  • chg_id — string — Foreign key → sb_charger.chgs_id

CarWash

  • id — int
  • car_number — int
  • coupon_count — int
  • price — string
  • purchase_data — DATE
  • address — string
  • date_use — string
  • member_name — string
  • is_used_service — BOOLEAN
  • assignment — string
  • user_where — string
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • userId — string — Foreign key → UsersNew.id

ChargerModel

  • id — int
  • modelCode — string
  • manufacturerId — string
  • modelName — STRING
  • maxKw — INTEGER
  • speedType — STRING
  • connectorType — STRING
  • channelCount — INTEGER
  • lastFirmwareVer — STRING
  • pncAvailable — BOOLEAN
  • useYN — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • chargerModelId — string
  • modelId — string

ChargerModelFW

  • id — INTEGER
  • modelId — INTEGER — Foreign key → ChargerModel.id
  • fwVer — STRING
  • fwFileUrl — STRING
  • isLast — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

ChargingStationCluster

  • id — UUID
  • bias — DOUBLE(3,1)
  • zoomLevel — DOUBLE(3,1)
  • size — INTEGER
  • point — JSON
  • center — GEOMETRY('POINT')
  • createdAt — TIMESTAMP

ChargingStationSettlements

  • stationName — STRING
  • stationID — STRING
  • chargerID — STRING
  • totalPowerKW — FLOAT
  • totalFee — INTEGER
  • totalChargingTime — INTEGER
  • settlementStartTime — DATE
  • settlementEndTime — DATE
  • result — STRING
  • sapStartTime — DATE
  • sapEndTime — DATE
  • sapResult — STRING

CodeLookUp

  • id — INTEGER
  • divCode — STRING(32)
  • divComment — STRING(140)
  • sequence — INTEGER
  • descVal — SMALLINT
  • descInfo — STRING
  • isSubCode — BOOLEAN
  • use — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Config

  • id — INTEGER
  • divCode — STRING(32)
  • divComment — STRING(140)
  • cfgVal — STRING(255)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Consultation

  • id — BIGINT.UNSIGNED
  • regNo — STRING(30)
  • messageId — BIGINT.UNSIGNED
  • ktApiId1 — STRING(36)
  • ktApiId2 — STRING(36)
  • incomingCd — ENUM
  • callStartTime — DATE
  • callEndTime — DATE
  • csCls1 — STRING(100)
  • csCls2 — STRING(100)
  • csContent — TEXT
  • prsContent — TEXT
  • statusCd — STRING(10)
  • completeDate — DATE
  • approveWho — STRING(36)
  • approveAt — DATE
  • csClass — ENUM
  • phoneNo — STRING(36)
  • transId — BIGINT.UNSIGNED
  • recordFile — STRING(50)
  • consultantId — STRING — Foreign key → UsersNew.id
  • customerId — STRING — Foreign key → UsersNew.id
  • orgId — STRING — Foreign key → Org.id

CouponModel

  • id — UUID
  • number — STRING
  • information — STRING
  • member — STRING
  • isUsed — BOOLEAN
  • division — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

CsCallLog

  • id — BIGINT.UNSIGNED
  • regNo — STRING(30)
  • agentId — STRING(10)
  • csEvent — STRING(30)
  • callType — STRING(2)
  • cid — STRING(30)
  • uniqueId — STRING(30)

CsLog

  • id — BIGINT.UNSIGNED
  • csId — BIGINT.UNSIGNED
  • regNo — STRING(30)
  • messageId — BIGINT.UNSIGNED
  • ktApiId1 — STRING(36)
  • ktApiId2 — STRING(36)
  • incomingCd — ENUM
  • callStartTime — DATE
  • callEndTime — DATE
  • csCls1 — STRING(10)
  • csCls2 — STRING(10)
  • csContent — TEXT
  • prsContent — TEXT
  • statusCd — STRING(10)
  • completeDate — DATE
  • approveWho — STRING(36)
  • approveAt — DATE
  • csClass — ENUM
  • phoneNo — STRING(36)
  • transId — BIGINT.UNSIGNED
  • recordFile — STRING(50)
  • hisCreatedAt — TIMESTAMP
  • consultantId — STRING — Foreign key → UsersNew.id
  • orgId — STRING — Foreign key → Org.id

CsMessage

  • id — BIGINT.UNSIGNED
  • phoneNo — STRING(36)
  • text_message — STRING(500)
  • regNo — STRING(30)
  • csId — STRING — Foreign key → Consultation.id

CsScript

  • scriptName — STRING(100)
  • scrptContent — TEXT
  • scriptType — String(2)
  • scriptComment — String(100)

CsState

  • csLogId — STRING(36)
  • regNo — STRING(36)
  • seq — INTEGER
  • statusCd — SMALLINT(6)
  • prsContent — TEXT
  • completeDate — DATE

CsTransfer

  • id — BIGINT.UNSIGNED
  • transPart — STRING(100)
  • transWhom — STRING(50)
  • transAt — DATE
  • csId — STRING — Foreign key → Consultation.id

EnvChargeStation

  • id — INTEGER
  • statNm — STRING
  • statId — STRING
  • chgerType — STRING
  • addr — STRING
  • coordinate — GEOMETRY('POINT')
  • lat — STRING
  • lng — STRING
  • busiId — STRING
  • bnm — STRING
  • maxOutput — STRING
  • method — STRING
  • parkingFree — STRING
  • limitYn — ENUM
  • limitDetail — STRING
  • note — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

EnvChargeStationTran

  • statNm — STRING
  • statId — STRING
  • chgerType — STRING
  • addr — STRING
  • coordinate — GEOMETRY('POINT')
  • lat — STRING
  • lng — STRING
  • busiId — STRING
  • bnm — STRING
  • maxOutput — STRING
  • method — STRING
  • parkingFree — STRING
  • limitYn — ENUM
  • limitDetail — STRING
  • note — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

EnvCharger

  • id — INTEGER
  • statNm — STRING
  • statId — STRING
  • chgerId — STRING
  • chgerType — STRING
  • addr — STRING
  • location — STRING
  • lat — STRING
  • lng — STRING
  • stat — STRING
  • statUpdDt — STRING
  • nowTsdt — STRING
  • output — STRING
  • method — STRING
  • parkingFree — STRING
  • note — STRING
  • limitYn — ENUM
  • limitDetail — STRING
  • busiId — STRING
  • bnm — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

EnvChargerOrg

  • statNm — STRING
  • statId — STRING
  • chgerId — STRING
  • chgerType — STRING
  • addr — STRING
  • location — STRING
  • lat — STRING
  • lng — STRING
  • useTime — STRING
  • busiId — STRING
  • bnm — STRING
  • busiNm — STRING
  • busiCall — STRING
  • stat — STRING
  • statUpdDt — STRING
  • lastTsdt — STRING
  • lastTedt — STRING
  • nowTsdt — STRING
  • output — STRING
  • method — STRING
  • kind — STRING
  • kindDetail — STRING
  • parkingFree — STRING
  • note — STRING
  • limitYn — STRING
  • delYn — STRING
  • delDetail — STRING
  • trafficYn — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

EnvChargerTran

  • id — INTEGER
  • statNm — STRING
  • statId — STRING
  • chgerId — STRING
  • chgerType — STRING
  • addr — STRING
  • location — STRING
  • lat — STRING
  • lng — STRING
  • stat — STRING
  • statUpdDt — STRING
  • nowTsdt — STRING
  • output — STRING
  • method — STRING
  • parkingFree — STRING
  • note — STRING
  • limitYn — ENUM
  • limitDetail — STRING
  • busiId — STRING
  • bnm — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

ErrorCode

  • errorCode — STRING(10)
  • errorMsg — STRING(256)
  • solution — STRING(1024)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Faq

  • title — STRING
  • content — TEXT
  • category — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

FavoriteChargerStation

  • id — UUID
  • nickname — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • userId — STRING — Foreign key → UsersNew.id
  • chargerId — STRING — Foreign key → sb_charging_station.chgs_id

FileToCharger

  • id — INTEGER
  • division — ENUM
  • version — STRING(32)
  • fileURL — STRING(2048)
  • newestVersion — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Inquiry

  • content — TEXT
  • title — TEXT
  • status — BOOLEAN
  • categoryName — TEXT
  • comment — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Logging

  • id — STRING(36)
  • timestamp — STRING(255)
  • level — STRING(255)
  • message — STRING(255)
  • info — JSON
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

MessageLog

  • id — BIGINT.UNSIGNED
  • csId — BIGINT.UNSIGNED — Foreign key → UsersNew.id
  • chargerId — INTEGER(10) — Foreign key → sb_charger.chg_id
  • textMessage — TEXT
  • phoneNo — STRING(36)
  • sendDt — DATE
  • returnType — STRING(2)
  • createdAt — TIMESTAMP
  • phoneCaller — STRING(36)

ModificationLogs

  • id — int(11) — NOT NULL — ModificationLog ID
  • status — ENUM — NOT NULL — ModificationLog status
  • ipAddress — varchar(255) — NOT NULL — request ip address
  • record_id — varchar(255) — record id
  • old_data — varchar(1024) — record id
  • new_data — varchar(1024) — record id
  • note — varchar(255) — note user action
  • model_name — varchar(255) — model change
  • url — varchar(255) — url request
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — datetime
  • userId — bigint(20)

NoticeModel

  • id — UUID
  • title — STRING
  • content — STRING
  • regtime — STRING
  • count — INTEGER(5)
  • detail — STRING
  • imageUrl — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Org

  • id — INTEGER(10)
  • category — ENUM
  • fullname — STRING(64)
  • name — STRING(36)
  • bizRegNo — STRING(16)
  • address — STRING(36)
  • contactName — STRING(18)
  • contactPhoneNo — STRING(36)
  • contactEmail — STRING(320)
  • deductType — ENUM
  • discountPrice — SMALLINT
  • staticUnitPrice — SMALLINT
  • payMethodId — INTEGER
  • isPayLater — BOOLEAN
  • isLocked — BOOLEAN
  • billingDate — JSON
  • closed — BOOLEAN
  • area — INTEGER
  • branch — INTEGER
  • haveCarWash — CHAR(1)
  • haveCVS — CHAR(1)
  • STN_STN_SEQ — STRING(36)
  • STN_STN_ID — STRING(36)
  • STN_STN_GUBUN — STRING(36)
  • STN_CUST_NO — STRING(36)
  • STN_ASSGN_AREA_GUBUN — STRING(36)
  • STN_COST_CT — STRING(36)
  • STN_PAL_CT — STRING(36)
  • STN_STN_SHORT_NM — STRING(36)
  • erp — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

PayMethod

  • id — INTEGER(10)
  • seq — INTEGER
  • alias — STRING(20)
  • cardNo — STRING(20)
  • billingKey — STRING(64)
  • cardBrand — STRING(64)
  • cardIssuer — STRING(64)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • userId — STRING — Foreign key → UsersNew.id
  • orgId — STRING — Foreign key → Org.id
  • usersNewId — STRING — Foreign key → UsersNew.id

PaymentLog

  • id — BIGINT — Foreign key → sb_charging_log.cl_id
  • payStatus — ENUM
  • payType — ENUM
  • kicc_pgCno — STRING(36)
  • confirmPrice — INTEGER(10)
  • prepaidPrice — INTEGER(10)
  • cancelPrice — INTEGER(10)
  • chargeFee — INTEGER(10)
  • parkFee — INTEGER(10)
  • payMethodDetail — STRING(32)
  • description — STRING(32)
  • kicc_return — JSON
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • payMethodId — STRING — Foreign key → PayMethod.id
  • orgId — STRING — Foreign key → Org.id
  • userId — STRING — Foreign key → UsersNew.id
  • chgs_id — STRING — Foreign key → sb_charging_station.chgs_id
  • chg_id — STRING — Foreign key → ChargerModel.id
  • bookingId — STRING — Foreign key → Booking.id

PaymentNotification

  • id — BIGINT.UNSIGNED
  • res_cd — CHAR(4)
  • res_msg — STRING(100)
  • cno — STRING(100) — Foreign key → sb_charging_log.pg_cno
  • order_no — STRING(40)
  • amount — INTEGER.UNSIGNED
  • auth_no — STRING(20)
  • tran_date — DATE
  • card_no — STRING(40)
  • issuer_cd — CHAR(3)
  • issuer_nm — STRING(20)
  • acquirer_cd — CHAR(3)
  • acquirer_nm — STRING(20)
  • noint — CHAR(2)
  • install_period — TINYINT
  • used_pnt — INTEGER
  • escrow_yn — ENUM
  • complex_yn — ENUM
  • stat_cd — CHAR(4)
  • stat_msg — STRING(50)
  • van_tid — STRING(32)
  • van_sno — CHAR(12)
  • pay_type — CHAR(2)
  • memb_id — CHAR(8)
  • noti_type — CHAR(2)
  • part_cancel_yn — ENUM
  • memb_gubun — STRING(8)
  • card_gubun — ENUM
  • card_biz_gubun — ENUM
  • cpon_flag — ENUM
  • cardno_hash — STRING(50)
  • sub_card_cd — CHAR(3)
  • bk_pay_yn — ENUM
  • remain_pnt — INTEGER.UNSIGNED
  • accrue_pnt — INTEGER.UNSIGNED
  • canc_date — DATE
  • mgr_amt — INTEGER.UNSIGNED
  • mgr_card_amt — INTEGER.UNSIGNED
  • mgr_cpon_amt — INTEGER.UNSIGNED
  • mgr_seqno — CHAR(20)
  • mgr_req_msg — STRING(100)
  • day_rem_pnt — INTEGER.UNSIGNED
  • month_rem_pnt — INTEGER.UNSIGNED
  • day_rem_cnt — INTEGER.UNSIGNED
  • createdAt — DATE

Point

  • pointType — ENUM
  • pointDate — DATE
  • point — INTEGER
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • bookingId — STRING — Foreign key → Booking.id
  • userId — STRTING — Foreign key → UsersNew.id

RFCardList

  • id — BIGINT.UNSIGNED
  • rfCardNo — STRING(19)
  • usedYN — CHAR(1)
  • usedAt — DATE
  • lostYN — CHAR(1)
  • lostAt — DATE
  • expiredYN — CHAR(1)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • usersNewId — STRING — Foreign key → UsersNew.id

RequestRefund

  • id — BIGINT.UNSIGNED
  • div_code — ENUM
  • refund_reason — STRING(255)
  • oriPgCno — STRING(60)
  • cancelPgCno — STRING(60)
  • statusCode — STRING(60)
  • cancelAmount — INTEGER.UNSIGNED
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • noti_id — BIGINT — Foreign key → PaymentNotification.id
  • chgs_id — STRING

Review

  • id — INTEGER.UNSIGNED
  • content — TEXT
  • chgs_id — INTEGER(10) — Foreign key → sb_charging_station.chgs_id
  • stars — INTEGER
  • images — JSON
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Role

  • id — STRING(36)
  • name — STRING(255)
  • listPermission — JSON
  • readPermission — JSON
  • writePermission — JSON
  • deletePermission — JSON
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

SAP_People

  • PERNR — STRING
  • ENAME — STRING
  • PASSWORD — STRING
  • EMAIL — STRING
  • ORG — STRING
  • ORG1 — STRING
  • JKW — STRING
  • JKW1 — STRING
  • JKG — STRING
  • JKG1 — STRING
  • PHONE — STRING
  • PHONE2 — STRING

SBDailyAmount

  • id — BIGINT.UNSIGNED
  • mall_id — STRING(50)
  • calculate_date — STRING(50)
  • amount — BIGINT(20)

Sb_charge_connection

  • id — INTEGER.UNSIGNED
  • chargeAmount — INTEGER
  • chargedAmount — INTEGER
  • estimateTime — DATE
  • startTime — DATE
  • endTime — DATE
  • chargeAmountKwh — INTEGER
  • chargeAmountPercent — INTEGER
  • chargeStatus — STRING
  • selectedTime — DATE
  • canceledTime — DATE
  • completedTime — DATE
  • remainTime — INTEGER
  • regtime — DATE
  • currentBatteryPercent — INTEGER
  • timeCharged — INTEGER
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • usersNewId — STRING — Foreign key → UsersNew.id
  • chgs_id — STRING — Foreign key → sb_charging_station.chgs_id
  • chg_id — STRING — Foreign key → sb_charger.chg_id
  • bookingId — STRING — Foreign key → Booking.id

Sb_charge_local_ic_pay

  • id — INTEGER.UNSIGNED
  • chg_id — INTEGER
  • ordernumber — STRING
  • paid_fee — INTEGER
  • connector_id — INTEGER
  • cardkey — STRING
  • pretransnumber — STRING
  • approvalnumber — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Sb_charge_local_ic_pay_phone_log

  • id — BIGINT.UNSIGNED
  • chg_id — INTEGER
  • connector_id — INTEGER
  • phone — STRING
  • createdAt — TIMESTAMP

Terms

  • id — INTEGER
  • title — STRING
  • content — TEXT
  • category — STRING
  • useYN — BOOLEAN
  • parentId — INTEGER
  • version — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

TermsAgree

  • id — INTEGER
  • termId — INTEGER — Foreign key → Terms.id
  • userId — INTEGER — Foreign key → UsersNew.id
  • targetId — TEXT
  • target — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

TransactHistoryRecord

  • recordType — STRING(1)
  • paymentMethod — STRING(4)
  • merchantId — STRING(8)
  • settlementDueDate — STRING(8)
  • transactionType — STRING(2)
  • transactionDate — INTEGER
  • originalTransactionDate — INTEGER
  • uniqueTransactionId — INTEGER
  • merchantTransactionId — INTEGER
  • issuer — STRING(10)
  • purchaser — STRING(10)
  • approvalNumber — INTEGER
  • transactionAmount — BIGINT
  • pgFee — BIGINT
  • additionalFee — BIGINT
  • totalFee — BIGINT
  • VAT — BIGINT
  • settlementAmount — BIGINT
  • productName — STRING(100)
  • cancellationTransactionNumber — STRING(20)
  • chgs_id — STRING

TransactHistorySummary

  • recordType — STRING(1)
  • totalRecords — BIGINT
  • totalPages — BIGINT
  • currentPage — BIGINT
  • totalApproved — BIGINT
  • totalApprovedAmount — BIGINT
  • totalCancellationCount — BIGINT
  • totalCancellationAmount — BIGINT
  • totalPointUsageCount — BIGINT
  • totalPointUsageAmount — BIGINT
  • totalPointCancellationCount — BIGINT
  • totalPointCancellationAmount — BIGINT
  • totalPointAccumulationCount — BIGINT
  • totalPointAccumulationAmount — BIGINT
  • totalPointAccumulationCancellationCount — BIGINT
  • totalPointAccumulationCancellationAmount — BIGINT
  • totalVatApproved — BIGINT
  • totalVatCanceled — BIGINT
  • totalServiceFeeApproved — BIGINT
  • totalServiceFeeCanceled — BIGINT
  • reservedField1 — BIGINT
  • reservedField2 — BIGINT

TransactSettlementRecord

  • recordType — STRING(1)
  • paymentMethod — STRING(4)
  • merchantId — STRING(8)
  • settlementDueDate — STRING(8)
  • transactionType — STRING(2)
  • transactionDate — INTEGER
  • originalTransactionDate — INTEGER
  • uniqueTransactionId — INTEGER
  • merchantTransactionId — INTEGER
  • issuer — STRING(10)
  • purchaser — STRING(10)
  • approvalNumber — INTEGER
  • transactionAmount — BIGINT
  • pgFee — BIGINT
  • additionalFee — BIGINT
  • totalFee — BIGINT
  • VAT — BIGINT
  • settlementAmount — BIGINT
  • productName — STRING(100)
  • cancellationTransactionNumber — STRING(20)

TransactSettlementSummary

  • recordType — STRING(1)
  • totalRecords — BIGINT
  • totalPages — BIGINT
  • currentPage — BIGINT
  • totalSalesCount — BIGINT
  • totalSalesAmount — BIGINT
  • totalRefundCount — BIGINT
  • totalRefundAmount — BIGINT
  • totalCountSum — BIGINT
  • totalAmountSum — BIGINT
  • totalPGFees — BIGINT
  • totalAdditionalFees — BIGINT
  • totalFeesSum — BIGINT
  • totalVAT — BIGINT
  • totalSettlementAmount — BIGINT

TroubleReport

  • id — INTEGER(10)
  • troubleTitle — STRING(50)
  • troubleDesc — STRING(255)
  • mediaUrl — JSON
  • reportStatus — ENUM
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • chgs_id — STRING — Foreign key → sb_charging_station.chgs_id
  • chg_id — STRING — Foreign key → sb_charger.chg_id

TroubleShoot

  • id — INTEGER(10)
  • troubleType — ENUM
  • actionTitle — STRING(50)
  • actionDetails — STRING(255)
  • repairCost — STRING(50)
  • mediaUrl — STRING(2048)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • troubleReportId — STRING — Foreign key → TroubleReport.id

UPSet

  • id — INTEGER
  • title — STRING
  • desc — STRING(512)
  • useYN — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

UPSetDetail

  • id — INTEGER
  • fromDate — DATE
  • toDate — DATE
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • upSetId — STRING — Foreign key → UPTimeTable.id
  • upTimeTableId — STRING — Foreign key → UPTimeTable.id

UPTimeTable

  • id — INTEGER
  • desc — STRING(512)
  • useYN — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

UPTimeTableDetail

  • id — INTEGER
  • baseTime — TINYINT
  • price — SMALLINT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • upTimeTableId — STRING — Foreign key → UPTimeTable.id

UnitPrice

  • id — INTEGER.UNSIGNED
  • title — STRING(255)
  • applyDt — DATE
  • useYN — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • createdWho — BIGINT.UNSIGNED
  • updatedWho — BIGINT.UNSIGNED
  • t0 — INTEGER.UNSIGNED
  • t1 — INTEGER.UNSIGNED
  • t2 — INTEGER.UNSIGNED
  • t3 — INTEGER.UNSIGNED
  • t4 — INTEGER.UNSIGNED
  • t5 — INTEGER.UNSIGNED
  • t6 — INTEGER.UNSIGNED
  • t7 — INTEGER.UNSIGNED
  • t8 — INTEGER.UNSIGNED
  • t9 — INTEGER.UNSIGNED
  • t10 — INTEGER.UNSIGNED
  • t11 — INTEGER.UNSIGNED
  • t12 — INTEGER.UNSIGNED
  • t13 — INTEGER.UNSIGNED
  • t14 — INTEGER.UNSIGNED
  • t15 — INTEGER.UNSIGNED
  • t16 — INTEGER.UNSIGNED
  • t17 — INTEGER.UNSIGNED
  • t18 — INTEGER.UNSIGNED
  • t19 — INTEGER.UNSIGNED
  • t20 — INTEGER.UNSIGNED
  • t21 — INTEGER.UNSIGNED
  • t22 — INTEGER.UNSIGNED
  • t23 — INTEGER.UNSIGNED

UnitPriceSet

  • id — INTEGER
  • unitPriceSetName — STRING
  • unitPrice1 — INTEGER
  • unitPrice2 — INTEGER
  • unitPrice3 — INTEGER
  • unitPrice4 — INTEGER
  • unitPrice5 — INTEGER
  • unitPrice6 — INTEGER
  • unitPrice7 — INTEGER
  • unitPrice8 — INTEGER
  • unitPrice9 — INTEGER
  • unitPrice10 — INTEGER
  • unitPrice11 — INTEGER
  • unitPrice12 — INTEGER
  • unitPrice13 — INTEGER
  • unitPrice14 — INTEGER
  • unitPrice15 — INTEGER
  • unitPrice16 — INTEGER
  • unitPrice17 — INTEGER
  • unitPrice18 — INTEGER
  • unitPrice19 — INTEGER
  • unitPrice20 — INTEGER
  • unitPrice21 — INTEGER
  • unitPrice22 — INTEGER
  • unitPrice23 — INTEGER
  • unitPrice24 — INTEGER
  • registerDate — DATE
  • isUsed — BOOLEAN
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

UserLogs

  • id — INTEGER
  • status — ENUM
  • ipAddress — STRING(255)
  • failedLoginNumber — INTEGER
  • note — STRING(255)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • userId — STRING — Foreign key → UsersNew.id

UserOauth

  • id — UUID
  • oAuthId — STRING(256)
  • provider — ENUM
  • email — STRING(320)
  • profileImage — STRING(2048)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • usersNewId — STRING — Foreign key → UsersNew.id

UsersNew

  • id — BIGINT.UNSIGNED
  • id_old — STRING(36)
  • accountId — STRING(200)
  • dupinfo — STRING(240)
  • status — ENUM
  • type — ENUM
  • role — ENUM
  • gender — STRING(2)
  • birth — STRING(32)
  • saltRounds — STRING(320)
  • hashPassword — STRING(320)
  • md5Password — STRING(320)
  • isRequireResetPassword — BOOLEAN
  • isRequireCreateAccount — BOOLEAN
  • refreshToken — STRING(320)
  • dept — STRING(16)
  • nfcMembershipNo — STRING(32)
  • physicalCardNo — STRING(32)
  • isEmailVerified — BOOLEAN
  • pwdChgRequired — BOOLEAN
  • name — STRING(320)
  • phoneNo — STRING(36)
  • email — STRING(320)
  • subsDCPrice — SMALLINT(5)
  • deviceId — TEXT
  • userAgreements — JSON
  • haveUnpaid — BOOLEAN
  • address — STRING(255)
  • detailAddress — STRING(255)
  • zipCode — STRING(32)
  • currentAccessDateTime — DATE
  • profileImage — STRING(2048)
  • verifyEmailSendedAt — DATE
  • resetPasswordToken — STRING(255)
  • lastUsedMacAddr — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • orgId — STRING — Foreign key → Org.id
  • roleId — STRING — Foreign key → Role.id

Vehicle

  • id — INTEGER
  • isPrimary — BOOLEAN
  • manufacturer — STRING(16)
  • type — STRING(64)
  • subType — STRING(64)
  • year — STRING(32)
  • batteryCap — DECIMAL(6,1)
  • numberPlate — STRING(16)
  • macAddr — STRING
  • price — STRING(32)
  • usePnC — BOOLEAN
  • askPnCDate — DATE
  • mediaUrl — STRING(2048)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • userId — STRING — Foreign key → UsersNew.id
  • usersNewId — STRING — Foreign key → UsersNew.id

WebUserReg

  • id — UUID
  • accountId — STRING(320)
  • status — ENUM
  • name — STRING(64)
  • phoneNo — STRING(36)
  • role — ENUM
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • orgId — STRNG — Foreign key → Org.id

kicc_total_record

  • sales_date — INTEGER
  • record_type — STRING(30)
  • total_records — STRING(30)
  • total_page — STRING(30)
  • current_page — STRING(30)
  • transaction_count — STRING(30)
  • transaction_amount — STRING(30)
  • cancel_count — STRING(30)
  • cancel_amount — STRING(30)
  • total_count — STRING(30)
  • total_amount — STRING(30)
  • pg_commission — STRING(30)
  • extra_commission — STRING(30)
  • total_commission — STRING(30)
  • tax_amount — STRING(30)
  • adjust_amount — STRING(30)
  • total_kwh — STRING(30)

sap_oilstation_tb

  • id — int(11) — NOT NULL
  • stn_stn_seq — varchar(10) — NOT NULL
  • stn_stn_id — varchar(4) — NOT NULL — 사업장 ID
  • stn_val_end_ymd — varchar(8) — NOT NULL — 유효종료일지
  • stn_val_st_ymd — varchar(8) — NOT NULL — 유효시작일지
  • stn_stn_gubun — varchar(5) — NOT NULL — 사업장구분
  • stn_cust_no — varchar(7) — NOT NULL — 사업장고객번호
  • stn_stn_nm — varchar(40) — NOT NULL — 사업장명
  • stn_stn_short_nm — varchar(20) — NOT NULL — 사업장약명
  • stn_zip_cd — varchar(6) — NOT NULL — 우편번호
  • stn_addr — varchar(40) — NOT NULL — 주소
  • stn_dtl_addr — varchar(70) — NOT NULL — 상세주소
  • stn_tel_no — varchar(15) — NOT NULL — 전화번호
  • stn_fax_no — varchar(15) — NOT NULL — 팩스번호
  • stn_biz_no — varchar(10) — NOT NULL — 사업자등록번호
  • stn_boss_nm — varchar(40) — NOT NULL — 대표자명
  • stn_biz_kind_nm — varchar(30) — NOT NULL — 업종명
  • stn_line_nm — varchar(40) — NOT NULL — 종목명
  • stn_own_styl_gubun — varchar(5) — NOT NULL — 운영형태구분
  • stn_sales_st_ymd — varchar(8) — NOT NULL — 영업시작일자
  • stn_sales_end_ymd — varchar(8) — NOT NULL — 영업종료일자
  • stn_biz_aprv_ymd — varchar(8) — NOT NULL — 사업승인일자
  • stn_comp_gubun — varchar(5) — NOT NULL — 회사구분
  • stn_strg_cd — varchar(15) — NOT NULL — 저장소코드
  • stn_assgn_dept_cd — varchar(15) — NOT NULL — 소속부서코드
  • stn_assgn_area_gubun — varchar(5) — NOT NULL — 소속지역구분
  • stn_rep_trans_area_gubun — varchar(5) — NOT NULL — 대표수송지역구분
  • stn_rep_sales_ch_consti_id — varchar(10) — NOT NULL — 대표영업담당구성원ID
  • stn_cost_ct — varchar(10) — NOT NULL — 코스트센터
  • stn_pal_ct — varchar(10) — NOT NULL — 손익센터
  • stn_jnsn_gubun — varchar(5) — NOT NULL — 정산구분
  • stn_regant_id — varchar(10) — 등록자ID
  • stn_reg_date — date — 등록일시
  • stn_upder_id — varchar(10) — 수장자ID
  • stn_upd_date — date — 수정일시
  • stn_erp_if_gubun — varchar(5) — ERP 전송구분
  • stn_erp_if_date — date — ERP 전송일시
  • stn_updn_gubun — varchar(5) — ERP 전송일시
  • stn_updn_date — date — 송수신일시
  • stn_erp_if_emsg — varchar(220) — ERP전송오류메시지
  • stn_erp_stn_id — varchar(10) — NOT NULL — ERP사업장ID
  • stn_fos_if_yn — varchar(1) — NOT NULL — FOS 전송여부
  • stn_ipgm_bank_cd — varchar(15) — NOT NULL — 입금은행코드
  • stn_chld_acct_no — varchar(20) — NOT NULL — 자계좌번호
  • stn_hc_no — varchar(40) — 현대카드 가맹점번호
  • stn_carbt_sale_yn — varchar(1) — 자동차부탄판매여부
  • stn_cls_appl_hm — varchar(4) — 마감적용시간정보
  • stn_rep_trans_area_seq — varchar(20) — 대표수송지역일련번호
  • stn_cr_jsyb — varchar(4) — NOT NULL
  • stn_cr_date — varchar(15)

sb_charge_request

  • cr_id — BIGINT.UNSIGNED
  • request_type — ENUM
  • chg_id — BIGINT.UNSIGNED — Foreign key → sb_charger.chg_id
  • conn_id — SMALLINT.UNSIGNED
  • chargingLogId — BIGINT.UNSIGNED
  • pgCno — STRING(36)
  • card_id — BIGINT.UNSIGNED
  • request_kwh — INTEGER
  • request_percent — INTEGER
  • request_amt — INTEGER
  • actual_calculated_amt — INTEGER
  • refund_amt — INTEGER
  • dummy_pay_amt — INTEGER
  • paymentResponse — JSON
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • userId — STRING — Foreign key → UsersNew.id

sb_charger

  • chg_id — INTEGER(10)
  • chgs_id — INTEGER(10) — Foreign key → sb_charging_station.chgs_id
  • chg_channel — SMALLINT(5)
  • status — ENUM
  • isJam — CHAR(1)
  • chg_charger_id — STRING(50)
  • chg_alias — STRING(20)
  • mall_id — STRING(40) — Foreign key → PaymentNotification.memb_id
  • chg_sn — STRING(255)
  • chg_fw_ver — STRING(255)
  • chg_cell_number — STRING(45)
  • usePreset — CHAR(1)
  • upSetId — INTEGER(10) — Foreign key → UnitPriceSet.id
  • chg_unit_price — INTEGER(10)
  • chg_use_yn — CHAR(1)
  • qrTransDate — DATE
  • adTransDate — DATE
  • tmTransDate — DATE
  • charger_status — STRING(200)
  • fwTransDate — DATE
  • adVersion — STRING(32)
  • termsVersion — STRING(32) — Foreign key → FileToCharger.version
  • reservable — CHAR(1)
  • resetAt — TIMESTAMP
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • qrcode — STRING
  • deeplink — STRING
  • chargerModelId — INT — Foreign key → ChargerModel.id

sb_charger_ocpp_logs

  • col_id — INTEGER
  • division — ENUM
  • version — STRING(32)
  • fileURL — STRING(2048)
  • newestVersion — TINYINT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP
  • createdWho — BIGINT.UNSIGNED
  • updatedWho — BIGINT.UNSIGNED
  • chg_id — INT.UNSIGNED — Foreign key → UsersNew.id
  • file_id — INT — Foreign key → FileToCharger.id

sb_charger_state

  • cs_id — INTEGER(10)
  • cs_station_charger_id — STRING(50)
  • cs_channel — SMALLINT(6)
  • cs_charger_state — STRING(50)
  • cs_charging_state — STRING(50)
  • cs_se_code — STRING(50)
  • cs_sve_code — STRING(50)
  • cs_kwh — FLOAT
  • cs_kwh_cumulative — DOUBLE
  • cs_temperature — FLOAT
  • cs_vendor — STRING(100)
  • cs_model — STRING(200)
  • cs_firmware — STRING(50)
  • cs_created_datetime — DATE
  • cs_last_datetime — DATE
  • cs_addinfo1 — STRING
  • cs_addinfo2 — STRING
  • cs_addinfo3 — STRING
  • cs_event_code — INTEGER
  • cs_rssi — INTEGER
  • cs_last_ins — CHAR
  • cs_mdn — STRING
  • cs_cur_member — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • chg_id — STRING — Foreign key → sb_charger.chg_id

sb_charger_state_log

  • csl_id — INTEGER(10)
  • csl_station_charger_id — STRING(50)
  • csl_channel — SMALLINT(6)
  • csl_charger_state — STRING(50)
  • csl_charging_state — STRING(50)
  • csl_se_code — STRING(50)
  • csl_sve_code — STRING(50)
  • csl_kwh — FLOAT
  • csl_kwh_cumulative — DOUBLE
  • csl_direction — ENUM
  • csl_json — TEXT
  • cs_temperature — FLOAT
  • csl_vendor — STRING(100)
  • csl_model — STRING(200)
  • csl_firmware — STRING(50)
  • csl_created_datetime — DATE
  • csl_addinfo1 — STRING
  • csl_addinfo2 — STRING
  • csl_addinfo3 — STRING
  • csl_event_code — INTEGER
  • csl_rssi — INTEGER
  • csl_last_ins — CHAR
  • csl_mdn — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • chg_id — STRING — Foreign key → sb_charger.chgs_id

sb_charging_log

  • cl_id — BIGINT.UNSIGNED
  • cl_channel — SMALLINT.UNSIGNED
  • cl_order_user_no — STRING(100)
  • cl_order_mac_addr — STRING(50)
  • cl_transaction_id — STRING(50)
  • cl_start_datetime — DATE
  • cl_end_datetime — DATE
  • cl_unplug_datetime — DATE
  • cl_kwh — FLOAT
  • soc — INTEGER
  • remain — INTEGER
  • useType — ENUM
  • desired_kwh — FLOAT
  • desired_percent — INTEGER
  • appliedUnitPrice — SMALLINT(5)
  • cl_start_meter — FLOAT
  • cl_stop_meter — FLOAT
  • reason — STRING(50)
  • chargeFee — INTEGER
  • ignored_kwh — FLOAT
  • cl_datetime — DATE
  • pg_cno — STRING(50)
  • order_no — STRING(50)
  • approval_number — STRING(50)
  • payMethodDetail — STRING(32)
  • authAmtCharge — INTEGER(10)
  • authAmtPark — INTEGER(10)
  • authDate — DATE
  • receivePhoneNo — STRING(20)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • chgs_id — STRING — Foreign key → sb_charging_station.chgs_id
  • chg_id — STRING — Foreign key → sb_charger.chg_id
  • usersNewId — STRING — Foreign key → UsersNew.id

sb_charging_station

  • chgs_id — INTEGER(10)
  • chgs_station_id — STRING(50)
  • status — ENUM
  • chgs_name — STRING(255)
  • coordinate — GEOMETRY('POINT')
  • chrgStartTime — TIME
  • chrgEndTime — TIME
  • washStartTime — TIME
  • washEndTime — TIME
  • chgs_kepco_meter_no — STRING(50)
  • isUse — CHAR(1)
  • chgs_car_wash_yn — CHAR(1)
  • chgs_aff_only — JSON
  • chgs_field_desc — STRING(255)
  • area_code_id — STRING
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • orgId — STRING — Foreign key → Org.id
  • chgs_operator_manager_id — STRING — Foreign key → UsersNew.id

unnamed_table

  • id — BIGINT.UNSIGNED
  • level — STRING(20)
  • message — STRING(2048)
  • meta — STRING(2048)
  • timestamp — DATE