序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | ID | int | 4 | 0 | 是 | 是 | 否 | |||
2 | ProID | int | 4 | 0 | 是 | 绑定商品ID | ||||
3 | W_StartNum | int | 4 | 0 | 是 | 促销条件 | ||||
4 | P_ID | int | 4 | 0 | 是 | 促销商品ID | ||||
5 | P_Num | int | 4 | 0 | 是 | 促销数量条件 | ||||
6 | P_Name | nvarchar | 100 | 0 | 是 | 促销商品名称 | ||||
7 | P_Price | money | 8 | 4 | 是 | 促销商品价格 | ||||
8 | W_Type | int | 4 | 0 | 是 | 促销类型 | ||||
9 | Name | nvarchar | 100 | 0 | 是 | 促销名称 |
商品促销记录
GO
CREATE TABLE [dbo].[ZL_Shop_Present](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](100) NULL,
[ProID] [int] NULL,
[W_StartNum] [int] NULL,
[P_ID] [int] NULL,
[P_Num] [int] NULL,
[P_Name] [nvarchar](100) NULL,
[P_Price] [money] NULL,
[W_Type] [int] NULL,
CONSTRAINT [PK_ZL_Shop_Present] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
detele from ZL_Shop_Present
drop table ZL_Shop_Present
TRUNCATE table ZL_Shop_Present