in

ERROR 1072 (42000): Key column ‘texto_id’ doesn’t exist in table MariaDB [blog1]>


ERROR 1072 (42000): Key column ‘texto_id’ doesn’t exist in table
MariaDB [blog1]>

I NEET TO FIX THIS ERROR THAT DOESNT MAKE ANY SENSE AT ALL

CREATE TABLE usuario(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nome VARCHAR(200) NOT NULL,
    email VARCHAR(200) NOT NULL,
    senha CHAR(200) NOT NULL
);

CREATE TABLE texto(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    titulo VARCHAR(200) NOT NULL,
    corpo TEXT NOT NULL,
    usuario_id INT NOT NULL,
    taxa_calorica_basal INT NOT NULL,
    _data DATE,
    likes INT NULL,
    FOREIGN KEY(usuario_id) REFERENCES usuario(id)
);
CREATE TABLE likes(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    checkin int null,
    FOREIGN KEY(texto_id) REFERENCES texto(id),
    FOREIGN KEY(usuario_id) REFERENCES usuario(id)
);



Source: https://stackoverflow.com/questions/70718522/error-1072-42000-key-column-texto-id-doesnt-exist-in-table-mariadb-blog1

a graphical image annotation tool to generate ground plane masks for a 3D object reconstruction system

Nesting MDX content