hotel.sql

经典的酒店管理系统

SET SQL DIALECT 3;

/* CREATE DATABASE 'd:\lfsofthotel\hoteldata.gdb' PAGE_SIZE 4096

 DEFAULT CHARACTER SET  */
/* Domain definitions */
CREATE DOMAIN "DOMAIN_BH" AS VARCHAR(5);
CREATE DOMAIN "DOMAIN_BZ" AS VARCHAR(60);
CREATE DOMAIN "DOMAIN_C10" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_C12" AS VARCHAR(12);
CREATE DOMAIN "DOMAIN_C16" AS VARCHAR(16);
CREATE DOMAIN "DOMAIN_C18" AS VARCHAR(18);
CREATE DOMAIN "DOMAIN_C2" AS VARCHAR(2);
CREATE DOMAIN "DOMAIN_C20" AS VARCHAR(20);
CREATE DOMAIN "DOMAIN_C4" AS VARCHAR(4);
CREATE DOMAIN "DOMAIN_C6" AS VARCHAR(6);
CREATE DOMAIN "DOMAIN_C7" AS VARCHAR(7);
CREATE DOMAIN "DOMAIN_C8" AS VARCHAR(8);
CREATE DOMAIN "DOMAIN_CURRENCY" AS FLOAT
	 DEFAULT 0;
CREATE DOMAIN "DOMAIN_DATETIME" AS TIMESTAMP;
CREATE DOMAIN "DOMAIN_DM" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_FS" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_LOGIC" AS CHAR(1)
	 DEFAULT 'F';
CREATE DOMAIN "DOMAIN_LXM" AS VARCHAR(30);
CREATE DOMAIN "DOMAIN_MC" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_MEMO" AS BLOB SUB_TYPE 0 SEGMENT SIZE 80;
CREATE DOMAIN "DOMAIN_SJ" AS CHAR(4);
CREATE DOMAIN "DOMAIN_SL" AS INTEGER
	 DEFAULT 0;
CREATE DOMAIN "DOMAIN_SLF" AS FLOAT
	 DEFAULT 0;
CREATE DOMAIN "DOMAIN_USEBH" AS VARCHAR(12);
CREATE DOMAIN "DOMAIN_XM" AS VARCHAR(8);
CREATE DOMAIN "DOMAIN_ZT" AS CHAR(1);

/* Table: BASICFMT, Owner: SYSDBA */

CREATE TABLE "BASICFMT" 
(
  "CLASS"	"DOMAIN_BH",
  "SDATE"	"DOMAIN_C8",
  "STIME"	"DOMAIN_BH",
  "LAST"	"DOMAIN_SLF",
  "NUMBER"	"DOMAIN_C16"
);

/* Table: BH, Owner: SYSDBA */

CREATE TABLE "BH" 
(
  "D_YDBH"	"DOMAIN_USEBH",
  "D_YJBH"	"DOMAIN_USEBH",
  "D_KRBH"	"DOMAIN_USEBH",
  "D_ZDBH"	"DOMAIN_USEBH",
  "D_JZBH"	"DOMAIN_USEBH",
  "D_DCBH"	"DOMAIN_USEBH"
);

/* Table: BMDM, Owner: SYSDBA */

CREATE TABLE "BMDM" 
(
  "D_BMBH"	"DOMAIN_BH" NOT NULL,
  "D_BMMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_BMDM" PRIMARY KEY ("D_BMBH")
);

/* Table: BQJ, Owner: SYSDBA */

CREATE TABLE "BQJ" 
(
  "D_KFBH"	"DOMAIN_BH" NOT NULL,
  "D_SJFJ"	"DOMAIN_CURRENCY",
  "D_BJS"	"DOMAIN_SL",
  "D_QJS"	"DOMAIN_SL",
  "D_BJ"	"DOMAIN_BZ",
  "D_QJ"	"DOMAIN_BZ",
  "D_JJFJ"	"DOMAIN_CURRENCY",
CONSTRAINT "D_BQJ" PRIMARY KEY ("D_KFBH")
);

/* Table: CARD, Owner: SYSDBA */

