-- Schema: bird__app_store
CREATE SCHEMA IF NOT EXISTS "bird__app_store";

-- Table: playstore
CREATE TABLE "bird__app_store"."playstore" (
    "App" TEXT,
    "Category" TEXT,
    "Rating" DOUBLE PRECISION,
    "Reviews" BIGINT,
    "Size" TEXT,
    "Installs" TEXT,
    "Type" TEXT,
    "Price" TEXT,
    "Content Rating" TEXT,
    "Genres" TEXT
);

-- Table: user_reviews
CREATE TABLE "bird__app_store"."user_reviews" (
    "App" TEXT,
    "Translated_Review" TEXT,
    "Sentiment" TEXT,
    "Sentiment_Polarity" TEXT,
    "Sentiment_Subjectivity" TEXT
);
