--------------------------------------------------------
--  File created - piątek-grudzień-06-2019
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table HU_HURTOWNIA_CENTRALNA
--------------------------------------------------------

  CREATE TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA"
   (	"FK_ID_PACZKA" NUMBER,
	"FK_ID_REGION_NADANIA" NUMBER,
	"FK_ID_REGION_DOSTAWY" NUMBER,
	"FK_ID_DATA_NADANIA" NUMBER,
	"FK_ID_DATA_DOSTARCZENIA" NUMBER,
	"FK_ID_DATA_DOSTARCZENIA_PLAN" NUMBER,
	"FK_ID_DATA_OPUSZCZENIA_MK" NUMBER,
	"SR_PRZYGOTWANIA_PACZKI" NUMBER,
	"CZAS_OD_MK_DO_OBIORCY" NUMBER,
	"SR_CZAS_DOSTARCZENIA_PACZKI" NUMBER,
	"PR_UDANYCH_PROB_DORECZENIA" NUMBER,
	"SUM_WARTOSC_OPLAT" NUMBER,
	"SR_OPLATA_ZA_PACZKE" NUMBER,
	"ILOSC_ZREALIZOWANYCH_PACZEK" NUMBER,
	"PROCENT_ZAGUBIONYCH_PACZEK" NUMBER,
	"ILOSC_REKLAMOWANYCH_PRZESYLEK" NUMBER,
	"SUM_PRZESYLEK_DOST_PO_TERMINIE" NUMBER,
	"IL_PRZESYLEK_Z_REGIONU" NUMBER,
	"IL_PRZESYLEK_DOST_DO_REGIONU" NUMBER,
	"SR_ILOSC_PRZES_DOST_PRZEZ_KUR" NUMBER,
	"SR_OBJETOSC_PACZKI" NUMBER,
	"SR_WAGA_PACZKI" NUMBER
   ) SEGMENT CREATION IMMEDIATE
  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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  Ref Constraints for Table HU_HURTOWNIA_CENTRALNA
--------------------------------------------------------

  ALTER TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA" ADD CONSTRAINT "FK_1" FOREIGN KEY ("FK_ID_PACZKA")
	  REFERENCES "HURTOWNIA"."HU_PACZKA" ("ID_PACZKA") ENABLE;
  ALTER TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA" ADD CONSTRAINT "FK_2" FOREIGN KEY ("FK_ID_REGION_NADANIA")
	  REFERENCES "HURTOWNIA"."HU_REGION" ("ID_REGION") ENABLE;
  ALTER TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA" ADD CONSTRAINT "FK_3" FOREIGN KEY ("FK_ID_REGION_DOSTAWY")
	  REFERENCES "HURTOWNIA"."HU_REGION" ("ID_REGION") ENABLE;
  ALTER TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA" ADD CONSTRAINT "FK_4" FOREIGN KEY ("FK_ID_DATA_NADANIA")
	  REFERENCES "HURTOWNIA"."HU_DATA" ("ID_DATA") ENABLE;
  ALTER TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA" ADD CONSTRAINT "FK_5" FOREIGN KEY ("FK_ID_DATA_DOSTARCZENIA")
	  REFERENCES "HURTOWNIA"."HU_DATA" ("ID_DATA") ENABLE;
  ALTER TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA" ADD CONSTRAINT "FK_6" FOREIGN KEY ("FK_ID_DATA_DOSTARCZENIA_PLAN")
	  REFERENCES "HURTOWNIA"."HU_DATA" ("ID_DATA") ENABLE;
  ALTER TABLE "HURTOWNIA"."HU_HURTOWNIA_CENTRALNA" ADD CONSTRAINT "FK_7" FOREIGN KEY ("FK_ID_DATA_OPUSZCZENIA_MK")
	  REFERENCES "HURTOWNIA"."HU_DATA" ("ID_DATA") ENABLE;