create_tables.sql

-- Schema definition for transactions table
-- This file documents the database structure used in the fraud detection project

CREATE TABLE IF NOT EXISTS transactions (
    Time INTEGER,        -- Seconds elapsed since first transaction
    V1 REAL,
    V2 REAL,
    V3 REAL,
    V4 REAL,
    V5 REAL,
    V6 REAL,
    V7 REAL,
    V8 REAL,
    V9 REAL,
    V10 REAL,
    V11 REAL,
    V12 REAL,
    V13 REAL,
    V14 REAL,
    V15 REAL,
    V16 REAL,
    V17 REAL,
    V18 REAL,
    V19 REAL,
    V20 REAL,
    V21 REAL,
    V22 REAL,
    V23 REAL,
    V24 REAL,
    V25 REAL,
    V26 REAL,
    V27 REAL,
    V28 REAL,
    Amount REAL,         -- Transaction amount
    Class INTEGER        -- 0 = Legit, 1 = Fraud
);