表名：ZL_Shop_FareTlp












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2TlpNamenvarchar2000   是 运费模板名称
3IsFreeint40   是 是否包邮
4PriceModeint40   是 计费模式
5RegionBanint40   是 开启区域限制
6Expressnvarchar30000   是 费用Json
7EMSnvarchar30000   是 EMS计价JSON
8Mailnvarchar30000   是 平邮计价JSON
9AdminIDint40   是 管理员ID
10CDatedatetime83   是 添加时间
11Remindnvarchar5000   是 备注,买家可见
12Remind2nvarchar5000   是 备注,仅卖家可见
13UserIDint40   是 用户ID

简要说明：

运费模板表

GO
CREATE TABLE [dbo].[ZL_Shop_FareTlp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[TlpName] [nvarchar](200) NULL,
[IsFree] [int] NULL,
[PriceMode] [int] NULL,
[RegionBan] [int] NULL,
[Express] [nvarchar](3000) NULL,
[EMS] [nvarchar](3000) NULL,
[Mail] [nvarchar](3000) NULL,
[AdminID] [int] NULL,
[CDate] [datetime] NULL,
[Remind] [nvarchar](500) NULL,
[Remind2] [nvarchar](500) NULL,
[UserID] [int] NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [ZL_Shop_FareTlp] ON
INSERT [ZL_Shop_FareTlp] ([ID],[TlpName],[IsFree],[PriceMode],[RegionBan],[Express],[AdminID],[CDate],[UserID]) VALUES ( 1,N'默认预设',0,1,0,N'[{"name":"快递","mode":"1","enabled":true,"price":"10","plus":"1","free_sel":"1","free_num":"5","free_money":""},{"name":"EMS","mode":"1","enabled":true,"price":"10","plus":"2","free_sel":"2","free_num":"","free_money":"100"},{"name":"平邮","mode":"1","enabled":true,"price":"5","plus":"1","free_sel":"0","free_num":"","free_money":""}]',0,N'2015/4/9 21:59:28',0)
SET IDENTITY_INSERT [ZL_Shop_FareTlp] OFF

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

detele from ZL_Shop_FareTlp

--注意：将删除整个表

drop table ZL_Shop_FareTlp

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

TRUNCATE table ZL_Shop_FareTlp