CREATE TABLE "Users" (
	"KID" int PRIMARY KEY,
	"KAdi" varchar(255),
	"KSoyadi" varchar(255),
	"Kmail" varchar(255),
	"Ktel" varchar(255),
	"KYSID" int,
	"KPass" varchar(255),
	FOREIGN KEY("KYSID") REFERENCES "YetkiSeviyeleri" ("YSID")
);
CREATE TABLE "Cihazlar" (
	"BID" int PRIMARY KEY,
	"BCpu" varchar(255),
	"Bram" varchar(255),
	"BHdd" varchar(255),
	"BUser" varchar(255)
);
CREATE TABLE "Talepler" (
	"TID" int PRIMARY KEY,
	"TOzet" varchar(255),
	"TDetay" varchar(255),
	"TEdenKID" int,
	"TEdilenBID" int,
	"TYetkilendirilen" varchar(255),
	"TCozum" varchar(255),
	"TDurum" varchar(255),
	FOREIGN KEY("TEdenKID") REFERENCES "Users" ("KID"),
	FOREIGN KEY("TEdilenBID") REFERENCES "Cihazlar" ("BID")
);
CREATE TABLE "YetkiSeviyeleri" (
	"YSID" int,
	"YetkiAdi" varchar(255)
);