-- Hive atomic_facts schema
-- Connect to database `brain_atomic` before running this file.
-- Example: psql -h /Volumes/External/AI_Brain/pg -U postgres -d brain_atomic -f ~/Desktop/seed.sql

BEGIN;

CREATE TABLE IF NOT EXISTS atomic_facts (
    hash        text PRIMARY KEY,
    sentence    text NOT NULL,
    category    text NOT NULL,
    source      text NOT NULL,
    created_at  timestamptz NOT NULL DEFAULT now()
);

-- Helpful indexes for reads
CREATE INDEX IF NOT EXISTS atomic_facts_category_idx ON atomic_facts (category);
CREATE INDEX IF NOT EXISTS atomic_facts_created_at_idx ON atomic_facts (created_at);

COMMIT;