lyfz_repos/经典版源码/document/数据库表脚本/todaytake.sql

USE [db]
GO
/****** 
对象:  预约表(摄控本) Table [dbo].[todaytake]    
脚本日期: 02/27/2015 11:45:57 
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[todaytake](
	[name] [varchar](50) NULL,				--顾客姓名;
	[phone] [varchar](50) NULL,				--顾客手机;
	[date] [varchar](50) NULL,				--预约日期;
	[time] [varchar](50) NULL,				--预约时间;
	[type] [varchar](50) NULL,				--预约类型;
	[price] [varchar](50) NULL,				--价格???;
	[waiter1] [varchar](50) NULL,			--预约服务员1
	[waiter2] [varchar](50) NULL,			--预约服务员2
	[receptionist] [varchar](50) NULL,		--接待员(门市?);
	[arrearage] [varchar](50) NULL,			--欠款;
	[clerk] [varchar](50) NULL,				--店员(谁记录)
	[remark] [varchar](max) NULL,			--注意事项;
	[timestamp] [varchar](50) NULL,			--时间戳;
	[content] [varchar](50) NULL,			--内容;
	[mode] [varchar](50) NULL,				--模式;
	[arrive] [varchar](50) NULL,			--是否到店(未到、已到);
	[id] [varchar](50) NULL					--预约id;
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF