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