酒店管理系统之数据库(Database)

USE [hotel] GO /****** 对象: Table [dbo].[price] 脚本日期: 11/28/2012 18:32:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[price]( [standard] [nvarchar](20) NOT NULL, [information] [nvarchar](20) NOT NULL, [room_kind] [nvarchar](20) NOT NULL, [price] [float] NOT NULL ) ON [PRIMARY] GO /****** 对象: Table [dbo].[users] 脚本日期: 11/28/2012 18:32:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[users]( [username] [char](10) NOT NULL, [pwd] [char](10) NOT NULL, [power] [nvarchar](20) NOT NULL, CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED ( [username] 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 /****** 对象: Table [dbo].[lodger] 脚本日期: 11/28/2012 18:32:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[lodger]( [name] [char](10) NOT NULL, [ID] [nvarchar](18) NOT NULL, [sex] [char](2) NOT NULL, [remark] [nvarchar](200) NULL, CONSTRAINT [PK_lodger] PRIMARY KEY CLUSTERED ( [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 /****** 对象: Table [dbo].[room] 脚本日期: 11/28/2012 18:32:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[room]( [number] [nvarchar](20) NOT NULL, [standard] [nvarchar](20) NOT NULL, [information] [nvarchar](20) NOT NULL, [isfull] [int] NOT NULL, [remark] [nvarchar](200) NULL, [lodgerID] [char](18) NULL, [check_IN] [datetime] NULL, [room_kind] [nvarchar](20) NULL, CONSTRAINT [PK_room] PRIMARY KEY CLUSTERED ( [number] 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