CREATE TABLE
"CATENTRY" (
"CATENTRY_ID" BIGINT NOT NULL ,
"MEMBER_ID" BIGINT NOT NULL ,
"CATENTTYPE_ID" CHAR(16) NOT NULL ,
"MARKFORDELETE" INTEGER NOT NULL ,
"PARTNUMBER" VARCHAR(64) NOT NULL ,
"MFPARTNUMBER" VARCHAR(64) ,
"MFNAME" VARCHAR(64) ,
"URL" VARCHAR(254) ,
"FIELD1" INTEGER ,
"FIELD2" INTEGER ,
"FIELD3" DECIMAL(20,5) ,
"FIELD4" VARCHAR(254) ,
"FIELD5" VARCHAR(254) ,
"LASTUPDATE" TIMESTAMP ,
"OID" VARCHAR(64) ,
"ONSPECIAL" INTEGER ,
"ONAUCTION" INTEGER ,
"BUYABLE" INTEGER ,
"BASEITEM_ID" INTEGER ,
"CLASSIFGRP_ID" INTEGER ,
"ITEMSPC_ID" INTEGER ,
"STATE" INTEGER
);
|
<!ELEMENT CATENTRY EMPTY>
<!ATTLIST CATENTRY
CATENTRY_ID CDATA #REQUIRED
MEMBER_ID CDATA #REQUIRED
CATENTTYPE_ID CDATA #REQUIRED
MARKFORDELETE CDATA #REQUIRED
PARTNUMBER CDATA #REQUIRED
MFPARTNUMBER CDATA #IMPLIED
MFNAME CDATA #IMPLIED
URL CDATA #IMPLIED
FIELD1 CDATA #IMPLIED
FIELD2 CDATA #IMPLIED
FIELD3 CDATA #IMPLIED
FIELD4 CDATA #IMPLIED
FIELD5 CDATA #IMPLIED
LASTUPDATE CDATA #IMPLIED
OID CDATA #IMPLIED
ONSPECIAL CDATA #IMPLIED
ONAUCTION CDATA #IMPLIED
BUYABLE CDATA #IMPLIED
BASEITEM_ID CDATA #IMPLIED
CLASSIFGRP_ID CDATA #IMPLIED
ITEMSPC_ID CDATA #IMPLIED
STATE CDATA "1"
>
|