SSJ3PJ
Tables (3)
es_environment_metadata
- id — SERIAL
- es_doc_id — TEXT — NOT NULL
- recorded_at — TIMESTAMP — NOT NULL
- location — TEXT
- source — TEXT
- indexed_at — TIMESTAMP
es_youtube_metadata
- id — SERIAL
- es_doc_id — TEXT — NOT NULL
- youtube_id — TEXT — NOT NULL
- title — TEXT
- view_count — INT
- like_count — INT
- comment_count — INT
- published_at — TIMESTAMP
- channel_name — TEXT
- indexed_at — TIMESTAMP
users
- id — BIGSERIAL
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- last_login — TIMESTAMP