hotel.sql

经典的酒店管理系统

  "XXTF"	"DOMAIN_CURRENCY",
  "SVC"	"DOMAIN_SLF",
  "SVC0"	"DOMAIN_CURRENCY",
  "GJ"	"DOMAIN_CURRENCY",
  "GN"	"DOMAIN_CURRENCY",
  "NH"	"DOMAIN_CURRENCY",
  "WXF"	"DOMAIN_CURRENCY",
  "YZF"	"DOMAIN_CURRENCY",
  "SHFEE"	"DOMAIN_CURRENCY",
  "SHUNIT"	"DOMAIN_SLF",
  "SHFEE0"	"DOMAIN_CURRENCY",
  "SHUNIT0"	"DOMAIN_SLF",
  "NHFEE"	"DOMAIN_CURRENCY",
  "NHUNIT"	"DOMAIN_SLF",
  "GNFEE"	"DOMAIN_CURRENCY",
  "GNUNIT"	"DOMAIN_SLF",
  "GJFEE"	"DOMAIN_CURRENCY",
  "GJUNIT"	"DOMAIN_SLF",
  "GATFEE"	"DOMAIN_CURRENCY",
  "GATUNIT"	"DOMAIN_SLF",
  "GNFEEYH"	"DOMAIN_CURRENCY",
  "GNYHUNIT"	"DOMAIN_SLF",
  "GJFEEYH"	"DOMAIN_CURRENCY",
  "GJYHUNIT"	"DOMAIN_SLF"
);

/* Table: JZFLTJ, Owner: SYSDBA */

CREATE TABLE "JZFLTJ" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_JZFS"	"DOMAIN_FS" NOT NULL,
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_SH"	"DOMAIN_CURRENCY",
  "D_YH"	"DOMAIN_CURRENCY",
CONSTRAINT "D_JZFLTJ" PRIMARY KEY ("D_YSRQ", "D_JZFS", "D_XMBH")
);

/* Table: KFDM, Owner: SYSDBA */

CREATE TABLE "KFDM" 
(
  "D_KFBH"	"DOMAIN_BH" NOT NULL,
  "D_KFMC"	"DOMAIN_MC" NOT NULL,
  "D_BZFJ"	"DOMAIN_CURRENCY" NOT NULL,
  "D_FXBH"	"DOMAIN_BH" NOT NULL,
  "D_LCBH"	"DOMAIN_BH" NOT NULL,
  "D_CWS"	"DOMAIN_SL" NOT NULL,
CONSTRAINT "D_KFDM" PRIMARY KEY ("D_KFBH")
);

/* Table: KFZT, Owner: SYSDBA */

CREATE TABLE "KFZT" 
(
  "D_KFBH"	"DOMAIN_BH" NOT NULL,
  "D_ZDBH"	"DOMAIN_USEBH",
  "D_KRBH"	"DOMAIN_USEBH",
  "D_YJBH"	"DOMAIN_USEBH",
  "D_SJFJ"	"DOMAIN_CURRENCY",
  "D_KFZT"	"DOMAIN_ZT",
  "D_KFBZ"	"DOMAIN_ZT",
  "D_KRSL"	"DOMAIN_SL",
  "D_DHKT"	"DOMAIN_LOGIC",
  "D_BZFJ"	"DOMAIN_CURRENCY",
  "D_CWS"	"DOMAIN_SL",
  "D_BJS"	"DOMAIN_SL",
  "D_QJS"	"DOMAIN_SL",
  "D_JJFJ"	"DOMAIN_CURRENCY",
  "D_FXBH"	"DOMAIN_BH",
  "D_LCBH"	"DOMAIN_BH",
  "D_KRXM"	"DOMAIN_LXM",
CONSTRAINT "D_KFZT" PRIMARY KEY ("D_KFBH")
);

/* Table: KHDA, Owner: SYSDBA */

CREATE TABLE "KHDA" 
(
  "D_KHBH"	"DOMAIN_BH" NOT NULL,
  "D_KHMC"	"DOMAIN_LXM" NOT NULL,
  "D_FLBH"	"DOMAIN_BH" NOT NULL,
  "D_DWDZ"	"DOMAIN_BZ",
  "D_FR"	"DOMAIN_XM",
  "D_LXDH"	"DOMAIN_C16",
  "D_JDRQ"	"DOMAIN_DATETIME",
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_KHDA" PRIMARY KEY ("D_KHBH")
);

/* Table: KRJZ, Owner: SYSDBA */

