Andmebaasiskeem

Minu skeem:

CREATE TABLE [Hoidla] (
[hoidla_id] int,
[asukoht] varchar(20),
[maht] varchar(30),
PRIMARY KEY ([hoidla_id])
);

CREATE TABLE [Tuup] (
[tuup_id] int,
[nimi] varchar(20),
[kirjeldus] varchar(20),
PRIMARY KEY ([tuup_id])
);

CREATE TABLE [Tarnija] (
[tarnija_id] int,
[nimi] varchar(30),
[telefon] varchar(13),
PRIMARY KEY ([tarnija_id])
);

CREATE TABLE [Vili] (
[vilja_id] int,
[nimi] varchar(20),
[tuup_id] int,
[hind_uhiku_kohta] decimal(5,2),
[tarnija_id] int,
PRIMARY KEY ([vilja_id]),
CONSTRAINT [FK_Vili.tuup_id]
FOREIGN KEY ([tuup_id])
REFERENCES Tuup,
CONSTRAINT [FK_Vili.tarnija_id]
FOREIGN KEY ([tarnija_id])
REFERENCES Tarnija
);

CREATE TABLE [Varu] (
[varu_id] int,
[vilja_id] int,
[hoidla_id] int,
[kogus] varchar(30),
[tarne_kuupaev] varchar(30),
PRIMARY KEY ([varu_id]),
CONSTRAINT [FK_Varu.hoidla_id]
FOREIGN KEY ([hoidla_id])
REFERENCES Hoidla,
CONSTRAINT [FK_Varu.vilja_id]
FOREIGN KEY ([vilja_id])
REFERENCES Vili
);