@rkaushik29

CREATE TABLE Designers ( designer_id INTEGER PRIMARY KEY, name TEXT NOT NULL, brand_name TEXT, contact_info TEXT, specialization TEXT ); CREATE TABLE Suppliers ( supplier_id INTEGER PRIMARY KEY,

CREATE TABLE "Country" ( country_id INTEGER PRIMARY KEY AUTOINCREMENT, country_name TEXT NOT NULL, country_code TEXT NOT NULL UNIQUE, continent TEXT NOT NULL ); CREATE TABLE "Venue" ( venue_id INTEGER PRIMARY KEY AUTOINCREMENT, venue_name TEXT NOT NULL,

CREATE TABLE grape_varieties ( grape_variety_code INTEGER PRIMARY KEY autoincrement, grape_variety_name TEXT ); CREATE TABLE colors ( color_code INTEGER PRIMARY KEY autoincrement, color_name TEXT );

CREATE TABLE Destinations ( destination_id INT PRIMARY KEY, name VARCHAR(100), country VARCHAR(100), region VARCHAR(100), description TEXT ); CREATE TABLE TourPackages ( package_id INT PRIMARY KEY,

CREATE TABLE Characters ( CharacterID INTEGER PRIMARY KEY autoincrement, Name VARCHAR(255) NOT NULL, RaceID INTEGER, Description TEXT, BirthDate DATE, DeathDate DATE, Height DECIMAL(5,2), Weight DECIMAL(5,2), FOREIGN KEY (RaceID) REFERENCES Races(RaceID)

CREATE TABLE Patients ( patient_id INTEGER PRIMARY KEY, first_name TEXT NOT NULL, last_name TEXT NOT NULL, date_of_birth DATE NOT NULL, gender TEXT CHECK(gender IN ('Male', 'Female', 'Other')) NOT NULL, contact_information TEXT ); CREATE TABLE GeneticTests (

CREATE TABLE user ( username TEXT PRIMARY KEY, display_name TEXT, created_date TEXT, about_me TEXT, status_msg TEXT ); CREATE TABLE friendship ( user_1 INTEGER,

CREATE TABLE Ports ( port_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, location_city TEXT, location_country TEXT, coordinates TEXT, -- Stored as 'latitude, longitude' capacity INTEGER, type TEXT, -- e.g., 'Seaport', 'Riverport' currently_open INTEGER -- 0 for false, 1 for true );

CREATE TABLE users ( user_id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL UNIQUE, email TEXT UNIQUE, password_hash TEXT NOT NULL, profile_picture BLOB, -- Store profile pictures as BLOBs bio TEXT, -- A short bio of the user created_at DATETIME DEFAULT CURRENT_TIMESTAMP );

CREATE TABLE geological_periods ( period_id INTEGER PRIMARY KEY, period_name TEXT NOT NULL, start_mya REAL NOT NULL, end_mya REAL NOT NULL, description TEXT ); CREATE TABLE fossil_localities ( locality_id INTEGER PRIMARY KEY,

CREATE TABLE Brand( brand_id INTEGER PRIMARY KEY AUTOINCREMENT, brand_name TEXT NOT NULL UNIQUE, establishment_year INTEGER, revenue_in_millions INTEGER CHECK (revenue_in_millions >= 0), num_of_employees INTEGER CHECK (num_of_employees >= 0), geographic_region TEXT CHECK (geographic_region IN ('Europe', 'North America', 'Asia', 'Global', 'Australia')) NOT NULL, positioning TEXT );

CREATE TABLE beekeepers ( beekeeper_id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT NOT NULL, last_name TEXT NOT NULL, email TEXT UNIQUE, phone TEXT, address TEXT, years_experience INTEGER );

CREATE TABLE teacher ( teacher_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER, email TEXT, phone TEXT, address TEXT, -- Address information city TEXT, state TEXT, country TEXT, -- Country information

CREATE TABLE PokemonSpecies ( pokedex_number INTEGER PRIMARY KEY, name TEXT NOT NULL, description TEXT, height REAL, /* cm */ weight REAL, /* kg */ type1 TEXT NOT NULL, /* must have at least one type */ type2 TEXT, base_hp INTEGER, base_attack INTEGER,

CREATE TABLE Prefectures ( -- equivalent of provinces / states prefecture_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, region TEXT ); CREATE TABLE Islands ( -- Japan is an archipelago, so rail service is somewhat -- divided up between island regions (Hokkaido, Kyushu, etc.) island_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT,

CREATE TABLE Appointments ( appointment_id INTEGER PRIMARY KEY AUTOINCREMENT, doctor_id INTEGER NOT NULL, patient_id INTEGER NOT NULL, appointment_date DATETIME NOT NULL, appointment_type TEXT, diagnosis_id INTEGER, FOREIGN KEY (doctor_id) REFERENCES Doctors(doctor_id), FOREIGN KEY (patient_id) REFERENCES Patients(patient_id), FOREIGN KEY (diagnosis_id) REFERENCES Diagnoses(diagnosis_id)

CREATE TABLE team ( team_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, location TEXT NOT NULL, abbreviation TEXT NOT NULL ); CREATE TABLE season ( season_id INTEGER PRIMARY KEY AUTOINCREMENT, year VARCHAR(4) NOT NULL UNIQUE

CREATE TABLE player ( id INTEGER PRIMARY KEY AUTOINCREMENT, display_name TEXT, lvl INTEGER, coins INTEGER, current_location_id INTEGER, spawn_location_id INTEGER, FOREIGN KEY (current_location_id) REFERENCES location (id) FOREIGN KEY (spawn_location_id) REFERENCES location (id) );

CREATE TABLE celestial_body( body_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, type TEXT, discovery_date DATE, mass REAL, gravity REAL, description TEXT );

CREATE TABLE Stations ( station_id INTEGER PRIMARY KEY, name TEXT, location TEXT, capacity INTEGER, is_operational BOOLEAN ); -- charging docks at a station CREATE TABLE StationDocks (