101.sql

来自「酒店的管理」· SQL 代码 · 共 5 行

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 ("用户名")) ;