CREATE TABLE "CARD" 
(
  "D_CARDID"	"DOMAIN_C6" NOT NULL,
  "D_KRXM"	"DOMAIN_XM" NOT NULL,
  "D_ZJHM"	"DOMAIN_C18",
  "D_ZE"	"DOMAIN_CURRENCY"   DEFAULT 0,
  "D_JE"	"DOMAIN_CURRENCY"   DEFAULT 0,
  "D_YE"	"DOMAIN_CURRENCY"   DEFAULT 0,
  "D_XKR"	"DOMAIN_XM",
  "D_XKRQ"	"DOMAIN_DATETIME",
  "D_XKSJ"	"DOMAIN_DATETIME",
CONSTRAINT "D_CARDID" PRIMARY KEY ("D_CARDID")
);

/* Table: CARDXF, Owner: SYSDBA */

CREATE TABLE "CARDXF" 
(
  "D_CARDID"	"DOMAIN_C6" NOT NULL,
  "D_KRXM"	"DOMAIN_XM" NOT NULL,
  "D_XFJE"	"DOMAIN_CURRENCY"   DEFAULT 0,
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_XFSJ"	"DOMAIN_DATETIME",
  "D_CZYXM"	"DOMAIN_XM"
);

/* Table: CDDM, Owner: SYSDBA */

CREATE TABLE "CDDM" 
(
  "D_CDBH"	"DOMAIN_BH" NOT NULL,
  "D_MJ"	"DOMAIN_ZT",
  "D_CDMC"	"DOMAIN_C20",
  "D_XMBH"	"DOMAIN_BH",
  "D_DJ1"	"DOMAIN_CURRENCY",
  "D_DJ2"	"DOMAIN_CURRENCY",
  "D_DJ3"	"DOMAIN_CURRENCY",
  "D_DM"	"DOMAIN_DM",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "D_CDDM" PRIMARY KEY ("D_CDBH")
);

/* Table: CTDC, Owner: SYSDBA */

CREATE TABLE "CTDC" 
(
  "D_DCBH"	"DOMAIN_USEBH" NOT NULL,
  "D_CTBH"	"DOMAIN_BH" NOT NULL,
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_DCLB"	"DOMAIN_ZT",
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_XFSJ"	"DOMAIN_DATETIME",
  "D_SJDM"	"DOMAIN_SJ",
  "D_KRSL"	"DOMAIN_SL",
  "D_YCBZ"	"DOMAIN_BZ",
  "D_KRXM"	"DOMAIN_LXM",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_JZFS"	"DOMAIN_FS",
  "D_KHBH"	"DOMAIN_BH",
  "D_XYKBH"	"DOMAIN_BH",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YHJE"	"DOMAIN_CURRENCY",
  "D_CZYXM"	"DOMAIN_XM",
  "D_YDBH"	"DOMAIN_USEBH",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "D_CTDC" PRIMARY KEY ("D_DCBH", "D_CTBH", "D_XMBH")
);

/* Table: CTDCDA, Owner: SYSDBA */

CREATE TABLE "CTDCDA" 
(
  "D_DCBH"	"DOMAIN_USEBH" NOT NULL,
  "D_CTBH"	"DOMAIN_BH" NOT NULL,
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_DCLB"	"DOMAIN_ZT",
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_XFSJ"	"DOMAIN_DATETIME",
  "D_SJDM"	"DOMAIN_SJ",
  "D_KRSL"	"DOMAIN_SL",
  "D_YCBZ"	"DOMAIN_BZ",
  "D_KRXM"	"DOMAIN_LXM",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_JZFS"	"DOMAIN_FS",
  "D_KHBH"	"DOMAIN_BH",
  "D_XYKBH"	"DOMAIN_BH",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YHJE"	"DOMAIN_CURRENCY",
  "D_CZYXM"	"DOMAIN_XM",
  "D_YDBH"	"DOMAIN_USEBH",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "CTDC1D_CTDC" PRIMARY KEY ("D_DCBH", "D_CTBH", "D_XMBH")
);

/* Table: CTDM, Owner: SYSDBA */

CREATE TABLE "CTDM" 
(
  "D_CTBH"	"DOMAIN_BH" NOT NULL,
  "D_CTLB"	"DOMAIN_C4" NOT NULL,
  "D_CTMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_CTDM" PRIMARY KEY ("D_CTBH")
);

/* Table: CTJZ, Owner: SYSDBA */

CREATE TABLE "CTJZ" 
(
  "D_XMBH"	"DOMAIN_BH",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YHJE"	"DOMAIN_CURRENCY",
  "D_BZ"	"DOMAIN_LOGIC"
);

/* Table: CTXM, Owner: SYSDBA */

