101.sql

酒店的管理

CREATE TABLE "dba"."fjxx_tab" ("fjh" numeric(10,0) NOT NULL DEFAULT NULL, "ft" char(10) DEFAULT NULL, "jg" numeric(5,0) DEFAULT NULL, "pz" char(2) DEFAULT NULL, "bz" char(20) DEFAULT NULL , PRIMARY KEY ("fjh")) ;
CREATE TABLE "dba"."yuangong" ("gzhm" numeric(5,0) NOT NULL DEFAULT NULL, "name" char(20) NOT NULL DEFAULT NULL, "telephone" numeric(6,0) NOT NULL DEFAULT NULL, "sex" char(4) NOT NULL DEFAULT NULL, "address" char(4) NOT NULL DEFAULT NULL , PRIMARY KEY ("gzhm")) ;
CREATE TABLE "dba"."yuyue" ("name" char(10) NOT NULL DEFAULT NULL, "sex" char(10) NOT NULL DEFAULT NULL, "telephone" numeric(8,0) NOT NULL DEFAULT NULL, "jg" numeric(8,0) NOT NULL DEFAULT NULL, "ytqi" numeric(8,0) NOT NULL DEFAULT NULL, "ytish" numeric(8,0) NOT NULL DEFAULT NULL, "yfujin" integer NOT NULL DEFAULT NULL , PRIMARY KEY ("name")) ;
CREATE TABLE "dba"."操作员表" ("用户名" char(32) NOT NULL DEFAULT NULL, "密码" char(10) NOT NULL DEFAULT NULL , PRIMARY KEY ("用户名")) ;