没有合适的资源?快使用搜索试试~ 我知道了~
首页电子商务支付平台数据库设计
电子商务支付平台数据库设计
4星 · 超过85%的资源 需积分: 49 166 下载量 11 浏览量
更新于2023-03-16
评论 3
收藏 2.31MB DOC 举报
2 基础平台核心数据库表结构(zmc) 10 2.1 账户 10 2.1.1 客户子账户表SubAccount 10 2.1.2 子账户冻结/注销流水SubAccount_Oper 10 2.1.3 客户子账户资金变动流水表SubAccountSeq 11 2.1.4 客户子账户资金冻结流水表SubAccountFreezeSeq 12 2.2 交易 13 2.2.1 充值交易流水RechargeBILL 13 2.2.2 提现交易流水WithDrawBILL 14
资源详情
资源评论
资源推荐
电子商务平台一期
数据库设计文档
版本号:1.00
二○一〇年十月
内部资料
注意保密
项目情况
项目编号
项目名称
项目经理
需求分析工程师
系统设计工程师
修改记录
版本号 发布日期 作者 评审人 变更的章节
目 录
1 前言................................................................................................................................................................9
1.1 命名规范.................................................................................................................................................9
1.2 说明.........................................................................................................................................................9
1.3 术语清单.................................................................................................................................................9
1.4 数据库表清单.......................................................................................................................................11
2 基础平台核心数据库表结构(zmc)............................................................................................................11
2.1 账户.......................................................................................................................................................11
2.1.1 客户子账户表 SubAccount...................................................................................................11
2.1.2 子账户冻结/注销流水 SubAccount_Oper...........................................................................12
2.1.3 客户子账户资金变动流水表 SubAccountSeq....................................................................13
2.1.4 客户子账户资金冻结流水表 SubAccountFreezeSeq..........................................................14
2.2 交易.......................................................................................................................................................15
2.2.1 充值交易流水 RechargeBILL..............................................................................................15
2.2.2 提现交易流水 WithDrawBILL.............................................................................................16
2.2.3 支付交易流水 PayBILL........................................................................................................17
2.2.4 批量代收付交易信息表(BatchInfo)...............................................................................22
2.2.5 撤销交易流水 UndoPayBILL...............................................................................................23
2.2.6 退款交易流水 RefundBill.....................................................................................................25
2.2.7 汇款交易流水 WaitingRechargeBILL..................................................................................26
2.2.8 内部调账交易流水 AdjustBiLL...........................................................................................27
2.2.9 外部系统交易通知 SHOP_NOTIFY...................................................................................28
2.3 会计帐务...............................................................................................................................................29
2.3.1 科目日记账表(SUBJECT_DAY).........................................................................................29
2.3.2 试算平衡表(Balance_Check)..........................................................................................29
2.3.3 科目类型表(SUBJECTTYPE)..............................................................................................30
2.3.4 凭证类型表(PZTYPE)..........................................................................................................30
2.3.5 凭证科目对应表(PZSUBJECT)...........................................................................................30
2.3.6 科目明细表(SUBJECT)........................................................................................................31
2.3.7 凭证明细表(PZ)....................................................................................................................31
2.4 系统参数...............................................................................................................................................32
2.4.1 序列........................................................................................................................................32
2.5 渠道.......................................................................................................................................................32
2.5.1 渠道清算指令(Channel_Settle_Cmd).............................................................................32
2.5.2 渠道参数(Channel_Parm)...............................................................................................33
2.5.3 渠道返回码对照表(Channel_RtnCode).........................................................................33
2.5.4 渠道交易流水对照表(BILLNo_SN)....................................................................................34
2.5.5 批量交易渠道批次表(Channel_Batch)................................................................................35
2.5.6 系统日志(Channel_Sys_Log)...............................................................................................36
2.5.7 渠道对帐表(Channel_Check)..............................................................................................37
2.5.8 渠道对帐不平明细表(Channel_CheckDetail).....................................................................38
2.5.9 同城超时等待表(TC_OVERTIME_WAIT).........................................................................40
2.5.10 同城批量撤销表(TC_BATCHCANCEL)..........................................................................40
2.5.11 同城费项代码对应表(CHANNEL_FEECODE_CHG).....................................................41
2.5.12 同城对帐指令表(TC_CHECK_CMD)...............................................................................41
2.5.13 同城对账表(TC_CHECK)..................................................................................................42
2.5.14 同城对账明细表(TC_CHECK_DETAIL)..........................................................................42
2.5.15 明细下载回应表(CHECK_DOWN)..................................................................................43
2.5.16 明细下载回应清单(CHECK_DOWN_DETAIL)..............................................................43
3 系统管理数据库表结构.............................................................................................................................45
3.1 系统维护...............................................................................................................................................45
3.1.1 服务监控主表(MONITORAPPGROUP ).......................................................................45
3.1.2 服务监控明细表(MONITORAPPDETAIL)...................................................................46
3.1.3 系统日志(Sys_Log)..............................................................................................................46
3.1.4 平台功能描述表(PlatForm_Fun)....................................................................................47
3.1.5 管理平台操作日志(Operate_Log).......................................................................................47
3.1.6 通知公告栏(Public_Bulletin)...............................................................................................48
3.1.7 服务产品管理(Service_Product)..........................................................................................48
3.1.8 黑白名单表(BW_List)..........................................................................................................49
3.2 权限.......................................................................................................................................................49
3.2.1 登陆用户基本信息表(LOGIN_INFO).................................................................................49
3.2.2 角色信息表(ROLE_INFO).............................................................................................50
3.2.3 登陆用户角色表(LOGIN_ROLE)..................................................................................51
3.2.4 角色权限表(ROLE_PRIVILEGE)..................................................................................51
3.2.5 权限信息表(PRIVILEGE)...............................................................................................51
3.2.6 权限资源表(PRIVILEGE_RESOURCE).......................................................................52
3.3 权限组...................................................................................................................................................53
3.3.1 权限组信息(LIMITGROUP)..........................................................................................53
3.3.2 权限分组表(LIMIT_GROUP_PRIVILEGE)..................................................................53
3.4 账户.......................................................................................................................................................54
3.4.1 快付通结算账户余额表(BankAccount_Balance)...............................................................54
3.4.2 子账户类型表(SUBACCOUNT_TYPE).............................................................................54
3.4.3 子账户互转控制表(SUBACCOUNT_TRANSCTRL)........................................................55
3.4.4 客户已验证银行账户表 CustBankCard(管理平台)......................................................55
3.4.5 客户子账户与银行账户绑定表(SubAccountBindCard).....................................................55
3.4.6 账户与银行帐户绑定流水表 kftbindact_bill(管理平台)..............................................56
3.4.7 账户验证流水 AccountVerifyBILL(kftjc)......................................................................56
3.4.8 代付业务绑定的收款账户 (PAY_BINDBANKACOUNT)................................................58
3.5 客户信息...............................................................................................................................................58
3.5.1 客户信息表(CUST_INFO)(管理平台)...........................................................................58
Cust_Id:规则。可以是序号+1 是个人客户;序号+2 是企业客户(商户)。可以从 100 开始。.....60
3.5.2 登录证书表(LOGIN_CERTIFICATE)............................................................................60
3.5.3 客户证件扫描件表(CustCert_Scan)...............................................................................60
3.5.4 商户信息管理 (管理员维护)(Merchant_Info)...............................................................61
3.5.5 客户级别管理(CUST_LEVEL)......................................................................................61
3.5.6 客户开通业务列表(Cust_ServiceList).................................................................................62
3.5.7 商户开通业务列表(Merchant_SERVICE_List).............................................................62
3.5.8 客户订阅通知表(Cust_AlarmType).....................................................................................62
3.5.9 客户投诉建议(CUST_SERVICE)........................................................................................63
3.5.10 登记注册类型(Register_Type)......................................................................................63
3.5.11 行业分类(Industry_Type)..............................................................................................63
3.6 协议.......................................................................................................................................................64
3.6.1 协议范本(PROTOCOL_TEXT)...........................................................................................64
3.6.2 协议类型表(PROTOCOL_TYPE).......................................................................................64
3.6.3 客户银行代收协议(CKB_Protocol)...............................................................................64
3.6.4 快付通商户与平台外客户三方代收协议(NotKft_PROTOCOL)(走无协议代扣渠
道)..................................................................................................................................................65
3.6.5 快付通商户与平台内客户三方代收协议(Kft_PROTOCOL)......................................66
3.6.6 商户代理关系表(Merchant_ProxyRelation)........................................................................67
3.6.7 客户计费信息表(Cust_Fee_Rule)........................................................................................67
3.6.8 企业代收付协议(PROTOCOL_PARTYPAYEE).................................................................67
3.6.9 汇款充值协议(PROTOCOL_REMIT).................................................................................68
3.6.10 卡通协议(PROTOCOL_KFTCARD)...........................................................................68
3.7 业务参数...............................................................................................................................................69
3.7.1 费用代码表(Fee_Code)........................................................................................................69
3.7.2 银行类型表(BANK_TYPE_INFO)......................................................................................69
3.7.3 城市代码表(City_Code).......................................................................................................70
3.7.4 行名行号表(Bank_Code)......................................................................................................70
3.7.5 银行开通业务表(Bank_Service)(门户展示给客户用)..................................................70
3.8 系统参数...............................................................................................................................................71
3.8.1 结算帐号配置表...................................................................................................................71
3.8.2 运行参数(RunParm)..............................................................................................................71
3.8.3 系统参数(SYSPARM).....................................................................................................72
3.8.4 定时计划定义表(TASKDEFINE)...................................................................................73
3.8.5 定时计划执行表(TASKLIST).........................................................................................74
3.8.6 后台定时服务表(TimerAppServer)................................................................................74
3.8.7 客户通知消息(Cust_AlarmMessage).............................................................................75
3.8.8 命令定义表 CMD_DEFINE.................................................................................................76
3.9 手续费管理...........................................................................................................................................76
3.9.1 商户服务种类表(收费标准接口)(Cust_Service_Type).................................................76
3.9.2 提现计费规则(DrawMoney_Rule).................................................................................76
3.9.3 计费方法(FEE_METHOD).............................................................................................77
3.9.4 计费方法明细(FEE_METHOD_DETAIL).....................................................................78
3.9.5 定期手续费表(Regular_ServiceFee)....................................................................................78
3.9.6 客户支付交易计分规则表(Cust_PointCalcRule)..........................................................79
3.10 限额管理.............................................................................................................................................80
3.10.1 客户使用额度控制表(Cust_UseAmountCtl).....................................................................80
3.10.2 交易额度(DEAL_AMOUNTCTRL).............................................................................80
剩余63页未读,继续阅读
luozhai717
- 粉丝: 1
- 资源: 5
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 2022年中国足球球迷营销价值报告.pdf
- 房地产培训 -营销总每天在干嘛.pptx
- 黄色简约实用介绍_汇报PPT模板.pptx
- 嵌入式系统原理及应用:第三章 ARM编程简介_3.pdf
- 多媒体应用系统.pptx
- 黄灰配色简约设计精美大气商务汇报PPT模板.pptx
- 用matlab绘制差分方程Z变换-反变换-zplane-residuez-tf2zp-zp2tf-tf2sos-sos2tf-幅相频谱等等.docx
- 网络营销策略-网络营销团队的建立.docx
- 电子商务示范企业申请报告.doc
- 淡雅灰低面风背景完整框架创业商业计划书PPT模板.pptx
- 计算模型与算法技术:10-Iterative Improvement.ppt
- 计算模型与算法技术:9-Greedy Technique.ppt
- 计算模型与算法技术:6-Transform-and-Conquer.ppt
- 云服务安全风险分析研究.pdf
- 软件工程笔记(完整版).doc
- 电子商务网项目实例规划书.doc
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论3