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
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