表名：ZL_PayPlat












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1PayPlatIDint40是是 否 支付平台ID
2UIDint40   否 支付平台UID
3PayClassint40   是 平台分类
4PayPlatNamenvarchar2550   否 支付平台名
5AccountIDnvarchar2550   是 支付平台商户ID
6MD5Keynvarchar2550   是 支付平台商户安全校验码
7SellerEmailnvarchar2550   是 卖家Email如支付宝需要的卖家Email
8IsDisabledbit10   是 是否禁用
9IsDefaultbit10   是 是否默认支付平台
10Ratefloat80   是 手续费
11OrderIDint40   是 排序ID
12payTypenvarchar500   是 支付卡类型 zfk ，a等
13leadtoGroupnvarchar5000   是 这个通道属于的用户组，各个用户组表示：‘，***，’
14PayPlatinfonvarchar10000   是 备注
15PrivateKeynvarchar2000   是 支付平台私钥或证书路径
16PublicKeynvarchar2000   是 支付平台公钥或证书路径
17Othernvarchar30000   是 支付平台备溢于言表信息
18PrivateKey_Pwdnvarchar2000   是 私钥密钥
19Secretnvarchar5000   是 支付平台Secret
20Remindnvarchar5000   是  

简要说明：

在线支付表

GO


CREATE TABLE [dbo].[ZL_PayPlat](
[PayPlatID] [int] IDENTITY(1,1) NOT NULL,
[UID] [int] NOT NULL,
[PayClass] [int] NULL,
[PayPlatName] [nvarchar](255) NOT NULL,
[AccountID] [nvarchar](255) NULL,
[MD5Key] [nvarchar](255) NULL,
[SellerEmail] [nvarchar](255) NULL,
[IsDisabled] [bit] NULL,
[IsDefault] [bit] NULL,
[Rate] [float] NULL,
[OrderID] [int] NULL,
[payType] [nvarchar](50) NULL,
[leadtoGroup] [nvarchar](500) NULL,
[PayPlatinfo] [nvarchar](1000) NULL,
[PrivateKey] [nvarchar](200) NULL,
[PublicKey] [nvarchar](200) NULL,
[Other] [nvarchar](3000) NULL,
[PrivateKey_Pwd] [nvarchar](200) NULL,
[Secret] [nvarchar](500) NULL,
[Remind] [nvarchar](500) NULL,
CONSTRAINT [PK_ZL_PayPlat] PRIMARY KEY CLUSTERED
([PayPlatID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [ZL_PayPlat] ON
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 1,0,99,N'线下支付',N'offline',N'offline',0,0,0,1)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 2,0,12,N'支付宝[即时到账]',N'',N'',1,0,0,2)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 3,0,13,N'支付宝[手机网页支付]',N'',N'',1,0,0,3)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 4,0,15,N'支付宝[网银]',N'',N'',1,0,0,4)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 5,0,21,N'微信支付',N'微信支付',N'微信支付',1,0,0,5)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 6,0,3,N'银联',N'',N'',1,0,0,6)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 7,0,9,N'中国银联',N'',N'',1,0,0,7)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 8,0,2,N'快钱',N'',N'',1,0,0,8)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 9,0,26,N'工行支付',N'',N'',1,0,0,9)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 10,0,23,N'南昌工商银行',N'',N'',1,0,0,10)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 11,0,25,N'贝付通',N'',N'',1,0,0,11)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 12,0,27,N'汇潮支付',N'',N'',1,0,0,12)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 13,0,17,N'PayPal',N'',N'',1,0,0,13)
INSERT [ZL_PayPlat] ([PayPlatID],[UID],[PayClass],[PayPlatName],[AccountID],[MD5Key],[IsDisabled],[IsDefault],[Rate],[OrderID]) VALUES ( 14,0,100,N'货到付款',N'',N'',1,0,0,14)
SET IDENTITY_INSERT [ZL_PayPlat] OFF

--注意：将清空全表数据

detele from ZL_PayPlat

--注意：将删除整个表

drop table ZL_PayPlat

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_PayPlat