lyfz_repos/经典版源码/document/数据库表脚本/merberreg会员积分消费记录.sql

USE [2013]
GO

/****** Object:  Table [dbo].[memberreg]    Script Date: 2015/1/26 10:31:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[memberreg](
	[memberno] [nvarchar](50) NULL,			/* 会员卡号 */
	[dindanid] [nvarchar](50) NULL,			/* 描述消费项目??命名造成歧义 */
	[money] [nvarchar](50) NULL,			/* 积分消费 */
	[date] [nvarchar](50) NULL,				/* 消费日期 */
	[id] [int] IDENTITY(1,1) NOT NULL,		/* 自增列 */
	[card2no] [nvarchar](50) NULL,			/* ??? */
	[type] [nvarchar](50) NULL,				/* 记录类型?? */
	[taoxi] [nvarchar](50) NULL,			/* ??? */
	[date2] [nvarchar](50) NULL				/* ??? */
) ON [PRIMARY]

GO