CREATE TABLE "KRJZ" 
(
  "D_JZBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_XMBH"	"DOMAIN_BH",
  "D_XFDJ"	"DOMAIN_CURRENCY",
  "D_XFSL"	"DOMAIN_SLF",
  "D_XFGG"	"DOMAIN_BH",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YJJE"	"DOMAIN_CURRENCY",
  "D_YHJE"	"DOMAIN_CURRENCY",
  "D_JZFS"	"DOMAIN_FS",
  "D_JZLX"	"DOMAIN_ZT",
  "D_KHBH"	"DOMAIN_BH",
  "D_XYKBH"	"DOMAIN_BH",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
  "D_CZYXM"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
  "D_YSRQ"	"DOMAIN_C8",
  "D_BMBH"	"DOMAIN_BH",
CONSTRAINT "D_KRJZ" PRIMARY KEY ("D_JZBH", "D_HH")
);

/* Table: KRJZDA, Owner: SYSDBA */

CREATE TABLE "KRJZDA" 
(
  "D_JZBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_XMBH"	"DOMAIN_BH",
  "D_XFDJ"	"DOMAIN_CURRENCY",
  "D_XFSL"	"DOMAIN_SLF",
  "D_XFGG"	"DOMAIN_BH",
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YJJE"	"DOMAIN_CURRENCY",
  "D_YHJE"	"DOMAIN_CURRENCY",
  "D_JZFS"	"DOMAIN_FS",
  "D_JZLX"	"DOMAIN_ZT",
  "D_KHBH"	"DOMAIN_BH",
  "D_XYKBH"	"DOMAIN_BH",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
  "D_CZYXM"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
  "D_YSRQ"	"DOMAIN_C8",
  "D_BMBH"	"DOMAIN_BH",
CONSTRAINT "KRJZ1D_KRJZ" PRIMARY KEY ("D_JZBH", "D_HH")
);

/* Table: KRLY, Owner: SYSDBA */

CREATE TABLE "KRLY" 
(
  "D_LYRQ"	"DOMAIN_DATETIME",
  "D_LYSJ"	"DOMAIN_DATETIME",
  "D_LYLX"	"DOMAIN_ZT",
  "D_KFBH"	"DOMAIN_BH",
  "D_KRXM"	"DOMAIN_XM",
  "D_LYDX"	"DOMAIN_XM",
  "D_NR"	"DOMAIN_MEMO"
);

/* Table: KRXX, Owner: SYSDBA */

CREATE TABLE "KRXX" 
(
  "D_KRBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KRXM"	"DOMAIN_LXM",
  "D_KRLX"	"DOMAIN_ZT",
  "D_DDRQ"	"DOMAIN_DATETIME",
  "D_DDSJ"	"DOMAIN_DATETIME",
  "D_LDRQ"	"DOMAIN_DATETIME",
  "D_LDSJ"	"DOMAIN_DATETIME",
  "D_YWX"	"DOMAIN_XM",
  "D_YWM"	"DOMAIN_XM",
  "D_XB"	"DOMAIN_C2",
  "D_MZBH"	"DOMAIN_BH",
  "D_DQBH"	"DOMAIN_BH",
  "D_GBBH"	"DOMAIN_BH",
  "D_NZTS"	"DOMAIN_SL",
  "D_TLSY"	"DOMAIN_C10",
  "D_ZJBH"	"DOMAIN_BH",
  "D_ZJHM"	"DOMAIN_C18",
  "D_CSNY"	"DOMAIN_DATETIME",
  "D_HCL"	"DOMAIN_C10",
  "D_HCQ"	"DOMAIN_C10",
  "D_QZBH"	"DOMAIN_BH",
  "D_QZYXQ"	"DOMAIN_DATETIME",
  "D_ZY"	"DOMAIN_C10",
  "D_LXDH"	"DOMAIN_C16",
  "D_DWMC"	"DOMAIN_BZ",
  "D_JTDZ"	"DOMAIN_BZ",
  "D_JDR"	"DOMAIN_XM",
  "D_JDDW"	"DOMAIN_BZ",
  "D_BZ"	"DOMAIN_BZ",
  "D_QDR1"	"DOMAIN_XM",
  "D_QDR2"	"DOMAIN_XM",
  "D_QDR3"	"DOMAIN_XM",
  "D_QDR4"	"DOMAIN_XM",
CONSTRAINT "D_KRXX" PRIMARY KEY ("D_KRBH")
);

/* Table: KRXXDA, Owner: SYSDBA */

