SQL
`IK` CHAR(12) UNIQUE NOT NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `tleping` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`lepingu_nr` INT (5) NOT NULL,
`algus` DATETIME (16) NOT NULL,
`lpp` DATETIME(16) NULL,
`tlised_id` INT(11) NOT NULL,
FOREIGN KEY (`tlised_id`) REFERENCES tlised(id),
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `sisselogimine` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`algusaeg` DATETIME(16) NOT NULL,
`lppaeg` DATETIME(16) NULL,
`tlised_id` INT(11) NOT NULL,
FOREIGN KEY (`tlised_id`) REFERENCES tlised(id),
PRIMARY KEY (`id`)
)
CREATE TABLE IF NOT EXISTS `kassa` (
`id` INT(4) NOT NULL AUTO_INCREMENT,
`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,
annaabi.ee 
