1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
CREATE TABLE "CHABANE"."ACTIVITE"
(
"ID_ACTIVITE" NUMBER(20,0) NOT NULL ENABLE,
"ID_ABONNEMENT" NUMBER(20,0) NOT NULL ENABLE,
"NOM_ACTIVITE" VARCHAR2(20 BYTE) NOT NULL ENABLE,
CONSTRAINT "ACTIVITE_PK" PRIMARY KEY ("ID_ACTIVITE") 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) TABLESPACE "USERS" ENABLE,
CONSTRAINT "ACTIVITE_CAMPAGNIE_AERIEN_FK1" FOREIGN KEY ("ID_ACTIVITE") REFERENCES "CHABANE"."CAMPAGNIE_AERIENNE" ("ID_CA") ON
DELETE CASCADE ENABLE,
CONSTRAINT "ACTIVITE_HOTEL_FK1" FOREIGN KEY ("ID_ACTIVITE") REFERENCES "CHABANE"."HOTEL" ("ID_HOTEL") ON
DELETE CASCADE ENABLE,
CONSTRAINT "ACTIVITE_LOCATION_VOITURE_FK1" FOREIGN KEY ("ID_ACTIVITE") REFERENCES "CHABANE"."LOCATION_VOITURE" ("ID_LOCATION_VOITURE") ON
DELETE CASCADE ENABLE,
CONSTRAINT "ACTIVITE_TAXI_FK1" FOREIGN KEY ("ID_ACTIVITE") REFERENCES "CHABANE"."TAXI" ("ID_TAXI") ON
DELETE CASCADE ENABLE
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
TABLESPACE "USERS" ; |
Partager