@rkaushik29

create table ground ( id text primary key, name text not null, type text not null check (type in ('coastal', 'offshore', 'high seas', 'freshwater')), location text not null ); create table fleet ( id text primary key, name text not null,

CREATE TABLE agencies ( agency_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT NOT NULL, operating_states TEXT NOT NULL, start_year INTEGER NOT NULL, sale_commission REAL NOT NULL -- Cut taken on each sale made by its agents ); CREATE TABLE agents (

CREATE TABLE SpeciesInformation ( SpeciesID INT PRIMARY KEY, CommonName VARCHAR(255), ScientificName VARCHAR(255), ConservationStatus VARCHAR(50), SpeciesType VARCHAR(50), GeneralHabitat VARCHAR(255) ); CREATE TABLE UrbanHabitats (

CREATE TABLE "Role" ( "id" TEXT PRIMARY KEY, "name" TEXT UNIQUE, "permissions" TEXT, "createdAt" DATETIME DEFAULT CURRENT_TIMESTAMP, "updatedAt" DATETIME ); CREATE TABLE "Vacc" ( "id" TEXT PRIMARY KEY,

-- Competitions Table CREATE TABLE competition ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, found_year INTEGER ); -- Instances Table CREATE TABLE instance ( id INTEGER PRIMARY KEY AUTOINCREMENT,

create table graph ( id text primary key, name text ); create table node ( id text primary key, graph_id text, x real, y real,