SQL
`kassa_nr` (4) NOT NULL,
`sisselogimine_id`INT(11) NOT NULL,
FOREIGN KEY (`sisselogimine_id`) REFERENCES sisselogimine(id),
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `klient` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`eesnimi` CHAR(28) NOT NULL,
`perenimi` CHAR(28) NOT NULL,
`IK` CHAR (12) UNIQUE NOT NULL,
`ettevtte_nimi` VARCHAR(28) NULL,
`Aadress`VARCHAR(40) NOT NULL,
`Tel_nr` VARCHAR(20) NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `maksevimalus` (
`id` INT(4) NOT NULL AUTO_INCREMENT,
`maksevimaluse_tp` VARCHAR(30) UNIQUE NOT NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `Tellimus` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`tellimuse_nr` INT(25) NOT NULL,
`tellitud_kaup` VARCHAR(30) NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `soodustused` (
`id` INT(4) NOT NULL AUTO_INCREMENT,
`soodustuse_tp` VAR CHAR(30) UNIQUE NOT NULL,
`soodustuse protsent`INT(3) NOT NULL,
PRIMARY KEY (`id`)
)
annaabi.ee 
