create table toode(
toodeID int primary key AUTO_INCREMENT, 
toodeNimetus varchar(50), 
toodeHind decimal(6, 2), 
v_kuupaev date, 
kas_olemas bit); 

insert into toode(toodeNimetus, toodeHind, kas_olemas, v_kuupaev) values ('piim', 1.50, 1, '2024-02-02'); 

select * from toode;

alter table tellimus add FOREIGN key (toodeID) REFERENCES toode(toodeID);

https://k.xid.ee/wp-content/uploads/2024/01/rosmanbaas.txt