News Aggregator API

SQLite format 3

@ #
.zp
��X���v��2 
�7tableentitiesentities CREATE TABLE "entities" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "type" TEXT NOT NULL, "article_count" INTEGER NOT NULL DEFAULT 0, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL )�@))
�;tablearticle_topicsarticle_topics CREATE TABLE "article_topics" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "article_id" INTEGER NOT NULL, "topic_id" INTEGER NOT NULL, "confidence" REAL NOT NULL DEFAULT 1.0, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "article_topics_article_id_fkey" FOREIGN KEY ("article_id") REFERENCES "articles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT "article_topics_topic_id_fkey" FOREIGN KEY ("topic_id") REFERENCES "topics" ("id") ON DELETE CASCADE ON UPDATE CASCADE )�
�tabletopicstopicsCREATE TABLE "topics" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "article_count" INTEGER NOT NULL DEFAULT 0, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL )�&
�+tableusersusersCREATE TABLE "users" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "email" TEXT NOT NULL, "name" TEXT, "password_hash" TEXT NOT NULL, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL, "last_login_at" DATETIME, "preferred_categories" TEXT, "preferred_sources" TEXT, "preferred_language" TEXT NOT NULL DEFAULT 'en' )�)''
�tableuser_articlesuser_articlesCREATE TABLE "user_articles" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" INTEGER NOT NULL, "article_id" INTEGER NOT NULL, "is_bookmarked" BOOLEAN NOT NULL DEFAULT false, "is_read" BOOLEAN NOT NULL DEFAULT false, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL, "read_at" DATETIME, CONSTRAINT "user_articles_article_id_fkey" FOREIGN KEY ("article_id") REFERENCES "articles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT "user_articles_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE )P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�)
�%tablearticlesarticlesCREATE TABLE "articles" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "uuid" TEXT NOT NULL, "title" TEXT NOT NULL, "description" TEXT, "url" TEXT NOT NULL, "image_url" TEXT, "source" TEXT NOT NULL, "published_at" DATETIME NOT NULL, "categories" TEXT NOT NULL, "language" TEXT NOT NULL, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL, "read_count" INTEGER NOT NULL DEFAULT 0, "relevance_score" REAL, "sentiment" REAL )�Z
11
�_table_prisma_migrations_prisma_migrationsCREATE TABLE "_prisma_migrations" ( "id" TEXT PRIMARY KEY NOT NULL, "checksum" TEXT NOT NULL, "finished_at" DATETIME, "migration_name" TEXT NOT NULL, "logs" TEXT, "rolled_back_at" DATETIME, "started_at" DATETIME NOT NULL DEFAULT current_timestamp, "applied_steps_count" INTEGER UNSIGNED NOT NULL DEFAULT 0 )CW1
indexsqlite_autoindex__prisma_migrations_1_prisma_migrations
pp�
U� 3 b9d1231d-e9e6-4ff0-82f2-621aeb8def0832bef84576ad6fa197bd9726cf6f506c046330d23b5f7c5fe07ad4ceed1a5f41
��Ȓ_20250516202819_init
��Ȓ
��'U b9d1231d-e9e6-4ff0-82f2-621aeb8def08         � v ���X���v$��O --
�Qtablearticle_entitiesarticle_entitiesCREATE TABLE "article_entities" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "article_id" INTEGER NOT NULL, "entity_id" INTEGER NOT NULL, "frequency" INTEGER NOT NULL DEFAULT 1, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "article_entities_article_id_fkey" FOREIGN KEY ("article_id") REFERENCES "articles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT "article_entities_entity_id_fkey" FOREIGN KEY ("entity_id") REFERENCES "entities" ("id") ON DELETE CASCADE ON UPDATE CASCADE )�2 
�7tableentitiesentities CREATE TABLE "entities" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "type" TEXT NOT NULL, "article_count" INTEGER NOT NULL DEFAULT 0, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL )�@))
�;tablearticle_topicsarticle_topics CREATE TABLE "article_topics" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "article_id" INTEGER NOT NULL, "topic_id" INTEGER NOT NULL, "confidence" REAL NOT NULL DEFAULT 1.0, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "article_topics_article_id_fkey" FOREIGN KEY ("article_id") REFERENCES "articles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT "article_topics_topic_id_fkey" FOREIGN KEY ("topic_id") REFERENCES "topics" ("id") ON DELETE CASCADE ON UPDATE CASCADE )�
�tabletopicstopicsCREATE TABLE "topics" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "article_count" INTEGER NOT NULL DEFAULT 0, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL )�&
�+tableusersusersCREATE TABLE "users" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "email" TEXT NOT NULL, "name" TEXT, "password_hash" TEXT NOT NULL, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL, "last_login_at" DATETIME, "preferred_categories" TEXT, "preferred_sources" TEXT, "preferred_language" TEXT NOT NULL DEFAULT 'en' )�)''
�tableuser_articlesuser_articlesCREATE TABLE "user_articles" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" INTEGER NOT NULL, "article_id" INTEGER NOT NULL, "is_bookmarked" BOOLEAN NOT NULL DEFAULT false, "is_read" BOOLEAN NOT NULL DEFAULT false, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL, "read_at" DATETIME, CONSTRAINT "user_articles_article_id_fkey" FOREIGN KEY ("article_id") REFERENCES "articles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT "user_articles_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE )P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�)
�%tablearticlesarticlesCREATE TABLE "articles" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "uuid" TEXT NOT NULL, "title" TEXT NOT NULL, "description" TEXT, "url" TEXT NOT NULL, "image_url" TEXT, "source" TEXT NOT NULL, "published_at" DATETIME NOT NULL, "categories" TEXT NOT NULL, "language" TEXT NOT NULL, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL, "read_count" INTEGER NOT NULL DEFAULT 0, "relevance_score" REAL, "sentiment" REAL )�Z
11
�_table_prisma_migrations_prisma_migrationsCREATE TABLE "_prisma_migrations" ( "id" TEXT PRIMARY KEY NOT NULL, "checksum" TEXT NOT NULL, "finished_at" DATETIME, "migration_name" TEXT NOT NULL, "logs" TEXT, "rolled_back_at" DATETIME, "started_at" DATETIME NOT NULL DEFAULT current_timestamp, "applied_steps_count" INTEGER UNSIGNED NOT NULL DEFAULT 0 )CW1
indexsqlite_autoindex__prisma_migrations_1_prisma_migrations  sQ !)�g��#�#|!�p
�
d�Q�F�' n�c/
�indexentities_name_keyentitiesCREATE UNIQUE INDEX "entities_name_key" ON "entities"("name")�+Y)
�aindexarticle_topics_article_id_topic_id_keyarticle_topicsCREATE UNIQUE INDEX "article_topics_article_id_topic_id_key" ON "article_topics"("article_id", "topic_id")�C)
�!indexarticle_topics_topic_id_idxarticle_topicsCREATE INDEX "article_topics_topic_id_idx" ON "article_topics"("topic_id")�G)
�)indexarticle_topics_article_id_idxarticle_topicsCREATE INDEX "article_topics_article_id_idx" ON "article_topics"("article_id")S+
qindextopics_name_idxtopicsCREATE INDEX "topics_name_idx" ON "topics"("name")Z+
indextopics_name_keytopicsCREATE UNIQUE INDEX "topics_name_key" ON "topics"("name")Y+
indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")�$U'
�Yindexuser_articles_user_id_article_id_keyuser_articlesCREATE UNIQUE INDEX "user_articles_user_id_article_id_key" ON "user_articles"("user_id", "article_id")�E'
�%indexuser_articles_article_id_idxuser_articlesCREATE INDEX "user_articles_article_id_idx" ON "user_articles"("article_id")y?'
�indexuser_articles_user_id_idxuser_articlesCREATE INDEX "user_articles_user_id_idx" ON "user_articles"("user_id")t?
�indexarticles_published_at_idxarticlesCREATE INDEX "articles_published_at_idx" ON "articles"("published_at")b3
�
indexarticles_source_idxarticlesCREATE INDEX "articles_source_idx" ON "articles"("source")h7
� indexarticles_language_idxarticlesCREATE INDEX "articles_language_idx" ON "articles"("language")[ /
yindexarticles_uuid_idxarticlesCREATE INDEX "articles_uuid_idx" ON "articles"("uuid")c/
�indexarticles_uuid_keyarticlesCREATE UNIQUE INDEX "articles_uuid_key" ON "articles"("uuid")�u))
�%tablesaved_searchessaved_searches CREATE TABLE "saved_searches" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" INTEGER NOT NULL, "name" TEXT NOT NULL, "query" TEXT NOT NULL, "parameters" TEXT NOT NULL, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL, "last_run_at" DATETIME, CONSTRAINT "saved_searches_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE )�O --
�Qtablearticle_entitiesarticle_entitiesCREATE TABLE "article_entities" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "article_id" INTEGER NOT NULL, "entity_id" INTEGER NOT NULL, "frequency" INTEGER NOT NULL DEFAULT 1, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "article_entities_article_id_fkey" FOREIGN KEY ("article_id") REFERENCES "articles" ("id") ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT "article_entities_entity_id_fkey" FOREIGN KEY ("entity_id") REFERENCES "entities" ("id") ON DELETE CASCADE ON UPDATE CASCADE )
|
�7tableentitiesentities CREATE TABLE "entities" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "type" TEXT NOT NULL, "article_count" INTEGER NOT NULL DEFAULT 0, "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" DATETIME NOT NULL )�@))
�;tablearticle_topicsarticle_topics CREATE TABLE "article_topic} A)
�indexsaved_searches_user_id_idxsaved_searches#CREATE INDEX "saved_searches_user_id_idx" ON "saved_searches"("user_id")�6_-
�mindexarticle_entities_article_id_entity_id_keyarticle_entities"CREATE UNIQUE INDEX "article_entities_article_id_entity_id_key" ON "article_entities"("article_id", "entity_id")�I-
�-indexarticle_entities_entity_id_idxarticle_entities!CREATE INDEX "article_entities_entity_id_idx" ON "article_entities"("entity_id")�K-
�1indexarticle_entities_article_id_idxarticle_entities CREATE INDEX "article_entities_article_id_idx" ON "article_entities"("article_id")[/
yindexentities_type_idxentitiesCREATE INDEX "entities_type_idx" ON "entities"("type")[/
yindexentities_name_idxentitiesCREATE INDEX "entities_name_idx" ON "entities"("name")