CREATE TABLE "KRXXDA" 
(
  "D_KRBH"	"DOMAIN_USEBH" NOT NULL,
  "D_KRXM"	"DOMAIN_LXM",
  "D_KRLX"	"DOMAIN_ZT",
  "D_DDRQ"	"DOMAIN_DATETIME",
  "D_DDSJ"	"DOMAIN_DATETIME",
  "D_LDRQ"	"DOMAIN_DATETIME",
  "D_LDSJ"	"DOMAIN_DATETIME",
  "D_YWX"	"DOMAIN_XM",
  "D_YWM"	"DOMAIN_XM",
  "D_XB"	"DOMAIN_C2",
  "D_MZBH"	"DOMAIN_BH",
  "D_DQBH"	"DOMAIN_BH",
  "D_GBBH"	"DOMAIN_BH",
  "D_NZTS"	"DOMAIN_SL",
  "D_TLSY"	"DOMAIN_C10",
  "D_ZJBH"	"DOMAIN_BH",
  "D_ZJHM"	"DOMAIN_C18",
  "D_CSNY"	"DOMAIN_DATETIME",
  "D_HCL"	"DOMAIN_C10",
  "D_HCQ"	"DOMAIN_C10",
  "D_QZBH"	"DOMAIN_BH",
  "D_QZYXQ"	"DOMAIN_DATETIME",
  "D_ZY"	"DOMAIN_C10",
  "D_LXDH"	"DOMAIN_C16",
  "D_DWMC"	"DOMAIN_BZ",
  "D_JTDZ"	"DOMAIN_BZ",
  "D_JDR"	"DOMAIN_XM",
  "D_JDDW"	"DOMAIN_BZ",
  "D_BZ"	"DOMAIN_BZ",
  "D_QDR1"	"DOMAIN_XM",
  "D_QDR2"	"DOMAIN_XM",
  "D_QDR3"	"DOMAIN_XM",
  "D_QDR4"	"DOMAIN_XM",
CONSTRAINT "KRXX1D_KRXX" PRIMARY KEY ("D_KRBH")
);

/* Table: KRYJ, Owner: SYSDBA */

CREATE TABLE "KRYJ" 
(
  "D_YJBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_FKFS"	"DOMAIN_FS",
  "D_XYKBH"	"DOMAIN_BH",
  "D_KHBH"	"DOMAIN_BH",
  "D_YFJE"	"DOMAIN_CURRENCY",
  "D_YFRQ"	"DOMAIN_DATETIME",
  "D_YFSJ"	"DOMAIN_DATETIME",
  "D_BZ"	"DOMAIN_BZ",
CONSTRAINT "D_KRYJ" PRIMARY KEY ("D_YJBH", "D_HH")
);

/* Table: KRZD, Owner: SYSDBA */

CREATE TABLE "KRZD" 
(
  "D_ZDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_ZDLB"	"DOMAIN_ZT",
  "D_KRBH"	"DOMAIN_USEBH",
  "D_YJBH"	"DOMAIN_USEBH",
  "D_KFBH"	"DOMAIN_BH",
  "D_SJFJ"	"DOMAIN_CURRENCY",
  "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_YHJE"	"DOMAIN_CURRENCY",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
  "D_JZBZ"	"DOMAIN_ZT",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_DLR1"	"DOMAIN_XM",
  "D_DLR2"	"DOMAIN_XM",
  "D_DLR3"	"DOMAIN_XM",
  "D_DLR4"	"DOMAIN_XM",
  "D_CZYXM"	"DOMAIN_XM",
  "D_JZYXM"	"DOMAIN_XM",
  "D_TYR"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
  "D_YSRQ"	"DOMAIN_C8",
  "D_JZBH"	"DOMAIN_USEBH",
  "D_BMBH"	"DOMAIN_BH",
CONSTRAINT "D_KRZD" PRIMARY KEY ("D_ZDBH", "D_HH")
);

/* Table: KRZDCX, Owner: SYSDBA */

CREATE TABLE "KRZDCX" 
(
  "D_ZDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_ZDLB"	"DOMAIN_ZT",
  "D_KRBH"	"DOMAIN_USEBH",
  "D_YJBH"	"DOMAIN_USEBH",
  "D_KFBH"	"DOMAIN_BH",
  "D_SJFJ"	"DOMAIN_CURRENCY",
  "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_YHJE"	"DOMAIN_CURRENCY",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
  "D_JZBZ"	"DOMAIN_ZT",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_DLR1"	"DOMAIN_XM",
  "D_DLR2"	"DOMAIN_XM",
  "D_DLR3"	"DOMAIN_XM",
  "D_DLR4"	"DOMAIN_XM",
  "D_CZYXM"	"DOMAIN_XM",
  "D_JZYXM"	"DOMAIN_XM",
  "D_TYR"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
  "D_YSRQ"	"DOMAIN_C8",
  "D_JZBH"	"DOMAIN_USEBH",
  "D_BMBH"	"DOMAIN_BH",
CONSTRAINT "D_KRZDCX" PRIMARY KEY ("D_ZDBH", "D_HH")
);

/* Table: KRZDDA, Owner: SYSDBA */

