📄 hotel.sql

📁 酒店管理信息系统是一个由人、计算机和数据库组成的进行酒店经营管理的系统
💻 SQL
📖 第 1 页 / 共 2 页
字号:
上一页 12
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Installation] (
	[installation_id] [int] NOT NULL primary key,
	[installation_name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[installation_price] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Live_paper] (
	[live_id] [char] (36) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[engage_id] [char] (36) COLLATE Chinese_PRC_CI_AS NULL ,
	[guest_id] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[room_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[arrive_time] [datetime] NULL ,
	[leave_time] [datetime] NULL ,
	[paper_status] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[guest_num] [int] NULL ,
	[room_id] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[room_price] [int] NULL ,
	[lived_price] [int] NULL ,
	[rate] [decimal](4, 2) NULL ,
	[rate_reason] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[is_add_bed] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[add_bed_price] [int] NULL ,
	[engage_money] [int] NULL ,
	[engage_peope] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[engage_company] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[others] [char] (510) COLLATE Chinese_PRC_CI_AS NULL ,
	[operater] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[sever] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[is_breakfast] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[is_wake_up] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[is_keep_secret] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[vip_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[especial_state] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[should_pay] [money] NULL ,
	[is_pay] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[pay_money] [int] NULL ,
	[pay_time] [datetime] NULL ,
	[pay_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[guest_name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[guest_sex] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
        constraint pk_live_paper primary key(live_id,room_id)
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Reserved] (
	[reserved_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL primary key,
	[fun_item_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[engage_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[client_name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Room] (
	[room_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL primary key,
	[room_name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[room_occupid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[room_grade] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[room_installation] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Room_grade] (
	[room_id] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
        constraint FK_room_id foreign key(room_id) references room(room_id),
	[grade_id] [int] NOT NULL 
        constraint FK_grade_id foreign key(grade_id) references grade(grade_id)
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Seat] (
	[bar_seat_number] [int] NOT NULL,
	[seat_price] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Seat_engage] (
	[bar_seat_id] [int] NOT NULL ,
	[bar_seat_number] [int] NULL ,
	[when_start] [datetime] NULL ,
	[when_end] [datetime] NULL ,
	[engage_name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Supply_item] (
	[bar_item_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bar_item_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL primary key ,
	[bar_item_price] [money] NOT NULL ,
	[bar_item_price_rate] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VIP] (
	[vip_type] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL primary key,
	[vip_num] [int] NULL ,
	[vip_money] [money] NULL ,
	[others] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[vip_rate] [decimal](4, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Work_jiangcheng] (
	[worker_id] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
        constraint worker_id foreign key(worker_id) references Worker_infor(worker_id),
	[work_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dep_id] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[dep_name] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[zhuti] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[neirong] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pizhunren] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Work_move] (
	[worker_id] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 
        constraint worker_id foreign key(worker_id) references Worker_infor(worker_id),
	[work_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[old_dep] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[new_dep] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jingbanren] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[liyou] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[shijian] [datetime] NULL ,
	[beizhu] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Worker_infor] (
	[worker_id] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL primary key,
	[work_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[work_sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[work_birthday] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[work_minzu] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[work_jiguan] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[work_shenfenzheng] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[work_marriage] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[work_addre] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[work_zhuangtai] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[dep_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[shouquan] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[denglu_mima] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[engage] (
	[engage_id] [char] (36) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[guest_id] [char] (19) COLLATE Chinese_PRC_CI_AS NULL ,
	[room_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[arrive_time] [datetime] NOT NULL ,
	[leave_time] [datetime] NULL ,
	[guest_num] [int] NULL ,
	[room_id] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[room_price] [money] NULL ,
	[lived_price] [money] NULL ,
	[rate] [decimal](4, 2) NULL ,
	[rate_reason] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[is_add_bed] [bit] NULL ,
	[add_bed_price] [money] NULL ,
	[engage_money] [money] NULL ,
	[engage_peope] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[engage_company] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[others] [char] (510) COLLATE Chinese_PRC_CI_AS NULL ,
	[operater] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[vip_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[guest_name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[guest_sex] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[engage_time] [datetime] NOT NULL ,
         constraint pk_engage primary key(engage_id,room_id)
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[engage_infor] (
	[fun_item_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
        foreign key(fun_item_id) references Fun_item(fun_item_id) ,
	[engage_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatcol] (
	[pbc_tnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbc_tid] [int] NULL ,
	[pbc_ownr] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbc_cnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbc_cid] [smallint] NULL ,
	[pbc_labl] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_lpos] [smallint] NULL ,
	[pbc_hdr] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_hpos] [smallint] NULL ,
	[pbc_jtfy] [smallint] NULL ,
	[pbc_mask] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_case] [smallint] NULL ,
	[pbc_hght] [smallint] NULL ,
	[pbc_wdth] [smallint] NULL ,
	[pbc_ptrn] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_bmap] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_init] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_cmnt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_edit] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_tag] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatedt] (
	[pbe_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbe_edit] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbe_type] [smallint] NULL ,
	[pbe_cntr] [int] NULL ,
	[pbe_seqn] [smallint] NOT NULL ,
	[pbe_flag] [int] NULL ,
	[pbe_work] [char] (32) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatfmt] (
	[pbf_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbf_frmt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbf_type] [smallint] NULL ,
	[pbf_cntr] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcattbl] (
	[pbt_tnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbt_tid] [int] NULL ,
	[pbt_ownr] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbd_fhgt] [smallint] NULL ,
	[pbd_fwgt] [smallint] NULL ,
	[pbd_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbd_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbd_fchr] [smallint] NULL ,
	[pbd_fptc] [smallint] NULL ,
	[pbd_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbh_fhgt] [smallint] NULL ,
	[pbh_fwgt] [smallint] NULL ,
	[pbh_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbh_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbh_fchr] [smallint] NULL ,
	[pbh_fptc] [smallint] NULL ,
	[pbh_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbl_fhgt] [smallint] NULL ,
	[pbl_fwgt] [smallint] NULL ,
	[pbl_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbl_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbl_fchr] [smallint] NULL ,
	[pbl_fptc] [smallint] NULL ,
	[pbl_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbt_cmnt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatvld] (
	[pbv_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbv_vald] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbv_type] [smallint] NULL ,
	[pbv_cntr] [int] NULL ,
	[pbv_msg] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO
上一页 12
💿 文件大小 596 K
👤 上传用户 jackjinke
📂 所属分类酒店行业
🏷️ 相关标签

#管理信息系统 #数据库 #计算机
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -