kokkok EV

Tables (6)

app_reviews

  • id — BIGSERIAL
  • store — VARCHAR(20) — NOT NULL
  • app_name — VARCHAR(100) — NOT NULL
  • country — CHAR(3) — NOT NULL
  • rating — SMALLINT
  • author — VARCHAR(200)
  • review_date — DATE
  • content — TEXT — NOT NULL
  • lang_detected — VARCHAR(10)
  • translated_content — TEXT
  • sentiment_label — VARCHAR(10)
  • sentiment_score — FLOAT
  • keyword_category — VARCHAR(50)
  • created_at — TIMESTAMPTZ

blog_posts

  • id — BIGSERIAL
  • platform — VARCHAR(30) — NOT NULL
  • title — TEXT
  • content — TEXT — NOT NULL
  • author — VARCHAR(200)
  • post_date — DATE
  • url — TEXT
  • translated_content — TEXT
  • sentiment_label — VARCHAR(10)
  • sentiment_score — FLOAT
  • keyword_category — VARCHAR(50)
  • created_at — TIMESTAMPTZ

sns_posts

  • id — BIGSERIAL
  • platform — VARCHAR(20) — NOT NULL
  • page_name — VARCHAR(200)
  • country — CHAR(3)
  • content — TEXT — NOT NULL
  • post_date — DATE
  • lang_detected — VARCHAR(10)
  • translated_content — TEXT
  • sentiment_label — VARCHAR(10)
  • sentiment_score — FLOAT
  • keyword_category — VARCHAR(50)
  • collection_method — VARCHAR(30)
  • created_at — TIMESTAMPTZ

youtube_comments

  • id — BIGSERIAL
  • video_id — VARCHAR(20) — Foreign key → youtube_videos.video_id — NOT NULL
  • author — VARCHAR(200)
  • content — TEXT — NOT NULL
  • like_count — INT
  • comment_date — TIMESTAMPTZ
  • lang_detected — VARCHAR(10)
  • translated_content — TEXT
  • sentiment_label — VARCHAR(10)
  • sentiment_score — FLOAT
  • keyword_category — VARCHAR(50)
  • created_at — TIMESTAMPTZ

youtube_stt

  • id — BIGSERIAL
  • video_id — VARCHAR(20) — Foreign key → youtube_videos.video_id — NOT NULL
  • timestamp_start — FLOAT — NOT NULL
  • timestamp_end — FLOAT
  • content — TEXT — NOT NULL
  • translated_content — TEXT
  • created_at — TIMESTAMPTZ

youtube_videos

  • video_id — VARCHAR(20)
  • title — TEXT — NOT NULL
  • channel_name — VARCHAR(200)
  • country — CHAR(3)
  • upload_date — DATE
  • view_count — BIGINT
  • like_count — BIGINT
  • description — TEXT
  • created_at — TIMESTAMPTZ