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)
);