CREATE TABLE "CTXM" 
(
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_XMMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_CTXM" PRIMARY KEY ("D_XMBH")
);

/* Table: CTZT, Owner: SYSDBA */

CREATE TABLE "CTZT" 
(
  "D_CTBH"	"DOMAIN_BH" NOT NULL,
  "D_CTMC"	"DOMAIN_MC" NOT NULL,
  "D_CTZT"	"DOMAIN_ZT" NOT NULL,
  "D_DCBH"	"DOMAIN_USEBH",
  "D_KRXM"	"DOMAIN_LXM",
  "D_KRSL"	"DOMAIN_SL",
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_XFSJ"	"DOMAIN_DATETIME",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
CONSTRAINT "D_CTBH" PRIMARY KEY ("D_CTBH")
);

/* Table: CWJS, Owner: SYSDBA */

CREATE TABLE "CWJS" 
(
  "D_YSRQ"	"DOMAIN_C8",
  "D_JSLX"	"DOMAIN_ZT",
  "D_RMB"	"DOMAIN_CURRENCY",
  "D_XYK"	"DOMAIN_CURRENCY",
  "D_ZP"	"DOMAIN_CURRENCY",
  "D_CZYXM"	"DOMAIN_XM",
  "D_LRRQ"	"DOMAIN_DATETIME",
  "D_LRSJ"	"DOMAIN_DATETIME"
);

/* Table: CZXM, Owner: SYSDBA */

CREATE TABLE "CZXM" 
(
  "D_CZBH"	"DOMAIN_BH" NOT NULL,
  "D_CZXM"	"DOMAIN_C20",
CONSTRAINT "D_CZXM" PRIMARY KEY ("D_CZBH")
);

/* Table: DCMX, Owner: SYSDBA */

CREATE TABLE "DCMX" 
(
  "D_HH"	"DOMAIN_USEBH" NOT NULL,
  "D_DCBH"	"DOMAIN_USEBH" NOT NULL,
  "D_CTBH"	"DOMAIN_BH" NOT NULL,
  "D_CDBH"	"DOMAIN_BH" NOT NULL,
  "D_XMBH"	"DOMAIN_BH",
  "D_CDMC"	"DOMAIN_C20",
  "D_XFSL"	"DOMAIN_SLF",
  "D_THSL"	"DOMAIN_SLF",
  "D_DJ"	"DOMAIN_CURRENCY",
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_DEL"	"DOMAIN_LOGIC",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "DCMX" PRIMARY KEY ("D_HH")
);

/* Table: DCMXDA, Owner: SYSDBA */

CREATE TABLE "DCMXDA" 
(
  "D_HH"	"DOMAIN_USEBH" NOT NULL,
  "D_DCBH"	"DOMAIN_USEBH" NOT NULL,
  "D_CTBH"	"DOMAIN_BH" NOT NULL,
  "D_CDBH"	"DOMAIN_BH" NOT NULL,
  "D_XMBH"	"DOMAIN_BH",
  "D_CDMC"	"DOMAIN_C20",
  "D_XFSL"	"DOMAIN_SLF",
  "D_THSL"	"DOMAIN_SLF",
  "D_DJ"	"DOMAIN_CURRENCY",
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_DEL"	"DOMAIN_LOGIC",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "DCMX1PRIMARYKEY1" PRIMARY KEY ("D_HH")
);

/* Table: DHF, Owner: SYSDBA */

CREATE TABLE "DHF" 
(
  "CLASS"	"DOMAIN_BH",
  "ROOM"	"DOMAIN_BH",
  "PLACE"	"DOMAIN_C12",
  "NUMBER"	"DOMAIN_C16",
  "SDATE"	"DOMAIN_C8",
  "STIME"	"DOMAIN_C6",
  "LAST"	"DOMAIN_SLF",
  "UNIT"	"DOMAIN_CURRENCY",
  "FEE"	"DOMAIN_CURRENCY",
  "ADDI_FEE"	"DOMAIN_CURRENCY",
  "SVC_FEE"	"DOMAIN_CURRENCY",
  "TOTAL"	"DOMAIN_CURRENCY",
  "FLTY"	"DOMAIN_SL"
);

/* Table: DHHM, Owner: SYSDBA */

CREATE TABLE "DHHM" 
(
  "D_DWMC"	"DOMAIN_BZ",
  "D_DHHM"	"DOMAIN_BZ",
  "D_BZ"	"DOMAIN_BZ"
);

