ivan.petrovic Ivan Petrovic HO, ProCredit Bank ar-bg-ar
Član broj: 135228 Poruke: 48 *.vozd.net.
|
prodajnaCena CREATE TABLE `prodajnacena` (
`prodCena` float(64,2) NOT NULL,
`bi` int(11) NOT NULL,
`ean` varchar(255) NOT NULL,
`kolicina` int(11) NOT NULL,
PRIMARY KEY (`bi`,`ean`),
KEY `TC_ProdajnaCena18` (`bi`),
KEY `TC_ProdajnaCena19` (`ean`),
CONSTRAINT `FK_ProdajnaCena14` FOREIGN KEY (`ean`) REFERENCES `artikal` (`ean`),
CONSTRAINT `FK_ProdajnaCena13` FOREIGN KEY (`bi`) REFERENCES `racun` (`bi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
racun CREATE TABLE `racun` (
`bi` int(11) NOT NULL,
`datum` datetime NOT NULL,
`suma` float(64,2) NOT NULL,
`placeno` float(64,2) NOT NULL,
`storno` bit(1) NOT NULL,
`id` varchar(255) NOT NULL,
`Prodavci_id` int(11) NOT NULL,
PRIMARY KEY (`bi`),
KEY `TC_Racun21` (`Prodavci_id`),
KEY `TC_Racun17` (`id`),
CONSTRAINT `FK_Racun15` FOREIGN KEY (`Prodavci_id`) REFERENCES `prodavci` (`id`),
CONSTRAINT `FK_Racun12` FOREIGN KEY (`id`) REFERENCES `kupac` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|