USE [master]
GO
/****** Object:  Database [housekeeping]    Script Date: 2015/11/30 20:14:50 ******/
CREATE DATABASE [housekeeping]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'housekeeping', FILENAME = N'D:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\housekeeping.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'housekeeping_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\housekeeping_log.ldf' , SIZE = 3136KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [housekeeping] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [housekeeping].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [housekeeping] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [housekeeping] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [housekeeping] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [housekeeping] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [housekeeping] SET ARITHABORT OFF 
GO
ALTER DATABASE [housekeeping] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [housekeeping] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [housekeeping] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [housekeeping] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [housekeeping] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [housekeeping] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [housekeeping] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [housekeeping] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [housekeeping] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [housekeeping] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [housekeeping] SET  DISABLE_BROKER 
GO
ALTER DATABASE [housekeeping] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [housekeeping] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [housekeeping] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [housekeeping] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [housekeeping] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [housekeeping] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [housekeeping] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [housekeeping] SET RECOVERY FULL 
GO
ALTER DATABASE [housekeeping] SET  MULTI_USER 
GO
ALTER DATABASE [housekeeping] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [housekeeping] SET DB_CHAINING OFF 
GO
ALTER DATABASE [housekeeping] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [housekeeping] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'housekeeping', N'ON'
GO
USE [housekeeping]
GO
/****** Object:  Table [dbo].[AUTHORMODULES]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AUTHORMODULES](
	[AUTHOR_ID] [int] IDENTITY(1,1) NOT NULL,
	[MASTER_ID] [int] NULL,
	[MODULE_ID] [int] NULL,
	[CT] [datetime] NULL,
	[CU_ID] [int] NULL,
	[R_ADD] [bit] NOT NULL,
	[R_DELETE] [bit] NOT NULL,
	[R_UPDATE] [bit] NOT NULL,
	[R_QUERY] [bit] NOT NULL,
 CONSTRAINT [PK_AUTHORMODULES] PRIMARY KEY NONCLUSTERED 
(
	[AUTHOR_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]

GO
/****** Object:  Table [dbo].[CASH_LOG]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CASH_LOG](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[USERID] [int] NULL,
	[TYPE] [int] NOT NULL,
	[COUNT] [decimal](18, 0) NOT NULL,
	[OP_TIME] [datetime] NOT NULL,
 CONSTRAINT [PK_CASH_LOG] PRIMARY KEY NONCLUSTERED 
(
	[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]

GO
/****** Object:  Table [dbo].[CHECKCODERECORD]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CHECKCODERECORD](
	[CHECKCODEID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[PHONENO] [varchar](20) NOT NULL,
	[CHECKCODE] [varchar](6) NOT NULL,
	[CREATETIME] [datetime] NOT NULL,
	[ISCHECKED] [varchar](10) NOT NULL,
 CONSTRAINT [PK_CHECKCODERECORD] PRIMARY KEY CLUSTERED 
(
	[CHECKCODEID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CITY]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CITY](
	[CITYID] [int] IDENTITY(1,1) NOT NULL,
	[PROVINCEID] [int] NULL,
	[CITYNAME] [varchar](50) NULL,
	[CT] [datetime] NULL,
	[ISOPEN] [bit] NOT NULL,
 CONSTRAINT [PK_CITY] PRIMARY KEY NONCLUSTERED 
(
	[CITYID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[COMMISION_RULE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COMMISION_RULE](
	[RULE_ID] [int] IDENTITY(1,1) NOT NULL,
	[CITYID] [int] NULL,
	[RULE_NAME] [varchar](50) NULL,
	[CT] [datetime] NULL,
	[CU_ID] [int] NULL,
	[ISOPEN] [bit] NULL,
	[DEFAULT_RATE] [decimal](18, 0) NULL,
 CONSTRAINT [PK_COMMISION_RULE] PRIMARY KEY NONCLUSTERED 
(
	[RULE_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[COMMISION_RULE_ITEM]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COMMISION_RULE_ITEM](
	[RULE_ITEM_ID] [int] IDENTITY(1,1) NOT NULL,
	[SERVICEID] [int] NULL,
	[RULE_ID] [int] NULL,
	[RULE_RATE] [decimal](18, 0) NULL,
	[CT] [datetime] NULL,
	[UPDATE_TIME] [datetime] NULL,
	[US_ID] [binary](10) NULL,
	[CU_ID] [binary](10) NULL,
 CONSTRAINT [PK_COMMISION_RULE_ITEM] PRIMARY KEY NONCLUSTERED 
(
	[RULE_ITEM_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[COMPANY_CHILD]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COMPANY_CHILD](
	[CHILD_ID] [int] IDENTITY(1,1) NOT NULL,
	[CITYID] [int] NULL,
	[CHILD_NAME] [binary](100) NOT NULL,
	[CHILD_MANAGER] [int] NOT NULL,
 CONSTRAINT [PK_COMPANY_CHILD] PRIMARY KEY NONCLUSTERED 
(
	[CHILD_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[COMPANY_DETAIL_ITEM]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COMPANY_DETAIL_ITEM](
	[ITEM_ID] [int] IDENTITY(1,1) NOT NULL,
	[CHILD_ID] [int] NULL,
	[DETAIL_CODE] [varchar](10) NULL,
	[CODE] [varchar](50) NULL,
	[DETAIL] [varchar](200) NULL,
 CONSTRAINT [PK_COMPANY_DETAIL_ITEM] PRIMARY KEY NONCLUSTERED 
(
	[ITEM_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[COUPON_INFO]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COUPON_INFO](
	[COUPON_ID] [int] IDENTITY(1,1) NOT NULL,
	[CITY_SERVICE_ID] [int] NULL,
	[COUPON_NAME] [varchar](100) NOT NULL,
	[SUMMARY] [binary](200) NULL,
	[PIC] [binary](200) NULL,
	[PROVISION] [text] NULL,
	[DOWNLOADS] [int] NOT NULL,
	[DOWNLOAD_FLAG] [bit] NOT NULL,
	[START_TIME] [datetime] NOT NULL,
	[END_TIME] [datetime] NOT NULL,
	[SUBMIT_TIME] [datetime] NOT NULL,
	[ISSUE_TIME] [datetime] NULL,
 CONSTRAINT [PK_COUPON_INFO] PRIMARY KEY NONCLUSTERED 
(
	[COUPON_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[COUPON_RECORD]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COUPON_RECORD](
	[RECORD_ID] [int] IDENTITY(1,1) NOT NULL,
	[COUPON_ID] [int] NULL,
	[USERID] [int] NULL,
	[CITY_SERVICE_ID] [int] NULL,
	[PHONE] [varchar](20) NOT NULL,
	[DOWNLOAD_TIME] [datetime] NOT NULL,
	[ISUSED] [bit] NOT NULL,
	[USETIME] [datetime] NULL,
	[CHANNEL] [smallint] NULL,
	[START_TIME] [datetime] NOT NULL,
	[END_TIME] [datetime] NOT NULL,
 CONSTRAINT [PK_COUPON_RECORD] PRIMARY KEY NONCLUSTERED 
(
	[RECORD_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DETAIL_ITEM]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DETAIL_ITEM](
	[DETAIL_CODE] [varchar](10) NOT NULL,
	[DETAIL_NAME] [varchar](100) NOT NULL,
 CONSTRAINT [PK_DETAIL_ITEM] PRIMARY KEY NONCLUSTERED 
(
	[DETAIL_CODE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[EXTRA_DEMAND]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EXTRA_DEMAND](
	[EXTRA_ID] [int] IDENTITY(1,1) NOT NULL,
	[ORDERID] [int] NULL,
	[SPECIAL_ID] [int] NULL,
	[REMARK] [varchar](200) NULL,
 CONSTRAINT [PK_EXTRA_DEMAND] PRIMARY KEY NONCLUSTERED 
(
	[EXTRA_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[FEEDBACK]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FEEDBACK](
	[FEEDBACK_ID] [int] IDENTITY(1,1) NOT NULL,
	[CONTENT] [varchar](500) NULL,
	[STAFFID] [int] NULL,
	[USERID] [int] NULL,
 CONSTRAINT [PK_FEEDBACK] PRIMARY KEY NONCLUSTERED 
(
	[FEEDBACK_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MASTERS]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MASTERS](
	[MASTER_ID] [int] IDENTITY(1,1) NOT NULL,
	[PASSWORD] [varchar](20) NULL,
	[MASTER_NAME] [varchar](20) NULL,
	[PHONE] [varchar](20) NULL,
	[EMAIL] [varchar](50) NULL,
 CONSTRAINT [PK_MASTERS] PRIMARY KEY NONCLUSTERED 
(
	[MASTER_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MEMBERSHIP_PACKAGE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MEMBERSHIP_PACKAGE](
	[MEM_PACK_ID] [int] IDENTITY(1,1) NOT NULL,
	[PACK_NAME] [varchar](50) NULL,
	[CT] [datetime] NULL,
	[ISOPEN] [bit] NULL,
	[CU_ID] [int] NULL,
	[PACK_TYPE_ID] [int] NULL,
	[REMARK] [varchar](50) NULL,
 CONSTRAINT [PK_MEMBERSHIP_PACKAGE] PRIMARY KEY NONCLUSTERED 
(
	[MEM_PACK_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MODULES]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MODULES](
	[MODULE_ID] [int] NOT NULL,
	[MODULE_NAME] [varchar](20) NULL,
	[MODULE_URL] [varchar](20) NULL,
 CONSTRAINT [PK_MODULES] PRIMARY KEY NONCLUSTERED 
(
	[MODULE_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[OPERATION_LOG]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OPERATION_LOG](
	[LOG_ID] [int] IDENTITY(1,1) NOT NULL,
	[TYPE] [varchar](10) NULL,
	[CONTENT] [varchar](500) NULL,
	[CT] [datetime] NULL,
	[APPID] [varchar](10) NULL,
	[IP] [varchar](20) NULL,
	[LOGTITLE] [varchar](50) NULL,
 CONSTRAINT [PK_OPERATION_LOG] PRIMARY KEY NONCLUSTERED 
(
	[LOG_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ORDER_ITEM]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ORDER_ITEM](
	[ORDER_DETAIL_ID] [int] IDENTITY(1,1) NOT NULL,
	[ORDERID] [int] NULL,
	[RATEPLAN_ID] [int] NULL,
	[CT] [datetime] NULL,
	[QUANTITY] [int] NULL,
 CONSTRAINT [PK_ORDER_ITEM] PRIMARY KEY NONCLUSTERED 
(
	[ORDER_DETAIL_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]

GO
/****** Object:  Table [dbo].[ORDERS]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ORDERS](
	[ORDERID] [int] IDENTITY(1,1) NOT NULL,
	[STAFFID] [int] NULL,
	[USERID] [int] NULL,
	[CT] [datetime] NULL,
	[BEGINTIME] [datetime] NULL,
	[ENDTIME] [datetime] NULL,
	[STATUS] [varchar](1) NULL,
	[ISREJECT] [bit] NULL,
	[REJECT_TYPE] [binary](1) NULL,
	[REJECT_DETAIL] [varchar](50) NULL,
	[STARRATE] [varchar](1) NULL,
	[USERCOMMENT] [binary](50) NULL,
	[REMARK] [varchar](500) NULL,
	[PAY_TYPE] [varchar](10) NULL,
	[ISCASHPAYED] [bit] NULL,
	[ALLCOUNT] [float] NULL,
	[ORDERCOST] [float] NULL,
	[ORDERINCOME] [float] NULL,
	[SERVICE_LOCATION] [varchar](100) NOT NULL,
	[SERVICE_POS] [varchar](100) NULL,
	[ACTUAL_START_TIME] [datetime] NULL,
	[ACTUAL_END_TIME] [datetime] NULL,
	[ISGIVENTIP] [bit] NULL,
	[AMOUNT_TIP] [decimal](18, 0) NULL,
 CONSTRAINT [PK_ORDERS] PRIMARY KEY NONCLUSTERED 
(
	[ORDERID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PACK_TYPE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PACK_TYPE](
	[PACK_TYPE_ID] [int] IDENTITY(1,1) NOT NULL,
	[PACK_TYPE_NAME] [varchar](20) NULL,
	[PACK_TYPE_CODE] [varchar](20) NULL,
 CONSTRAINT [PK_PACK_TYPE] PRIMARY KEY NONCLUSTERED 
(
	[PACK_TYPE_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PROVICE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PROVICE](
	[PROVINCEID] [int] IDENTITY(1,1) NOT NULL,
	[PROVINCENAME] [varchar](50) NULL,
	[CT] [datetime] NULL,
 CONSTRAINT [PK_PROVICE] PRIMARY KEY NONCLUSTERED 
(
	[PROVINCEID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PROVINCE_BASIC_SERVICE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PROVINCE_BASIC_SERVICE](
	[CITY_SERVICE_ID] [int] IDENTITY(1,1) NOT NULL,
	[SERVICE_ITEM_ID] [int] NULL,
	[CITYID] [int] NULL,
	[ISOPEN] [bit] NULL,
	[CT] [datetime] NULL,
	[SERVICECOST] [decimal](18, 0) NOT NULL,
	[CUID] [int] NULL,
 CONSTRAINT [PK_PROVINCE_BASIC_SERVICE] PRIMARY KEY NONCLUSTERED 
(
	[CITY_SERVICE_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]

GO
/****** Object:  Table [dbo].[RATEPLAN]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RATEPLAN](
	[RATEPLAN_ID] [int] IDENTITY(1,1) NOT NULL,
	[CITY_SERVICE_ID] [int] NULL,
	[RATEPLAN_NAME] [varchar](50) NOT NULL,
	[COST] [decimal](18, 0) NOT NULL,
	[单位名称] [varchar](50) NULL,
 CONSTRAINT [PK_RATEPLAN] PRIMARY KEY NONCLUSTERED 
(
	[RATEPLAN_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[REALMESSAGE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[REALMESSAGE](
	[MESSAGE_ID] [int] IDENTITY(1,1) NOT NULL,
	[CONTENT] [varchar](500) NULL,
	[ISSUCESS] [bit] NULL,
	[RETRY_COUNT] [int] NULL,
	[CT] [datetime] NULL,
	[ISOUTDATE] [bit] NULL,
 CONSTRAINT [PK_REALMESSAGE] PRIMARY KEY NONCLUSTERED 
(
	[MESSAGE_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[REBACK_ITEM]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[REBACK_ITEM](
	[REBACK_ITEM_ID] [int] IDENTITY(1,1) NOT NULL,
	[RECHARGE_ID] [int] NULL,
	[CITY_SERVICE_ID] [int] NULL,
	[COUNT] [int] NULL,
	[QUANTITY] [int] NOT NULL,
 CONSTRAINT [PK_REBACK_ITEM] PRIMARY KEY NONCLUSTERED 
(
	[REBACK_ITEM_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]

GO
/****** Object:  Table [dbo].[RECHARGE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RECHARGE](
	[RECHARGE_ID] [int] IDENTITY(1,1) NOT NULL,
	[MEM_PACK_ID] [int] NULL,
	[RECHARGE_NAME] [varchar](20) NULL,
	[RECHARGE_COUNT] [int] NULL,
	[GIFT_COUNT] [int] NULL,
	[ISCASHGIFT] [bit] NULL,
 CONSTRAINT [PK_RECHARGE] PRIMARY KEY NONCLUSTERED 
(
	[RECHARGE_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SALRY]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SALRY](
	[SALARY_ID] [int] IDENTITY(1,1) NOT NULL,
	[STAFFID] [int] NULL,
	[YEAR] [int] NULL,
	[MONTH] [int] NULL,
	[COMPLETE_ORDER_COUNT] [int] NULL,
	[REJECT_ORDER_COUNT] [int] NULL,
	[INCOME] [float] NULL,
	[TARE] [float] NULL,
 CONSTRAINT [PK_SALRY] PRIMARY KEY NONCLUSTERED 
(
	[SALARY_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]

GO
/****** Object:  Table [dbo].[SELFSERVICE]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SELFSERVICE](
	[SPECIAL_ID] [int] IDENTITY(1,1) NOT NULL,
	[CITY_SERVICE_ID] [int] NULL,
	[SELFSERVICE_NAME] [varchar](50) NOT NULL,
	[ISOPEN] [bit] NULL,
	[COST] [float] NOT NULL,
	[ISHOURCOST] [bit] NULL,
	[ISAREACOST] [bit] NULL,
 CONSTRAINT [PK_SELFSERVICE] PRIMARY KEY NONCLUSTERED 
(
	[SPECIAL_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SERVICE_ITEM]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SERVICE_ITEM](
	[SERVICE_ID] [int] IDENTITY(1,1) NOT NULL,
	[PARENT_SERVICE_ID] [int] NULL,
	[SERVICE_ITEM_NAME] [binary](20) NOT NULL,
	[SERVICECONTENT] [binary](100) NULL,
	[CT] [datetime] NULL,
	[URL] [varchar](100) NULL,
	[ISLEAF] [bit] NULL,
	[PICURL] [varchar](50) NULL,
	[LEAF_DEPT] [int] NULL,
 CONSTRAINT [PK_SERVICE_ITEM] PRIMARY KEY NONCLUSTERED 
(
	[SERVICE_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SERVICEPLACES]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SERVICEPLACES](
	[SERVICE_PLACE_ID] [int] IDENTITY(1,1) NOT NULL,
	[USERID] [int] NOT NULL,
	[PLACE_DETAIL] [varchar](100) NOT NULL,
	[PHONE] [varchar](20) NOT NULL,
	[LAST_TIME] [datetime] NOT NULL,
	[CREATE_TIME] [datetime] NOT NULL,
	[ADDR_TITLE] [varchar](50) NOT NULL,
	[CITYID] [varchar](10) NOT NULL,
	[LNG] [numeric](18, 0) NULL,
	[LAT] [numeric](18, 0) NULL,
 CONSTRAINT [PK_SERVICEPLACES] PRIMARY KEY NONCLUSTERED 
(
	[SERVICE_PLACE_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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[STAFF]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[STAFF](
	[STAFFID] [int] IDENTITY(1,1) NOT NULL,
	[STAFFNAME] [varchar](20) NOT NULL,
	[PASSWORD] [varchar](20) NOT NULL,
	[ADDR] [varchar](50) NULL,
	[EMAIL] [varchar](20) NULL,
	[PHONE] [varchar](20) NULL,
	[CT] [datetime] NULL,
	[LASTUPDATETIME] [datetime] NULL,
	[IDCARD] [varchar](18) NULL,
	[URL] [binary](50) NULL,
	[SEX] [int] NOT NULL,
	[QQ] [varchar](15) NOT NULL,
	[STATE] [int] NOT NULL,
	[LASTIP] [varchar](20) NULL,
	[LASTACTION] [datetime] NULL,
	[STAFF_LEVEL] [int] NULL,
 CONSTRAINT [PK_STAFF] PRIMARY KEY NONCLUSTERED 
(
	[STAFFID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[STAFF_LEVEL]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[STAFF_LEVEL](
	[LEVELID] [int] IDENTITY(1,1) NOT NULL,
	[LEVELNAME] [varchar](20) NOT NULL,
	[等级说明] [varchar](500) NULL,
 CONSTRAINT [PK_STAFF_LEVEL] PRIMARY KEY NONCLUSTERED 
(
	[LEVELID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[USER_LEVEL]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_LEVEL](
	[LEVELID] [int] IDENTITY(1,1) NOT NULL,
	[LEVELNAME] [varchar](20) NOT NULL,
	[LEVEL_DESC] [varchar](500) NULL,
 CONSTRAINT [PK_USER_LEVEL] PRIMARY KEY NONCLUSTERED 
(
	[LEVELID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[USERS]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USERS](
	[USERID] [int] IDENTITY(100000,1) NOT NULL,
	[USERNAME] [varchar](20) NOT NULL,
	[PASSWORD] [varchar](20) NOT NULL,
	[ADDR] [varchar](50) NULL,
	[EMAIL] [varchar](20) NULL,
	[PHONE] [varchar](20) NULL,
	[CT] [datetime] NULL,
	[LASTUPDATETIME] [datetime] NULL,
	[IDCARD] [varchar](18) NULL,
	[QQ] [varchar](15) NULL,
	[STATE] [int] NULL,
	[LASTIP] [varchar](20) NULL,
	[LASTACTION] [datetime] NULL,
	[USER_LEVEL] [int] NULL,
	[CASH_ALL] [float] NULL,
 CONSTRAINT [PK_USER] PRIMARY KEY NONCLUSTERED 
(
	[USERID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WORKOFF]    Script Date: 2015/11/30 20:14:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WORKOFF](
	[OFFID] [int] IDENTITY(1,1) NOT NULL,
	[STAFFID] [int] NULL,
	[OFFDATE] [datetime] NULL,
	[CT] [datetime] NULL,
	[REMARK] [binary](50) NULL,
 CONSTRAINT [PK_WORKOFF] PRIMARY KEY NONCLUSTERED 
(
	[OFFID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[COMMISION_RULE] ADD  DEFAULT ((0)) FOR [ISOPEN]
GO
ALTER TABLE [dbo].[COMMISION_RULE_ITEM] ADD  DEFAULT ((0.0)) FOR [RULE_RATE]
GO
ALTER TABLE [dbo].[SALRY] ADD  DEFAULT ((0)) FOR [COMPLETE_ORDER_COUNT]
GO
ALTER TABLE [dbo].[SALRY] ADD  DEFAULT ((0)) FOR [REJECT_ORDER_COUNT]
GO
ALTER TABLE [dbo].[SALRY] ADD  DEFAULT ((0.0)) FOR [INCOME]
GO
ALTER TABLE [dbo].[SALRY] ADD  DEFAULT ((0.0)) FOR [TARE]
GO
ALTER TABLE [dbo].[SERVICEPLACES] ADD  CONSTRAINT [DF__SERVICEPL__CREAT__3BCADD1B]  DEFAULT ('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP') FOR [CREATE_TIME]
GO
ALTER TABLE [dbo].[STAFF] ADD  DEFAULT ((0)) FOR [SEX]
GO
ALTER TABLE [dbo].[STAFF] ADD  DEFAULT ((0)) FOR [STATE]
GO
ALTER TABLE [dbo].[USERS] ADD  CONSTRAINT [DF__USER__STATE__467D75B8]  DEFAULT ((0)) FOR [STATE]
GO
ALTER TABLE [dbo].[USERS] ADD  CONSTRAINT [DF__USER__CASH_ALL__477199F1]  DEFAULT ((0.0)) FOR [CASH_ALL]
GO
ALTER TABLE [dbo].[AUTHORMODULES]  WITH CHECK ADD  CONSTRAINT [FK_AUTHORMO_REFERENCE_MASTERS] FOREIGN KEY([MASTER_ID])
REFERENCES [dbo].[MASTERS] ([MASTER_ID])
GO
ALTER TABLE [dbo].[AUTHORMODULES] CHECK CONSTRAINT [FK_AUTHORMO_REFERENCE_MASTERS]
GO
ALTER TABLE [dbo].[AUTHORMODULES]  WITH CHECK ADD  CONSTRAINT [FK_AUTHORMO_REFERENCE_MODULES] FOREIGN KEY([MODULE_ID])
REFERENCES [dbo].[MODULES] ([MODULE_ID])
GO
ALTER TABLE [dbo].[AUTHORMODULES] CHECK CONSTRAINT [FK_AUTHORMO_REFERENCE_MODULES]
GO
ALTER TABLE [dbo].[CITY]  WITH CHECK ADD  CONSTRAINT [FK_CITY_REFERENCE_PROVICE] FOREIGN KEY([PROVINCEID])
REFERENCES [dbo].[PROVICE] ([PROVINCEID])
GO
ALTER TABLE [dbo].[CITY] CHECK CONSTRAINT [FK_CITY_REFERENCE_PROVICE]
GO
ALTER TABLE [dbo].[COMMISION_RULE]  WITH CHECK ADD  CONSTRAINT [FK_COMMISIO_REFERENCE_CITY] FOREIGN KEY([CITYID])
REFERENCES [dbo].[CITY] ([CITYID])
GO
ALTER TABLE [dbo].[COMMISION_RULE] CHECK CONSTRAINT [FK_COMMISIO_REFERENCE_CITY]
GO
ALTER TABLE [dbo].[COMMISION_RULE_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_COMMISIO_REFERENCE_COMMISIO] FOREIGN KEY([RULE_ID])
REFERENCES [dbo].[COMMISION_RULE] ([RULE_ID])
GO
ALTER TABLE [dbo].[COMMISION_RULE_ITEM] CHECK CONSTRAINT [FK_COMMISIO_REFERENCE_COMMISIO]
GO
ALTER TABLE [dbo].[COMMISION_RULE_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_COMMISIO_REFERENCE_SERVICE_] FOREIGN KEY([SERVICEID])
REFERENCES [dbo].[SERVICE_ITEM] ([SERVICE_ID])
GO
ALTER TABLE [dbo].[COMMISION_RULE_ITEM] CHECK CONSTRAINT [FK_COMMISIO_REFERENCE_SERVICE_]
GO
ALTER TABLE [dbo].[COMPANY_CHILD]  WITH CHECK ADD  CONSTRAINT [FK_COMPANY__REFERENCE_CITY] FOREIGN KEY([CITYID])
REFERENCES [dbo].[CITY] ([CITYID])
GO
ALTER TABLE [dbo].[COMPANY_CHILD] CHECK CONSTRAINT [FK_COMPANY__REFERENCE_CITY]
GO
ALTER TABLE [dbo].[COMPANY_DETAIL_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_COMPANY__REFERENCE_COMPANY_] FOREIGN KEY([CHILD_ID])
REFERENCES [dbo].[COMPANY_CHILD] ([CHILD_ID])
GO
ALTER TABLE [dbo].[COMPANY_DETAIL_ITEM] CHECK CONSTRAINT [FK_COMPANY__REFERENCE_COMPANY_]
GO
ALTER TABLE [dbo].[COMPANY_DETAIL_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_COMPANY__REFERENCE_DETAIL_I] FOREIGN KEY([DETAIL_CODE])
REFERENCES [dbo].[DETAIL_ITEM] ([DETAIL_CODE])
GO
ALTER TABLE [dbo].[COMPANY_DETAIL_ITEM] CHECK CONSTRAINT [FK_COMPANY__REFERENCE_DETAIL_I]
GO
ALTER TABLE [dbo].[COUPON_INFO]  WITH CHECK ADD  CONSTRAINT [FK_COUPON_I_REFERENCE_PROVINCE] FOREIGN KEY([CITY_SERVICE_ID])
REFERENCES [dbo].[PROVINCE_BASIC_SERVICE] ([CITY_SERVICE_ID])
GO
ALTER TABLE [dbo].[COUPON_INFO] CHECK CONSTRAINT [FK_COUPON_I_REFERENCE_PROVINCE]
GO
ALTER TABLE [dbo].[COUPON_RECORD]  WITH CHECK ADD  CONSTRAINT [FK_COUPON_R_REFERENCE_COUPON_I] FOREIGN KEY([COUPON_ID])
REFERENCES [dbo].[COUPON_INFO] ([COUPON_ID])
GO
ALTER TABLE [dbo].[COUPON_RECORD] CHECK CONSTRAINT [FK_COUPON_R_REFERENCE_COUPON_I]
GO
ALTER TABLE [dbo].[COUPON_RECORD]  WITH CHECK ADD  CONSTRAINT [FK_COUPON_R_REFERENCE_PROVINCE] FOREIGN KEY([CITY_SERVICE_ID])
REFERENCES [dbo].[PROVINCE_BASIC_SERVICE] ([CITY_SERVICE_ID])
GO
ALTER TABLE [dbo].[COUPON_RECORD] CHECK CONSTRAINT [FK_COUPON_R_REFERENCE_PROVINCE]
GO
ALTER TABLE [dbo].[COUPON_RECORD]  WITH CHECK ADD  CONSTRAINT [FK_COUPON_R_REFERENCE_USER] FOREIGN KEY([USERID])
REFERENCES [dbo].[USERS] ([USERID])
GO
ALTER TABLE [dbo].[COUPON_RECORD] CHECK CONSTRAINT [FK_COUPON_R_REFERENCE_USER]
GO
ALTER TABLE [dbo].[EXTRA_DEMAND]  WITH CHECK ADD  CONSTRAINT [FK_EXTRA_DE_REFERENCE_ORDERS] FOREIGN KEY([ORDERID])
REFERENCES [dbo].[ORDERS] ([ORDERID])
GO
ALTER TABLE [dbo].[EXTRA_DEMAND] CHECK CONSTRAINT [FK_EXTRA_DE_REFERENCE_ORDERS]
GO
ALTER TABLE [dbo].[EXTRA_DEMAND]  WITH CHECK ADD  CONSTRAINT [FK_EXTRA_DE_REFERENCE_SELFSERV] FOREIGN KEY([SPECIAL_ID])
REFERENCES [dbo].[SELFSERVICE] ([SPECIAL_ID])
GO
ALTER TABLE [dbo].[EXTRA_DEMAND] CHECK CONSTRAINT [FK_EXTRA_DE_REFERENCE_SELFSERV]
GO
ALTER TABLE [dbo].[MEMBERSHIP_PACKAGE]  WITH CHECK ADD  CONSTRAINT [FK_MEMBERSH_REFERENCE_MASTERS] FOREIGN KEY([CU_ID])
REFERENCES [dbo].[MASTERS] ([MASTER_ID])
GO
ALTER TABLE [dbo].[MEMBERSHIP_PACKAGE] CHECK CONSTRAINT [FK_MEMBERSH_REFERENCE_MASTERS]
GO
ALTER TABLE [dbo].[MEMBERSHIP_PACKAGE]  WITH CHECK ADD  CONSTRAINT [FK_MEMBERSH_REFERENCE_PACK_TYP] FOREIGN KEY([PACK_TYPE_ID])
REFERENCES [dbo].[PACK_TYPE] ([PACK_TYPE_ID])
GO
ALTER TABLE [dbo].[MEMBERSHIP_PACKAGE] CHECK CONSTRAINT [FK_MEMBERSH_REFERENCE_PACK_TYP]
GO
ALTER TABLE [dbo].[ORDER_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_ORDER_IT_REFERENCE_ORDERS] FOREIGN KEY([ORDERID])
REFERENCES [dbo].[ORDERS] ([ORDERID])
GO
ALTER TABLE [dbo].[ORDER_ITEM] CHECK CONSTRAINT [FK_ORDER_IT_REFERENCE_ORDERS]
GO
ALTER TABLE [dbo].[ORDER_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_ORDER_IT_REFERENCE_RATEPLAN] FOREIGN KEY([RATEPLAN_ID])
REFERENCES [dbo].[RATEPLAN] ([RATEPLAN_ID])
GO
ALTER TABLE [dbo].[ORDER_ITEM] CHECK CONSTRAINT [FK_ORDER_IT_REFERENCE_RATEPLAN]
GO
ALTER TABLE [dbo].[ORDERS]  WITH CHECK ADD  CONSTRAINT [FK_ORDERS_REFERENCE_STAFF] FOREIGN KEY([STAFFID])
REFERENCES [dbo].[STAFF] ([STAFFID])
GO
ALTER TABLE [dbo].[ORDERS] CHECK CONSTRAINT [FK_ORDERS_REFERENCE_STAFF]
GO
ALTER TABLE [dbo].[ORDERS]  WITH CHECK ADD  CONSTRAINT [FK_ORDERS_REFERENCE_USER] FOREIGN KEY([USERID])
REFERENCES [dbo].[USERS] ([USERID])
GO
ALTER TABLE [dbo].[ORDERS] CHECK CONSTRAINT [FK_ORDERS_REFERENCE_USER]
GO
ALTER TABLE [dbo].[PROVINCE_BASIC_SERVICE]  WITH CHECK ADD  CONSTRAINT [FK_PROVINCE_REFERENCE_CITY] FOREIGN KEY([CITYID])
REFERENCES [dbo].[CITY] ([CITYID])
GO
ALTER TABLE [dbo].[PROVINCE_BASIC_SERVICE] CHECK CONSTRAINT [FK_PROVINCE_REFERENCE_CITY]
GO
ALTER TABLE [dbo].[PROVINCE_BASIC_SERVICE]  WITH CHECK ADD  CONSTRAINT [FK_PROVINCE_REFERENCE_SERVICE_] FOREIGN KEY([SERVICE_ITEM_ID])
REFERENCES [dbo].[SERVICE_ITEM] ([SERVICE_ID])
GO
ALTER TABLE [dbo].[PROVINCE_BASIC_SERVICE] CHECK CONSTRAINT [FK_PROVINCE_REFERENCE_SERVICE_]
GO
ALTER TABLE [dbo].[RATEPLAN]  WITH CHECK ADD  CONSTRAINT [FK_RATEPLAN_REFERENCE_PROVINCE] FOREIGN KEY([CITY_SERVICE_ID])
REFERENCES [dbo].[PROVINCE_BASIC_SERVICE] ([CITY_SERVICE_ID])
GO
ALTER TABLE [dbo].[RATEPLAN] CHECK CONSTRAINT [FK_RATEPLAN_REFERENCE_PROVINCE]
GO
ALTER TABLE [dbo].[REBACK_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_REBACK_I_REFERENCE_PROVINCE] FOREIGN KEY([CITY_SERVICE_ID])
REFERENCES [dbo].[PROVINCE_BASIC_SERVICE] ([CITY_SERVICE_ID])
GO
ALTER TABLE [dbo].[REBACK_ITEM] CHECK CONSTRAINT [FK_REBACK_I_REFERENCE_PROVINCE]
GO
ALTER TABLE [dbo].[REBACK_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_REBACK_I_REFERENCE_RECHARGE] FOREIGN KEY([RECHARGE_ID])
REFERENCES [dbo].[RECHARGE] ([RECHARGE_ID])
GO
ALTER TABLE [dbo].[REBACK_ITEM] CHECK CONSTRAINT [FK_REBACK_I_REFERENCE_RECHARGE]
GO
ALTER TABLE [dbo].[RECHARGE]  WITH CHECK ADD  CONSTRAINT [FK_RECHARGE_REFERENCE_MEMBERSH] FOREIGN KEY([MEM_PACK_ID])
REFERENCES [dbo].[MEMBERSHIP_PACKAGE] ([MEM_PACK_ID])
GO
ALTER TABLE [dbo].[RECHARGE] CHECK CONSTRAINT [FK_RECHARGE_REFERENCE_MEMBERSH]
GO
ALTER TABLE [dbo].[SALRY]  WITH CHECK ADD  CONSTRAINT [FK_SALRY_REFERENCE_STAFF] FOREIGN KEY([STAFFID])
REFERENCES [dbo].[STAFF] ([STAFFID])
GO
ALTER TABLE [dbo].[SALRY] CHECK CONSTRAINT [FK_SALRY_REFERENCE_STAFF]
GO
ALTER TABLE [dbo].[SELFSERVICE]  WITH CHECK ADD  CONSTRAINT [FK_SELFSERV_REFERENCE_PROVINCE] FOREIGN KEY([CITY_SERVICE_ID])
REFERENCES [dbo].[PROVINCE_BASIC_SERVICE] ([CITY_SERVICE_ID])
GO
ALTER TABLE [dbo].[SELFSERVICE] CHECK CONSTRAINT [FK_SELFSERV_REFERENCE_PROVINCE]
GO
ALTER TABLE [dbo].[SERVICE_ITEM]  WITH CHECK ADD  CONSTRAINT [FK_SERVICE__REFERENCE_SERVICE_] FOREIGN KEY([PARENT_SERVICE_ID])
REFERENCES [dbo].[SERVICE_ITEM] ([SERVICE_ID])
GO
ALTER TABLE [dbo].[SERVICE_ITEM] CHECK CONSTRAINT [FK_SERVICE__REFERENCE_SERVICE_]
GO
ALTER TABLE [dbo].[SERVICEPLACES]  WITH CHECK ADD  CONSTRAINT [FK_SERVICEP_REFERENCE_USERS] FOREIGN KEY([USERID])
REFERENCES [dbo].[USERS] ([USERID])
GO
ALTER TABLE [dbo].[SERVICEPLACES] CHECK CONSTRAINT [FK_SERVICEP_REFERENCE_USERS]
GO
ALTER TABLE [dbo].[STAFF]  WITH CHECK ADD  CONSTRAINT [FK_STAFF_REFERENCE_STAFF_LE] FOREIGN KEY([STAFF_LEVEL])
REFERENCES [dbo].[STAFF_LEVEL] ([LEVELID])
GO
ALTER TABLE [dbo].[STAFF] CHECK CONSTRAINT [FK_STAFF_REFERENCE_STAFF_LE]
GO
ALTER TABLE [dbo].[USERS]  WITH CHECK ADD  CONSTRAINT [FK_USER_REFERENCE_USER_LEV] FOREIGN KEY([USER_LEVEL])
REFERENCES [dbo].[USER_LEVEL] ([LEVELID])
GO
ALTER TABLE [dbo].[USERS] CHECK CONSTRAINT [FK_USER_REFERENCE_USER_LEV]
GO
ALTER TABLE [dbo].[USERS]  WITH CHECK ADD  CONSTRAINT [FK_USERS_REFERENCE_USER_LEV] FOREIGN KEY([USER_LEVEL])
REFERENCES [dbo].[USER_LEVEL] ([LEVELID])
GO
ALTER TABLE [dbo].[USERS] CHECK CONSTRAINT [FK_USERS_REFERENCE_USER_LEV]
GO
ALTER TABLE [dbo].[WORKOFF]  WITH CHECK ADD  CONSTRAINT [FK_WORKOFF_REFERENCE_STAFF] FOREIGN KEY([STAFFID])
REFERENCES [dbo].[STAFF] ([STAFFID])
GO
ALTER TABLE [dbo].[WORKOFF] CHECK CONSTRAINT [FK_WORKOFF_REFERENCE_STAFF]
GO
ALTER TABLE [dbo].[COMMISION_RULE]  WITH CHECK ADD  CONSTRAINT [CKC_CITYID_COMMISIO] CHECK  (([CITYID] IS NULL OR [CITYID]>=(1000)))
GO
ALTER TABLE [dbo].[COMMISION_RULE] CHECK CONSTRAINT [CKC_CITYID_COMMISIO]
GO
ALTER TABLE [dbo].[COMMISION_RULE]  WITH CHECK ADD  CONSTRAINT [CKC_RULE_ID_COMMISIO] CHECK  (([RULE_ID]>=(1000)))
GO
ALTER TABLE [dbo].[COMMISION_RULE] CHECK CONSTRAINT [CKC_RULE_ID_COMMISIO]
GO
ALTER TABLE [dbo].[COMMISION_RULE_ITEM]  WITH CHECK ADD  CONSTRAINT [CKC_RULE_ITEM_ID_COMMISIO] CHECK  (([RULE_ITEM_ID]>=(1000)))
GO
ALTER TABLE [dbo].[COMMISION_RULE_ITEM] CHECK CONSTRAINT [CKC_RULE_ITEM_ID_COMMISIO]
GO
ALTER TABLE [dbo].[COMPANY_CHILD]  WITH CHECK ADD  CONSTRAINT [CKC_CITYID_COMPANY_] CHECK  (([CITYID] IS NULL OR [CITYID]>=(1000)))
GO
ALTER TABLE [dbo].[COMPANY_CHILD] CHECK CONSTRAINT [CKC_CITYID_COMPANY_]
GO
ALTER TABLE [dbo].[COUPON_INFO]  WITH CHECK ADD  CONSTRAINT [CKC_CITY_SERVICE_ID_COUPON_I] CHECK  (([CITY_SERVICE_ID] IS NULL OR [CITY_SERVICE_ID]>=(1000)))
GO
ALTER TABLE [dbo].[COUPON_INFO] CHECK CONSTRAINT [CKC_CITY_SERVICE_ID_COUPON_I]
GO
ALTER TABLE [dbo].[COUPON_RECORD]  WITH CHECK ADD  CONSTRAINT [CKC_CITY_SERVICE_ID_COUPON_R] CHECK  (([CITY_SERVICE_ID] IS NULL OR [CITY_SERVICE_ID]>=(1000)))
GO
ALTER TABLE [dbo].[COUPON_RECORD] CHECK CONSTRAINT [CKC_CITY_SERVICE_ID_COUPON_R]
GO
ALTER TABLE [dbo].[ORDERS]  WITH CHECK ADD  CONSTRAINT [CKC_ORDERID_ORDERS] CHECK  (([ORDERID]>=(100000020)))
GO
ALTER TABLE [dbo].[ORDERS] CHECK CONSTRAINT [CKC_ORDERID_ORDERS]
GO
ALTER TABLE [dbo].[PROVINCE_BASIC_SERVICE]  WITH CHECK ADD  CONSTRAINT [CKC_CITY_SERVICE_ID_PROVINCE] CHECK  (([CITY_SERVICE_ID]>=(1000)))
GO
ALTER TABLE [dbo].[PROVINCE_BASIC_SERVICE] CHECK CONSTRAINT [CKC_CITY_SERVICE_ID_PROVINCE]
GO
ALTER TABLE [dbo].[RATEPLAN]  WITH CHECK ADD  CONSTRAINT [CKC_CITY_SERVICE_ID_RATEPLAN] CHECK  (([CITY_SERVICE_ID] IS NULL OR [CITY_SERVICE_ID]>=(1000)))
GO
ALTER TABLE [dbo].[RATEPLAN] CHECK CONSTRAINT [CKC_CITY_SERVICE_ID_RATEPLAN]
GO
ALTER TABLE [dbo].[REBACK_ITEM]  WITH CHECK ADD  CONSTRAINT [CKC_CITY_SERVICE_ID_REBACK_I] CHECK  (([CITY_SERVICE_ID] IS NULL OR [CITY_SERVICE_ID]>=(1000)))
GO
ALTER TABLE [dbo].[REBACK_ITEM] CHECK CONSTRAINT [CKC_CITY_SERVICE_ID_REBACK_I]
GO
ALTER TABLE [dbo].[SALRY]  WITH CHECK ADD  CONSTRAINT [CKC_STAFFID_SALRY] CHECK  (([STAFFID] IS NULL OR [STAFFID]>=(1000)))
GO
ALTER TABLE [dbo].[SALRY] CHECK CONSTRAINT [CKC_STAFFID_SALRY]
GO
ALTER TABLE [dbo].[SELFSERVICE]  WITH CHECK ADD  CONSTRAINT [CKC_CITY_SERVICE_ID_SELFSERV] CHECK  (([CITY_SERVICE_ID] IS NULL OR [CITY_SERVICE_ID]>=(1000)))
GO
ALTER TABLE [dbo].[SELFSERVICE] CHECK CONSTRAINT [CKC_CITY_SERVICE_ID_SELFSERV]
GO
ALTER TABLE [dbo].[STAFF]  WITH CHECK ADD  CONSTRAINT [CKC_STAFFID_STAFF] CHECK  (([STAFFID]>=(1000)))
GO
ALTER TABLE [dbo].[STAFF] CHECK CONSTRAINT [CKC_STAFFID_STAFF]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模块授权' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AUTHORMODULES'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别   1=现金充值  2=支付宝充值  3=微信充值   4=消费  5=取现' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CASH_LOG', @level2type=N'COLUMN',@level2name=N'TYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录用户的每一笔消费' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CASH_LOG'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHECKCODERECORD', @level2type=N'COLUMN',@level2name=N'PHONENO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHECKCODERECORD', @level2type=N'COLUMN',@level2name=N'CHECKCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHECKCODERECORD', @level2type=N'COLUMN',@level2name=N'CREATETIME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否验证' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHECKCODERECORD', @level2type=N'COLUMN',@level2name=N'ISCHECKED'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录验证码用的' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CHECKCODERECORD'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务开放的城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CITY'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'佣金设置不能删除  只能设置失效  佣金规则精确到某个城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'COMMISION_RULE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'佣金规则详细项' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'COMMISION_RULE_ITEM'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司的特性，可以随时添加' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'COMPANY_DETAIL_ITEM'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'优惠券信息，什么业务的优惠券，金额等' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'COUPON_INFO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'优惠券来源渠道，1=抢到的优惠券  2=充值返还' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'COUPON_RECORD', @level2type=N'COLUMN',@level2name=N'CHANNEL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户领用的优惠券，用户充值的时候赠送的优惠券也在此' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'COUPON_RECORD'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'如无提供的选项则让用户在此输入要求' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EXTRA_DEMAND', @level2type=N'COLUMN',@level2name=N'REMARK'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户的额外需求' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EXTRA_DEMAND'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站维护人员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MASTERS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'后台维护模块' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MODULES'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运行日志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OPERATION_LOG'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单详情表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ORDER_ITEM'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'包含现付和预付   1=现付  2=支付宝  3=微信' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ORDERS', @level2type=N'COLUMN',@level2name=N'PAY_TYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当为现付的时候  客人付现  员工收钱点击结账' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ORDERS', @level2type=N'COLUMN',@level2name=N'ISCASHPAYED'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源于用户输入' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ORDERS', @level2type=N'COLUMN',@level2name=N'SERVICE_LOCATION'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源于地图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ORDERS', @level2type=N'COLUMN',@level2name=N'SERVICE_POS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ORDERS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'多少钱一个小时' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PROVINCE_BASIC_SERVICE', @level2type=N'COLUMN',@level2name=N'SERVICECOST'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'城市业务基础表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PROVINCE_BASIC_SERVICE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'城市业务价格计划' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RATEPLAN'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'实时消息，用于推送给用户或者员工，包括促销，提示等' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'REALMESSAGE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'充值赠送服务券详情， 用户充值后已优惠券的形式发放' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'REBACK_ITEM'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'两种返现方式：一种为现金  直接返还现金   另一种为赠送优惠券' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RECHARGE', @level2type=N'COLUMN',@level2name=N'ISCASHGIFT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按照用户充值的金额分类' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RECHARGE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当月完成一个订单则增加1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SALRY', @level2type=N'COLUMN',@level2name=N'COMPLETE_ORDER_COUNT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当月拒绝一个订单则增加1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SALRY', @level2type=N'COLUMN',@level2name=N'REJECT_ORDER_COUNT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'每笔订单除去佣金的返给员工的钱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SALRY', @level2type=N'COLUMN',@level2name=N'INCOME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'员工拒单扣除的钱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SALRY', @level2type=N'COLUMN',@level2name=N'TARE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'员工工资表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SALRY'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户可选项，用户的偏好选择' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SELFSERVICE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SERVICE_ITEM'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务地址id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SERVICEPLACES', @level2type=N'COLUMN',@level2name=N'SERVICE_PLACE_ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SERVICEPLACES', @level2type=N'COLUMN',@level2name=N'USERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'具体地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SERVICEPLACES', @level2type=N'COLUMN',@level2name=N'PLACE_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SERVICEPLACES', @level2type=N'COLUMN',@level2name=N'PHONE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近服务时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SERVICEPLACES', @level2type=N'COLUMN',@level2name=N'LAST_TIME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录客户创建的所有服务地址和联系方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SERVICEPLACES'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内部员工表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'STAFF'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'USERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'USERNAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'PASSWORD'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'ADDR'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'EMAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'PHONE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'CT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后一次修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'LASTUPDATETIME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份证号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'IDCARD'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'qq号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'QQ'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'STATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近登录ip' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'LASTIP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最近登录时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'LASTACTION'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户等级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'USER_LEVEL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现金总额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS', @level2type=N'COLUMN',@level2name=N'CASH_ALL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'USERS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'员工请假,用户不可预约' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WORKOFF'
GO
USE [master]
GO
ALTER DATABASE [housekeeping] SET  READ_WRITE 
GO