Database Project

Scan SQL Script

USE Webatooldb;

CREATE TABLE Scans(
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    url VARCHAR(255) NOT NULL UNIQUE,
    createdDate DATE DEFAULT (CURRENT_DATE)
);

INSERT INTO Scans(url)  values('https://raptei.vercel.app/');

Scan Details SQL Script

USE Webatooldb;

CREATE TABLE ScanDetails(
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    result JSON NULL,
    createdDate DATE DEFAULT (CURRENT_DATE),
    scanId INT,
    isRescan BOOLEAN,
    FOREIGN KEY (scanId) REFERENCES Scans(id)
);