finance database

gistfile1.txt

CREATE TABLE IF NOT EXISTS users(
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    username TEXT,
    hash TEXT,
    cash REAL DEFAULT 10000
);

CREATE TABLE IF NOT EXISTS transactions (
    transaction_id INTEGER PRIMARY KEY AUTOINCREMENT,
    symbol TEXT,
    qty INTEGER,
    price REAL,
    user_id INTEGER, -- Agrega la columna user_id como clave externa
    timestamp TEXT,
    FOREIGN KEY(user_id) REFERENCES users(id)
);


CREATE TABLE IF NOT EXISTS records (
  	record_id INTEGER PRIMARY KEY AUTOINCREMENT,
    symbol text,
  	action text,
    qty integer,
    price real,
    timestamp TEXT,
    user_id INTEGER,
    transaction_id INTEGER,
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (transaction_id) REFERENCES transactions(transaction_id)
);