Mission 4 / 8
foreign key · references · date
The medicines have arrived. Each belongs to a category. Instead of repeating the category name every time, the medicine table stores just its number. That number is a foreign key.
Create the table dori: dori_id — bigint generated always as identity primary key; dori_nomi — varchar(255) not null; kategoriya_id — bigint not null; narx — numeric(10,2) not null; yaroqlilik_muddati — date not null. After the columns, on the last line, write the foreign key: foreign key (kategoriya_id) references kategoriya (kategoriya_id).