News Aggregator API


vv�
U� 3 b9d1231d-e9e6-4ff0-82f2-621aeb8def0832bef84576ad6fa197bd9726cf6f506c046330d23b5f7c5fe07ad4ceed1a5f4120250516202819_init
��Ȓ0) sQ !)�g��#�#|!�p
�
d�Q�F�' nc/
�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_topics" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "article_id" INTEGER NOT NULL, "topic_id" INTEGER NOT NULL, �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")w䢪 Q��s !)�g��#�#|!�p
�
d�Qc/
�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 )�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 )�ABG