表名：ZL_Stock












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2stocktypeint40   是 出库|入库
3danjuvarchar5000   是 单据号
4pronamevarchar5000   是 商品名
5addtimedatetime83   是 添加时间
6adduservarchar500   是 添加用户
7contentntext160   是 详情备注
8proidint40   是 商品ID
9pronumint40   是 商品数量
10UserIDint40   是  
11AdminIDint40   是  
12StoreIDint40   是 店铺ID

简要说明：

库存信息表

GO
CREATE TABLE [dbo].[ZL_Stock](
[ID] [int] IDENTITY(1,1) NOT NULL,
[stocktype] [int] NULL,
[danju] [varchar](500) NULL,
[proname] [varchar](500) NULL,
[addtime] [datetime] NULL,
[adduser] [varchar](50) NULL,
[content] [ntext] NULL,
[proid] [int] NULL,
[pronum] [int] NULL,
[UserID] [int] NULL,
[AdminID] [int] NULL,
[StoreID] [int] NULL,
CONSTRAINT [PK_ZL_Stock] 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] TEXTIMAGE_ON [PRIMARY]

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

detele from ZL_Stock

--注意：将删除整个表

drop table ZL_Stock

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

TRUNCATE table ZL_Stock