By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE users (
id NUMBER(10,0) GENERATED ALWAYS AS IDENTITY PRIMARY KEY
);
CREATE TABLE products (
id NUMBER(10,0) GENERATED ALWAYS AS IDENTITY PRIMARY KEY
);
create table downloads (
id NUMBER(10,0)
GENERATED ALWAYS AS IDENTITY
CONSTRAINT downloads__id__pk PRIMARY KEY,
User_id NUMBER(10,0)
CONSTRAINT downloads__user_id__fk REFERENCES users (id),
datetime DATE
CONSTRAINT downloads__datetime__nn NOT NULL,
File_name VARCHAR2(300)
CONSTRAINT downloads__file_name__nn NOT NULL,
Product_id NUMBER(10,0)
CONSTRAINT downloads__product_id__FK REFERENCES Products (id)
);