SSJ3PJ

Tables (10)

media_asset

  • id — SERIAL
  • created_at — TIMESTAMP
  • file_path — TEXT — NOT NULL
  • related_environment_id — INT
  • related_submission_id — TEXT
  • related_video_id — TEXT
  • generated_by_user — INT

reddit_comment

  • id — TEXT
  • submission_id — TEXT
  • body — TEXT
  • score — INT
  • created_at — TIMESTAMP

reddit_image

  • id — SERIAL
  • submission_id — TEXT
  • image_url — TEXT

reddit_reply

  • id — TEXT
  • comment_id — TEXT
  • body — TEXT
  • score — INT
  • created_at — TIMESTAMP

reddit_submission

  • id — TEXT
  • title — TEXT
  • body — TEXT
  • num_comments — INT
  • score — INT
  • upvote_ratio — FLOAT
  • created_at — TIMESTAMP
  • subreddit — TEXT

reddit_submission_tag

  • submission_id — TEXT
  • tag_id — INT

reddit_tag

  • id — SERIAL
  • name — TEXT

users

  • id — SERIAL
  • username — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL

youtube_comment

  • id — TEXT
  • video_id — TEXT
  • author — TEXT
  • content — TEXT
  • like_count — INT
  • published_at — TIMESTAMP

youtube_video

  • id — TEXT
  • title — TEXT
  • description — TEXT
  • publish_date — TIMESTAMP
  • view_count — INT
  • like_count — INT
  • comment_count — INT