sql1.txt

来自「物业管理MICROSOFT FOUNDATION CLASS LIBRARY :」· 文本 代码 · 共 44 行

create database Room
CREATE TABLE user_Info (
	[user_ID] [varchar] (15)  NOT NULL ,
	[user_PWD] [varchar] (10)  NULL ,
	[user_Des] [varchar] (10)  NULL 
) 

CREATE TABLE bookin (
	[bookno] [varchar] (14)  NOT NULL ,
	[customname] [varchar] (10)  NOT NULL ,
	[customID] [varchar] (18)  NOT NULL ,
	[roomno] [varchar] (10)  NOT NULL ,
	[indate] [datetime] NULL ,
	[discount] [float] NULL ,
	[inmemo] [text]  NULL ,
	[checkdate] [datetime] NULL ,
	[ammount] [float] NULL 
) 

CREATE TABLE rooms (
	[roomNO] [varchar] (10)  NOT NULL ,
	[roomtype] [varchar] (10)  NOT NULL ,
	[roomposition] [varchar] (20)  NULL ,
	[roomprice] [float] NULL ,
	[putup] [bit], 
	[roommemo] [text]  NULL 
) 

CREATE TABLE roomtype (
	[typeid] [varchar] (10)  NOT NULL ,
	[typename] [varchar] (10)  NOT NULL ,
	[area] [float] NULL ,
	[bednum] [int] NULL ,
	[haircondition] [bit], 
	[htelephone] [bit],
	[htelevision] [bit],
	[htoilet] [bit],
	[price] [float] NULL 
) 

INSERT user_Info (user_ID, user_PWD) VALUES ('张德金', '0')