hotel.sql

经典的酒店管理系统

  "D_YDR"	"DOMAIN_MEMO",
CONSTRAINT "LYBPRIMARYKEY1" PRIMARY KEY ("D_LYBID")
);

/* Table: MZDM, Owner: SYSDBA */

CREATE TABLE "MZDM" 
(
  "D_MZBH"	"DOMAIN_BH" NOT NULL,
  "D_MZMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_MZDM" PRIMARY KEY ("D_MZBH")
);

/* Table: NEWDATA, Owner: SYSDBA */

CREATE TABLE "NEWDATA" 
(
  "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: OLDDATA, Owner: SYSDBA */

CREATE TABLE "OLDDATA" 
(
  "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: QZDM, Owner: SYSDBA */

CREATE TABLE "QZDM" 
(
  "D_QZBH"	"DOMAIN_BH" NOT NULL,
  "D_QZMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_QZDM" PRIMARY KEY ("D_QZBH")
);

/* Table: SHFARE, Owner: SYSDBA */

CREATE TABLE "SHFARE" 
(
  "PLACE"	"DOMAIN_C20",
  "CODE"	"DOMAIN_C6",
  "UNIT"	"DOMAIN_CURRENCY",
  "PRICE"	"DOMAIN_SLF",
  "JFYN"	"DOMAIN_LOGIC",
  "NHYN"	"DOMAIN_LOGIC"
);

/* Table: SIGCODE, Owner: SYSDBA */

CREATE TABLE "SIGCODE" 
(
  "CLASS"	"DOMAIN_C4",
  "CLASSNAME"	"DOMAIN_C10",
  "ROOM"	"DOMAIN_BH",
  "JFYN"	"DOMAIN_LOGIC",
  "TOTAL"	"DOMAIN_CURRENCY"
);

/* Table: SJTJ, Owner: SYSDBA */

CREATE TABLE "SJTJ" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_FPE"	"DOMAIN_CURRENCY",
  "D_LKYSK"	"DOMAIN_CURRENCY",
  "D_KHYSK"	"DOMAIN_CURRENCY",
  "D_CWSJE"	"DOMAIN_CURRENCY",
  "D_CTFPE"	"DOMAIN_CURRENCY",
  "D_CTSHE"	"DOMAIN_CURRENCY",
  "D_CTSJE"	"DOMAIN_CURRENCY",
  "D_YJKSH"	"DOMAIN_CURRENCY",
  "D_YJKSJ"	"DOMAIN_CURRENCY",
  "D_YJKYE"	"DOMAIN_CURRENCY",
  "D_YJKKC"	"DOMAIN_CURRENCY",
  "D_NBFF"	"DOMAIN_CURRENCY",
  "D_WBFF"	"DOMAIN_CURRENCY",
  "D_BQF"	"DOMAIN_CURRENCY",
  "D_RPJJ"	"DOMAIN_CURRENCY",
  "D_YPJJ"	"DOMAIN_CURRENCY",
  "D_RPJCZL"	"DOMAIN_SLF",
  "D_YPJCZL"	"DOMAIN_SLF",
  "D_DBF"	"DOMAIN_CURRENCY",
CONSTRAINT "D_SJTJ" PRIMARY KEY ("D_YSRQ")
);

/* Table: XMDM, Owner: SYSDBA */

CREATE TABLE "XMDM" 
(
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_XMMC"	"DOMAIN_MC" NOT NULL,
  "D_XFBZ"	"DOMAIN_LOGIC",
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_XMDM" PRIMARY KEY ("D_XMBH")
);

/* Table: XXDC, Owner: SYSDBA */

CREATE TABLE "XXDC" 
(
  "D_KRBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KFBH"	"DOMAIN_BH",
  "D_DDRQ"	"DOMAIN_C8",
  "D_LDRQ"	"DOMAIN_C8",
  "D_KRXM"	"DOMAIN_XM",
  "D_XB"	"DOMAIN_C2",
  "D_CSNY"	"DOMAIN_C8",
  "D_MZ"	"DOMAIN_C10",
  "D_JG"	"DOMAIN_C10",
  "D_GZDW"	"DOMAIN_BZ",
  "D_ZY"	"DOMAIN_C10",
  "D_JTDZ"	"DOMAIN_BZ",
  "D_ZJLX"	"DOMAIN_C10",
  "D_ZJHM"	"DOMAIN_C18",
CONSTRAINT "D_XXDC" PRIMARY KEY ("D_KRBH")
);

/* Table: XYK, Owner: SYSDBA */

CREATE TABLE "XYK" 
(
  "D_XYKBH"	"DOMAIN_BH" NOT NULL,
  "D_XYKMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_XYK" PRIMARY KEY ("D_XYKBH")
);

/* Table: YDCY, Owner: SYSDBA */

CREATE TABLE "YDCY" 
(
  "D_YDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_CTBH"	"DOMAIN_BH" NOT NULL,
  "D_CTMC"	"DOMAIN_MC",
  "D_KRBH"	"DOMAIN_USEBH",
  "D_KRXM"	"DOMAIN_LXM",
  "D_YDRQ"	"DOMAIN_DATETIME",
  "D_SYRQ"	"DOMAIN_DATETIME",
  "D_SYSJ"	"DOMAIN_DATETIME",
  "D_SJDM"	"DOMAIN_SJ",
  "D_YCBZ"	"DOMAIN_BZ",
  "D_YCLX"	"DOMAIN_SL",
  "D_RS"	"DOMAIN_SL",
  "D_DJ"	"DOMAIN_CURRENCY",
  "D_XFSL"	"DOMAIN_SLF",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YDBZ"	"DOMAIN_ZT",
  "D_RZBZ"	"DOMAIN_LOGIC",
  "D_KTBZ"	"DOMAIN_LOGIC",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_BZ"	"DOMAIN_MEMO",
  "D_CZYXM"	"DOMAIN_XM",
CONSTRAINT "D_YDCY" PRIMARY KEY ("D_YDBH", "D_CTBH")
);

/* Table: YDHC, Owner: SYSDBA */

CREATE TABLE "YDHC" 
(
  "D_YDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KRBH"	"DOMAIN_USEBH",
  "D_KRXM"	"DOMAIN_LXM",
  "D_YDRQ"	"DOMAIN_DATETIME",
  "D_SYRQ"	"DOMAIN_DATETIME",
  "D_SYSJ"	"DOMAIN_DATETIME",
  "D_SJDM"	"DOMAIN_SJ",
  "D_HCBH"	"DOMAIN_BH",
  "D_HCMC"	"DOMAIN_MC",
  "D_HCZJ"	"DOMAIN_CURRENCY",
  "D_HCRS"	"DOMAIN_SL",
  "D_HCRS1"	"DOMAIN_SL",
  "D_HFSL"	"DOMAIN_SLF",
  "D_HFJE"	"DOMAIN_CURRENCY",
  "D_HFBZ"	"DOMAIN_BZ",
  "D_XHSL"	"DOMAIN_SLF",
  "D_XHJE"	"DOMAIN_CURRENCY",
  "D_XHBZ"	"DOMAIN_BZ",
  "D_SGSL"	"DOMAIN_SLF",
  "D_SGJE"	"DOMAIN_CURRENCY",
  "D_SGBZ"	"DOMAIN_BZ",
  "D_QTJE"	"DOMAIN_CURRENCY",
  "D_QTBZ"	"DOMAIN_BZ",
  "D_HTSL"	"DOMAIN_SLF",
  "D_HTBZ"	"DOMAIN_BZ",
  "D_BZ"	"DOMAIN_MEMO",
  "D_RZBZ"	"DOMAIN_LOGIC",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_CZYXM"	"DOMAIN_XM",
CONSTRAINT "D_YDHC" PRIMARY KEY ("D_YDBH")
);

/* Table: YDKF, Owner: SYSDBA */

CREATE TABLE "YDKF" 
(
  "D_YDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KFBH"	"DOMAIN_BH" NOT NULL,
  "D_KRBH"	"DOMAIN_USEBH",
  "D_KRXM"	"DOMAIN_LXM",
  "D_YDRQ"	"DOMAIN_DATETIME",
  "D_DDRQ"	"DOMAIN_DATETIME",
  "D_DDSJ"	"DOMAIN_DATETIME",
  "D_LDRQ"	"DOMAIN_DATETIME",
  "D_LDSJ"	"DOMAIN_DATETIME",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YDBZ"	"DOMAIN_ZT",
  "D_RZBZ"	"DOMAIN_LOGIC",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_CZYXM"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "D_YDKF" PRIMARY KEY ("D_YDBH", "D_KFBH")
);

/* Table: YDXX, Owner: SYSDBA */

CREATE TABLE "YDXX" 
(
  "D_KRBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KRXM"	"DOMAIN_LXM",
  "D_FKFS"	"DOMAIN_FS",
  "D_XYKBH"	"DOMAIN_BH",
  "D_KHBH"	"DOMAIN_BH",
  "D_YFJE"	"DOMAIN_CURRENCY",
  "D_DWMC"	"DOMAIN_BZ",
  "D_LXDH"	"DOMAIN_C16",
  "D_LXR"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
  "D_CZYXM"	"DOMAIN_XM",
CONSTRAINT "D_YDXX" PRIMARY KEY ("D_KRBH")
);

/* Table: YGDA, Owner: SYSDBA */

CREATE TABLE "YGDA" 
(
  "D_YGBH"	"DOMAIN_BH" NOT NULL,
  "D_YGXM"	"DOMAIN_XM" NOT NULL,
  "D_BMBH"	"DOMAIN_BH" NOT NULL,
  "D_KL"	"DOMAIN_C8",
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_YGBH" PRIMARY KEY ("D_YGBH")
);

/* Table: YGKF, Owner: SYSDBA */

CREATE TABLE "YGKF" 
(
  "D_CZYXM"	"DOMAIN_XM",
  "D_KFRQ"	"DOMAIN_DATETIME",
  "D_KFSJ"	"DOMAIN_DATETIME",
  "D_KFBH"	"DOMAIN_BH",
  "D_KRXM"	"DOMAIN_LXM",
  "D_SJFJ"	"DOMAIN_CURRENCY"
);

/* Table: YGQX, Owner: SYSDBA */

CREATE TABLE "YGQX" 
(
  "D_YGBH"	"DOMAIN_BH" NOT NULL,
  "D_CZBH"	"DOMAIN_BH" NOT NULL,
  "D_CZXM"	"DOMAIN_C20",
  "D_QX"	"DOMAIN_LOGIC",
CONSTRAINT "D_YGQX" PRIMARY KEY ("D_YGBH", "D_CZBH")
);

/* Table: YJK, Owner: SYSDBA */

CREATE TABLE "YJK" 
(
  "D_YSRQ"	"DOMAIN_C8",
  "D_RMB"	"DOMAIN_CURRENCY",
  "D_XYK"	"DOMAIN_CURRENCY",
  "D_ZP"	"DOMAIN_CURRENCY",
  "D_CZYXM"	"DOMAIN_XM",
  "D_YJRQ"	"DOMAIN_DATETIME",
  "D_YJSJ"	"DOMAIN_DATETIME",
  "D_YJLX"	"DOMAIN_ZT",
  "D_BZ"	"DOMAIN_BZ"
);

/* Table: YSK, Owner: SYSDBA */

CREATE TABLE "YSK" 
(
  "D_KHBH"	"DOMAIN_BH" NOT NULL,
  "D_ZDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_XMBH"	"DOMAIN_BH",
  "D_XFDJ"	"DOMAIN_CURRENCY",
  "D_XFSL"	"DOMAIN_SLF",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_XFSJ"	"DOMAIN_DATETIME",
  "D_CZYXM"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "D_YSK" PRIMARY KEY ("D_KHBH", "D_ZDBH", "D_HH")
);

/* Table: YSKJZ, Owner: SYSDBA */

CREATE TABLE "YSKJZ" 
(
  "D_JZBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KHBH"	"DOMAIN_BH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_XMBH"	"DOMAIN_BH",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YJJE"	"DOMAIN_CURRENCY",
  "D_YHJE"	"DOMAIN_CURRENCY",
  "D_JZJE"	"DOMAIN_CURRENCY",
  "D_JZFS"	"DOMAIN_FS",
  "D_XYKBH"	"DOMAIN_BH",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
  "D_CZYXM"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "D_YSKJZ" PRIMARY KEY ("D_JZBH", "D_KHBH", "D_HH")
);

/* Table: YSKJZLS, Owner: SYSDBA */

CREATE TABLE "YSKJZLS" 
(
  "D_KHBH"	"DOMAIN_BH" NOT NULL,
  "D_ZDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_XMBH"	"DOMAIN_BH",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YJJE"	"DOMAIN_CURRENCY",
  "D_YHJE"	"DOMAIN_CURRENCY",
  "D_JZJE"	"DOMAIN_CURRENCY",
  "D_XFRQ"	"DOMAIN_DATETIME",
  "D_XFSJ"	"DOMAIN_DATETIME",
  "D_JZBZ"	"DOMAIN_LOGIC",
CONSTRAINT "D_YSKJZLS" PRIMARY KEY ("D_KHBH", "D_ZDBH", "D_HH")
);

/* Table: YSSJ, Owner: SYSDBA */

CREATE TABLE "YSSJ" 
(
  "D_YSSJ"	"DOMAIN_C10" NOT NULL,
CONSTRAINT "YSSJPRIMARYKEY1" PRIMARY KEY ("D_YSSJ")
);

/* Table: YYTJ, Owner: SYSDBA */

CREATE TABLE "YYTJ" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_JRYY"	"DOMAIN_CURRENCY",
  "D_JRSH"	"DOMAIN_CURRENCY",
  "D_JRYH"	"DOMAIN_CURRENCY",
  "D_BYYY"	"DOMAIN_CURRENCY",
  "D_BYYH"	"DOMAIN_CURRENCY",
  "D_LJYY"	"DOMAIN_CURRENCY",
  "D_LJYH"	"DOMAIN_CURRENCY",
  "D_LJSH"	"DOMAIN_CURRENCY",
  "D_LJYS"	"DOMAIN_CURRENCY",
  "D_ZRBYYY"	"DOMAIN_CURRENCY",
  "D_ZRBYYH"	"DOMAIN_CURRENCY",
  "D_ZRLJYY"	"DOMAIN_CURRENCY",
  "D_ZRLJYH"	"DOMAIN_CURRENCY",
  "D_ZRLJSH"	"DOMAIN_CURRENCY",
  "D_ZRLJYS"	"DOMAIN_CURRENCY",
  "D_SYTQB"	"DOMAIN_SLF",
CONSTRAINT "D_YYTJ" PRIMARY KEY ("D_YSRQ", "D_XMBH")
);

