酒店住宿管理系统数据库是用于存储和管理客户信息、房间预订情况及酒店运营相关数据的重要工具。它确保了高效准确的服务体验与业务操作。
宾馆管理系统数据库文件
-- 服务器版本 5.0.45-community-nt
*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *;
*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *;
*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *;
*!40101 SET NAMES utf8 *;
*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 *;
*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 *;
*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO *;
--
-- 创建数据库 neohotel
--
-- CREATE DATABASE IF NOT EXISTS neohotel;
USE neohotel;
--
-- 定义表 `nhbalancement`
--
DROP TABLE IF EXISTS `nhbalancement`;
CREATE TABLE `nhbalancement` (
`BMID` varchar(32) NOT NULL,
`BMCHECKINORDERID` varchar(32) NOT NULL,
`BMGUESTID` varchar(32) default NULL,
`BMTYPE` varchar(16) NOT NULL,
`BMTOTALRATE` decimal(14,2) NOT NULL,
`BMPAIDMONEY` decimal(14,2) NOT NULL,
`BMRECEIVMONEY` decimal(14,2) NOT NULL,
`BMCREATETIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`BMOPERATOR` varchar(20) NOT NULL,
`BMPAYMENTMODEL` varchar(16) NOT NULL,
`BMREMARK` varchar(100) default NULL,
PRIMARY KEY (`BMID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 导入数据到表 `nhbalancement`
--
*!40000 ALTER TABLE `nhbalancement` DISABLE KEYS *;
INSERT INTO `nhbalancement` (`BMID`,`BMCHECKINORDERID`,`BMGUESTID`,`BMTYPE`,`BMTOTALRATE`,`BMPAIDMONEY`,`BMRECEIVMONEY`,`BMCREATETIME`,`BMOPERATOR`,`BMPAYMENTMODEL`,`BMREMARK`) VALUES
(402881e51a448696011a4489783f0003,402881e51a448696011a4489373e0001,402881e51a39c232011a39da4d3e0005,结单,320.00,1000.00,200.00,2008-06-01 22:30:37,admin,现金,remark),
(402881e51a53efae011a53f874550004,402881e51a53efae011a53f77fc40001,402881e51a39c232011a39da4d3e0005,结单,350.00,0.00,0.00,2008-06-04 22:26:09,admin,现金,fdsafdsa);
*!40000 ALTER TABLE `nhbalancement` ENABLE KEYS *;
--
-- 定义表 `nhbaseinfo`
--