La définition de type de document (DTD) de Loader mappe directement sur le schéma de base de données de WebSphere Commerce. Chaque table est un élément et chaque colonne est un attribut.
Exemple :Mappage d'un fichier DTD de Loader sur un schéma de base de données
Instructions DDL pour la table CATENTRY | DTD |
---|---|
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" > |
![]() |