/* Table: DQDM, Owner: SYSDBA */

CREATE TABLE "DQDM" 
(
  "D_DQBH"	"DOMAIN_BH" NOT NULL,
  "D_DQMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_DQDM" PRIMARY KEY ("D_DQBH")
);

/* Table: EWF, Owner: SYSDBA */

CREATE TABLE "EWF" 
(
  "D_JZBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KRXM"	"DOMAIN_LXM",
  "D_EWF"	"DOMAIN_CURRENCY",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
  "D_YSRQ"	"DOMAIN_C8",
CONSTRAINT "D_EWF" PRIMARY KEY ("D_JZBH")
);

/* Table: FARE, Owner: SYSDBA */

CREATE TABLE "FARE" 
(
  "PLACE"	"DOMAIN_C20",
  "CODE"	"DOMAIN_C7",
  "UNIT"	"DOMAIN_CURRENCY",
  "ABBR"	"DOMAIN_C6"
);

/* Table: FLDM, Owner: SYSDBA */

CREATE TABLE "FLDM" 
(
  "D_FLBH"	"DOMAIN_BH" NOT NULL,
  "D_FLMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_FLDM" PRIMARY KEY ("D_FLBH")
);

/* Table: FXDM, Owner: SYSDBA */

CREATE TABLE "FXDM" 
(
  "D_FXBH"	"DOMAIN_BH" NOT NULL,
  "D_FXMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_FXDM" PRIMARY KEY ("D_FXBH")
);

/* Table: GBDM, Owner: SYSDBA */

CREATE TABLE "GBDM" 
(
  "D_GBBH"	"DOMAIN_BH" NOT NULL,
  "D_GBMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_GBDM" PRIMARY KEY ("D_GBBH")
);

/* Table: HBSK, Owner: SYSDBA */

CREATE TABLE "HBSK" 
(
  "D_HBBC"	"DOMAIN_DM",
  "D_HH"	"DOMAIN_SL",
  "D_KJLX"	"DOMAIN_C20",
  "D_SFZ"	"DOMAIN_DM",
  "D_ZDZ"	"DOMAIN_DM",
  "D_SFSJ"	"DOMAIN_DATETIME",
  "D_ZDSJ"	"DOMAIN_DATETIME",
  "D_ZJZ"	"DOMAIN_DM",
  "D_DZSJ"	"DOMAIN_DATETIME"
);

/* Table: HCDM, Owner: SYSDBA */

CREATE TABLE "HCDM" 
(
  "D_HCBH"	"DOMAIN_BH" NOT NULL,
  "D_HCMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_HCDM" PRIMARY KEY ("D_HCBH")
);

/* Table: HMD, Owner: SYSDBA */

CREATE TABLE "HMD" 
(
  "D_XM"	"DOMAIN_XM" NOT NULL,
  "D_ZJHM"	"DOMAIN_C18" NOT NULL,
  "D_NL"	"DOMAIN_SL",
  "D_LRRQ"	"DOMAIN_DATETIME",
  "D_JTDZ"	"DOMAIN_BZ",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "D_HMD" PRIMARY KEY ("D_XM", "D_ZJHM")
);

/* Table: HOLIDAY, Owner: SYSDBA */

CREATE TABLE "HOLIDAY" 
(
  "HOLIDAY"	"DOMAIN_DATETIME",
  "FTIME"	"DOMAIN_DATETIME",
  "STIME"	"DOMAIN_DATETIME"
);

/* Table: INITDBF, Owner: SYSDBA */

CREATE TABLE "INITDBF" 
(
  "DBFNAME"	"DOMAIN_C18" NOT NULL,
CONSTRAINT "INITDBF" PRIMARY KEY ("DBFNAME")
);

/* Table: JFCONFIG, Owner: SYSDBA */

CREATE TABLE "JFCONFIG" 
(
  "MANAGE"	"DOMAIN_SL",
  "SUNDAY"	"DOMAIN_LOGIC",
  "FTIME"	"DOMAIN_DATETIME",
  "STIME"	"DOMAIN_DATETIME",
  "SHJF"	"DOMAIN_LOGIC",
  "SHPT"	"DOMAIN_LOGIC",
  "ADDIFEE"	"DOMAIN_CURRENCY",
  "ADDIFEE0"	"DOMAIN_CURRENCY",