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