17,377
社区成员
发帖
与我相关
我的任务
分享
--是多这个吧
CREATE TABLE "EQINFO"
( "DIVNUM" NUMBER NOT NULL ENABLE,
"DIVNAME" CHAR(100) NOT NULL ENABLE,
"ADDNUM" CHAR(100) NOT NULL ENABLE,
"DIVTYPE" CHAR(100) NOT NULL ENABLE,
"DIVMODEL" CHAR(100) NOT NULL ENABLE,
"SUPPELS" CHAR(100) NOT NULL ENABLE,
"DIVSTATUS" CHAR(100) NOT NULL ENABLE,
"DIVIMAGE" BLOB NOT NULL ENABLE,
"MOVABLE" CHAR(100) NOT NULL ENABLE,
)
CREATE TABLE "LOCINFO"
( "ADDNUM" CHAR(100) NOT NULL ENABLE,
"ADDNAME" CHAR(100) NOT NULL ENABLE,
)
CREATE TABLE "EQHIERARCHY"
( "DIVNUM" NUMBER NOT NULL ENABLE,
"FDIVNUM" NUMBER NOT NULL ENABLE,
)
CREATE TABLE "LOCHIERARCHY"
( "ADDNUM" CHAR(100) NOT NULL ENABLE,
"FADDNUM" CHAR(100) NOT NULL ENABLE,
);
CREATE TABLE "EQINFO"
( "DIVNUM" NUMBER NOT NULL ENABLE,
"DIVNAME" CHAR(100) NOT NULL ENABLE,
"ADDNUM" CHAR(100) NOT NULL ENABLE,
"DIVTYPE" CHAR(100) NOT NULL ENABLE,
"DIVMODEL" CHAR(100) NOT NULL ENABLE,
"SUPPELS" CHAR(100) NOT NULL ENABLE,
"DIVSTATUS" CHAR(100) NOT NULL ENABLE,
"DIVIMAGE" BLOB NOT NULL ENABLE,
"MOVABLE" CHAR(100) NOT NULL ENABLE, -- 我个,号
)