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