表.txt

来自「某 房 产 公 司 售 楼 管 理 系 统」· 文本 代码 · 共 7 行

CREATE TABLE "jksoft"."jktable" ("db_id" integer NOT NULL DEFAULT NULL, "dbeng" varchar(20) NOT NULL DEFAULT NULL, "dbchin" varchar(40) NOT NULL DEFAULT NULL, "dbtype" smallint NOT NULL DEFAULT NULL, "dblock" tinyint NOT NULL DEFAULT NULL, "dbvol" tinyint NOT NULL DEFAULT NULL, "dbok" smallint NOT NULL DEFAULT NULL, "vol_dbid" integer DEFAULT NULL , PRIMARY KEY ("db_id")) ;


CREATE TABLE "jksoft"."jkcolumn" ("db_id" integer NOT NULL DEFAULT NULL, "col_id" integer NOT NULL DEFAULT NULL, "col_ename" varchar(10) NOT NULL DEFAULT NULL, "col_cname" varchar(20) NOT NULL DEFAULT NULL, "col_type" char(6) NOT NULL DEFAULT NULL, "col_width" smallint DEFAULT NULL, "col_dec" smallint DEFAULT NULL, "col_list" varchar(10) DEFAULT NULL, "col_mask" varchar(20) DEFAULT NULL, "is_null" numeric(1,0) NOT NULL DEFAULT NULL, "is_primary" numeric(1,0) NOT NULL DEFAULT NULL, "is_view" numeric(1,0) NOT NULL DEFAULT NULL, "is_modify" numeric(1,0) NOT NULL DEFAULT NULL, "is_sys" numeric(1,0) NOT NULL DEFAULT NULL, "vol_colid" smallint DEFAULT NULL, "col_multi" smallint DEFAULT NULL, "is_dup" smallint DEFAULT NULL, "is_add" smallint DEFAULT NULL, "is_single" numeric(1,0) NOT NULL DEFAULT NULL , PRIMARY KEY ("db_id", "col_id")) ;


CREATE TABLE "jksoft"."jkreport" ("rep_id" integer NOT NULL DEFAULT NULL, "db_id" integer NOT NULL DEFAULT NULL, "rep_name" varchar(40) NOT NULL DEFAULT NULL, "rep_sql" long varchar(32767) NOT NULL DEFAULT NULL, "rep_style" varchar(8) NOT NULL DEFAULT NULL, "is_sys" numeric(1,0) NOT NULL DEFAULT NULL, "rep_rows" smallint DEFAULT NULL , PRIMARY KEY ("rep_id", "db_id")) ;