1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Table MDX2_LOT_TRAITEMENT
- LOT_OID VARCHAR2 70 CHAR NOT NULL
- TRAIT_OID VARCHAR2 70 CHAR NOT NULL
CREATE TABLE "MDX2"."MDX2_LOT_TRAITEMENT" ( "LOT_OID" VARCHAR2(70 CHAR) NOT NULL , "TRAIT_OID" VARCHAR2(70 CHAR) NOT NULL , CONSTRAINT "FK52DC6F11F66CD1BC" FOREIGN KEY ("LOT_OID") REFERENCES "MDX2"."MDX2_LOT" ("LOT_OID") VALIDATE , CONSTRAINT "LOT_TRAIT_UK" UNIQUE ("TRAIT_OID", "LOT_OID") VALIDATE , CONSTRAINT "MDX2_LOT_TRAIT_FK" FOREIGN KEY ("TRAIT_OID") REFERENCES "MDX2"."MDX2_TRAITEMENT" ("TRAIT_OID") VALIDATE ) TABLESPACE "USERS" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 73728K BUFFER_POOL DEFAULT) LOGGING
Schema.Index Colonnes indexées Position de colonne
MDX2.LOT_TRAIT_IDX_1 LOT_OID 1
TRAIT_OID 2
MDX2.MDX2_LOT_IX LOT_OID 1
MDX2.MDX2_TRAIT_IX TRAIT_OID 1
CREATE UNIQUE INDEX "MDX2"."LOT_TRAIT_IDX_1" ON "MDX2"."MDX2_LOT_TRAITEMENT" ("LOT_OID", "TRAIT_OID") TABLESPACE "USERS" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 99328K BUFFER_POOL DEFAULT) LOGGING LOCAL |
Partager