CREATE TABLE "public"."veri" (
"autoinc" serial NOT NULL primary key,
"geribildirimid" int4,
"ilantarihi" timestamp(0),
"kodno" int4,
"kademe" int2,
"il" varchar(20) COLLATE "default",
"ilce" varchar(20) COLLATE "default",
"sebeke" varchar(255) COLLATE "default",
"aciklama" varchar(150) COLLATE "default",
"kaynagagore" varchar(15) COLLATE "default",
"sureyegore" varchar(15) COLLATE "default",
"sebebegore" varchar(20) COLLATE "default",
"bildirimegore" varchar(15) COLLATE "default",
"baslangic" timestamp(0),
"bitis" timestamp(0),
"kesintisuresi" numeric(12,2),
"ek_iiog" int4,
"ek_iiag" int4,
"ek_idog" int4,
"ek_idag" int4,
"es_iiog" numeric(12,2),
"es_iiag" numeric(12,2),
"es_idog" numeric(12,2),
"es_idag" numeric(12,2),
"isletme" varchar(30) COLLATE "default",
"sure" timestamp(0)
);

CREATE TABLE "public"."sabitler" (
"kaynak" varchar(20) COLLATE "default" NOT NULL,
"iiag" int4,
"iiog" int4,
"idag" int4,
"idog" int4,
"toplam" int4,
CONSTRAINT "sabitler_pkey" PRIMARY KEY ("kaynak")
);

CREATE TABLE "public"."rapor_ek" (
"kaynak" varchar(20) COLLATE "default" NOT NULL,
"sebep" varchar(20) COLLATE "default" NOT NULL,
CONSTRAINT "rapor_ek_pkey" PRIMARY KEY ("kaynak", "sebep")
);