餐饮管理系统之数据库（Database）_真实修正版

USE [CMS] GO /****** 对象: Table [dbo].[ygInfo] 脚本日期: 11/15/2012 23:33:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ygInfo]( [ygId] [nvarchar](7) NOT NULL, [ygPwd] [nvarchar](32) NULL, [ygName] [nvarchar](20) NULL, [ygAge] [nvarchar](6) NULL, [ygSex] [nvarchar](4) NULL, [ygPos] [nvarchar](8) NULL, [ygTel] [nvarchar](12) NULL, [ygAdd] [nvarchar](30) NULL, [depName] [nvarchar](6) NULL, [ygMeno] [ntext] NULL, CONSTRAINT [PK_ygInfo] PRIMARY KEY CLUSTERED ( [ygId] 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 /****** 对象: Table [dbo].[dinnerTable] 脚本日期: 11/15/2012 23:33:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[dinnerTable]( [tabId] [nvarchar](4) NOT NULL, [tabName] [nvarchar](20) NULL, [tabState] [nvarchar](50) NULL, [tabPos] [nvarchar](8) NULL, [tabMeno] [nvarchar](50) NULL, CONSTRAINT [PK_dinnerTalbe] PRIMARY KEY CLUSTERED ( [tabId] 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 /****** 对象: Table [dbo].[dishType] 脚本日期: 11/15/2012 23:33:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[dishType]( [typeId] [nvarchar](50) NOT NULL, [typeName] [nvarchar](8) NULL, [typeMeno] [nvarchar](50) NULL, CONSTRAINT [PK_dishType_1] PRIMARY KEY CLUSTERED ( [typeId] 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 /****** 对象: Table [dbo].[admin] 脚本日期: 11/15/2012 23:33:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[admin]( [adminId] [nvarchar](7) NULL, [adminPwd] [nvarchar](16) NULL ) ON [PRIMARY] GO /****** 对象: Table [dbo].[checkMoney] 脚本日期: 11/15/2012 23:33:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[checkMoney]( [checkId] [nvarchar](50) NOT NULL, [tabId] [nvarchar](4) NULL, [account] [float] NULL, [paidup] [float] NULL, [dibs] [float] NULL, [now_time] [nvarchar](50) NULL, [ygId] [nvarchar](7) NULL, CONSTRAINT [PK_menuInfo] PRIMARY KEY CLUSTERED ( [checkId] 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 /****** 对象: Table [dbo].[dishInfo] 脚本日期: 11/15/2012 23:33:28 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[dishInfo]( [dishId] [nvarchar](20) NOT NULL, [dishName] [nvarchar](30) NULL, [typeId] [nvarchar](50) NULL, [dishPrice] [float] NULL, [dishMeno] [nvarchar](50) NULL, CONSTRAINT [PK_dishInfo] PRIMARY KEY CLUSTERED ( [dishId] 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 /****** 对象: ForeignKey [FK_checkMoney_dinnerTable] 脚本日期: 11/15/2012 23:33:24 ******/ ALTER TABLE [dbo].[checkMoney] WITH CHECK ADD CONSTRAINT [FK_checkMoney_dinnerTable] FOREIGN KEY([tabId]) REFERENCES [dbo].[dinnerTable] ([tabId]) GO ALTER TABLE [dbo].[checkMoney] CHECK CONSTRAINT [FK_checkMoney_dinnerTable] GO /****** 对象: ForeignKey [FK_checkMoney_ygInfo] 脚本日期: 11/15/2012 23:33:24 ******/ ALTER TABLE [dbo].[checkMoney] WITH CHECK ADD CONSTRAINT [FK_checkMoney_ygInfo] FOREIGN KEY([ygId]) REFERENCES [dbo].[ygInfo] ([ygId]) GO ALTER TABLE [dbo].[checkMoney] CHECK CONSTRAINT [FK_checkMoney_ygInfo] GO /****** 对象: ForeignKey [FK_dishInfo_dishType] 脚本日期: 11/15/2012 23:33:28 ******/ ALTER TABLE [dbo].[dishInfo] WITH CHECK ADD CONSTRAINT [FK_dishInfo_dishType] FOREIGN KEY([typeId]) REFERENCES [dbo].[dishType]