By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE tABLe users (id BIGINT NOt NULL auto_increment primary key)
CREATE TABLE projects(
projectId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20) NOT NULL,
description VARCHAR(250),
others INT NOT NULL,
notes TEXT,
userId BIGINT NOT NULL,
CONSTRAINT fk_userId FOREIGN KEY (userId) REFERENCES users(id)
);
CREATE TABLE about(
pfp longblob,
bio VARCHAR(250) NOT NULL DEFAULT " ",
friends INT NOT NULL DEFAULT 0,
followers INT NOT NULL DEFAULT 0,
id BIGINT NOT NULL,
CONSTRAINT fk_id FOREIGN KEY (id) REFERENCES users(id)
);