CREATE TABLE "KRZDDA" 
(
  "D_ZDBH"	"DOMAIN_USEBH" NOT NULL,
  "D_HH"	"DOMAIN_SL" NOT NULL,
  "D_ZDLB"	"DOMAIN_ZT",
  "D_KRBH"	"DOMAIN_USEBH",
  "D_YJBH"	"DOMAIN_USEBH",
  "D_KFBH"	"DOMAIN_BH",
  "D_SJFJ"	"DOMAIN_CURRENCY",
  "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_YHJE"	"DOMAIN_CURRENCY",
  "D_JZRQ"	"DOMAIN_DATETIME",
  "D_JZSJ"	"DOMAIN_DATETIME",
  "D_JZBZ"	"DOMAIN_ZT",
  "D_JSBZ"	"DOMAIN_ZT",
  "D_DLR1"	"DOMAIN_XM",
  "D_DLR2"	"DOMAIN_XM",
  "D_DLR3"	"DOMAIN_XM",
  "D_DLR4"	"DOMAIN_XM",
  "D_CZYXM"	"DOMAIN_XM",
  "D_JZYXM"	"DOMAIN_XM",
  "D_TYR"	"DOMAIN_XM",
  "D_BZ"	"DOMAIN_BZ",
  "D_YSRQ"	"DOMAIN_C8",
  "D_JZBH"	"DOMAIN_USEBH",
  "D_BMBH"	"DOMAIN_BH",
CONSTRAINT "KRZD1D_KRZD" PRIMARY KEY ("D_ZDBH", "D_HH")
);

/* Table: LCDM, Owner: SYSDBA */

CREATE TABLE "LCDM" 
(
  "D_LCBH"	"DOMAIN_BH" NOT NULL,
  "D_LCMC"	"DOMAIN_MC" NOT NULL,
  "D_DM"	"DOMAIN_DM",
CONSTRAINT "D_LCDM" PRIMARY KEY ("D_LCBH")
);

/* Table: LCSK, Owner: SYSDBA */

CREATE TABLE "LCSK" 
(
  "D_LCCC"	"DOMAIN_BH",
  "D_HH"	"DOMAIN_SL",
  "D_LCLX"	"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: LCTJ, Owner: SYSDBA */

CREATE TABLE "LCTJ" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_LCBH"	"DOMAIN_BH" NOT NULL,
  "D_FJS"	"DOMAIN_SL",
  "D_CZS"	"DOMAIN_SLF",
  "D_QJS"	"DOMAIN_SL",
  "D_BJS"	"DOMAIN_SL",
  "D_JJFJ"	"DOMAIN_CURRENCY",
  "D_RCZL"	"DOMAIN_SLF",
  "D_YCZL"	"DOMAIN_SLF",
CONSTRAINT "D_LCTJ" PRIMARY KEY ("D_YSRQ", "D_LCBH")
);

/* Table: LCTJDA, Owner: SYSDBA */

CREATE TABLE "LCTJDA" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_LCBH"	"DOMAIN_BH" NOT NULL,
  "D_FJS"	"DOMAIN_SL",
  "D_CZS"	"DOMAIN_SLF",
  "D_QJS"	"DOMAIN_SL",
  "D_BJS"	"DOMAIN_SL",
  "D_JJFJ"	"DOMAIN_CURRENCY",
  "D_RCZL"	"DOMAIN_SLF",
  "D_YCZL"	"DOMAIN_SLF",
CONSTRAINT "LCTJ1D_LCTJ" PRIMARY KEY ("D_YSRQ", "D_LCBH")
);

/* Table: LKYSKZ, Owner: SYSDBA */

CREATE TABLE "LKYSKZ" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YJJE"	"DOMAIN_CURRENCY",
CONSTRAINT "D_LKYSKZ" PRIMARY KEY ("D_YSRQ", "D_XMBH")
);

/* Table: LKYSKZDA, Owner: SYSDBA */

CREATE TABLE "LKYSKZDA" 
(
  "D_YSRQ"	"DOMAIN_C8" NOT NULL,
  "D_XMBH"	"DOMAIN_BH" NOT NULL,
  "D_XFJE"	"DOMAIN_CURRENCY",
  "D_YJJE"	"DOMAIN_CURRENCY",
CONSTRAINT "LKYSKZ1D_LKYSKZ" PRIMARY KEY ("D_YSRQ", "D_XMBH")
);

/* Table: LYB, Owner: SYSDBA */

CREATE TABLE "LYB" 
(
  "D_LYBID"	"DOMAIN_SL" NOT NULL,
  "D_XM"	"DOMAIN_XM",
  "D_RQ"	"DOMAIN_DATETIME",
  "D_SJ"	"DOMAIN_DATETIME",
  "D_NR"	"DOMAIN_MEMO",