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