1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
create table TYP_OBJET (CDE VARCHAR2(20 BYTE) primary key);
create table TY_TYPO (NOM_TYPO VARCHAR2(20 BYTE) primary key);
CREATE TABLE "ATTRIBUT"
( "CHAMP1" VARCHAR2(10 BYTE) NOT NULL ENABLE,
"CHAMP2" VARCHAR2(10 BYTE) NOT NULL ENABLE,
"CHAMP3" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"ORDRE" NUMBER(20,0) NOT NULL ENABLE,
"LG_MAX" NUMBER(4,0) NOT NULL ENABLE,
"LG_MIN" NUMBER(4,0),
"B_OBLIG" NUMBER(1,0) NOT NULL ENABLE,
"LIBELLE" VARCHAR2(100 BYTE) NOT NULL ENABLE,
CONSTRAINT "PK_ATTRIBUT" PRIMARY KEY ("CHAMP1", "CHAMP2")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
ENABLE,
CONSTRAINT "CONTRAINTE1" FOREIGN KEY ("CHAMP3")
REFERENCES TYP_OBJET ("CDE") ENABLE,
CONSTRAINT "CONTRAINTE2" FOREIGN KEY ("CHAMP1")
REFERENCES TY_TYPO ("NOM_TYPO") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) ;
CREATE INDEX "CONTRAINTE2" ON "ATTRIBUT" ("CHAMP1")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT); |
Partager