David-Roklem/python-project-83

CREATE TABLE IF NOT EXISTS urls (
    id bigint PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    name varchar(255) NOT NULL,
    created_at date NOT NULL
);

CREATE TABLE IF NOT EXISTS url_checks (
    id bigint PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    url_id bigint REFERENCES urls (id) ON DELETE CASCADE,
    status_code smallint,
    h1 varchar(255),
    title varchar(255),
    description varchar(255),
    created_at date NOT NULL
);