myCompiler
English
Deutsch
English
Español
Français
Italiano
日本語
한국어
Nederlands
Polski
Português
Recent
Login
Sign up
Deutsch
English
Español
Français
Italiano
日本語
한국어
Nederlands
Polski
Português
Recent
Login
Sign up
R
@rkaushik29
Fishing Company
SQL
2 years ago
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,
House Agencies
SQL
2 years ago
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 (
Urban Wildlife
SQL
2 years ago
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 (
Virtual Air Traffic
SQL
2 years ago
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,
Piano Competitions
SQL
2 years ago
-- 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,
Planar Graphs
SQL
2 years ago
create table graph ( id text primary key, name text ); create table node ( id text primary key, graph_id text, x real, y real,
Previous
Next page