/* Table: YYTJDA, Owner: SYSDBA */

CREATE TABLE "YYTJDA" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_JRYY"	"DOMAIN_CURRENCY",
  "D_JRSH"	"DOMAIN_CURRENCY",
  "D_JRYH"	"DOMAIN_CURRENCY",
  "D_BYYY"	"DOMAIN_CURRENCY",
  "D_BYYH"	"DOMAIN_CURRENCY",
  "D_LJYY"	"DOMAIN_CURRENCY",
  "D_LJYH"	"DOMAIN_CURRENCY",
  "D_LJSH"	"DOMAIN_CURRENCY",
  "D_LJYS"	"DOMAIN_CURRENCY",
  "D_ZRBYYY"	"DOMAIN_CURRENCY",
  "D_ZRBYYH"	"DOMAIN_CURRENCY",
  "D_ZRLJYY"	"DOMAIN_CURRENCY",
  "D_ZRLJYH"	"DOMAIN_CURRENCY",
  "D_ZRLJSH"	"DOMAIN_CURRENCY",
  "D_ZRLJYS"	"DOMAIN_CURRENCY",
  "D_SYTQB"	"DOMAIN_SLF",
CONSTRAINT "YYTJ1D_YYTJ" PRIMARY KEY ("D_YSRQ", "D_XMBH")
);

/* Table: ZJDM, Owner: SYSDBA */

CREATE TABLE "ZJDM" 
(
  "D_ZJBH"	"DOMAIN_BH" NOT NULL,
  "D_ZJMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_ZJDM" PRIMARY KEY ("D_ZJBH")
);

/*  Index definitions for all user tables */

CREATE INDEX "KFZT" ON "KFZT"("D_LCBH", "D_KFBH");
CREATE INDEX "YSKJZLSXFRQXMBH" ON "YSKJZLS"("D_XFRQ", "D_XMBH");


/* Grant Roles for this database */


/* Grant permissions for this database */