schema.psql

create table hackers (
  name varchar primary key,
  followers integer,
  repos integer,
  location varchar,
  updated timestamp
);

create table updates (
  update_id varchar primary key,
  author varchar,
  date timestamp,
  title varchar,
  content text,
  media varchar 
);
create index updates_date_idx on updates (date);


create table blog_posts (
  blog varchar,
  feed_url varchar, 
  href varchar unique,
  title varchar,
  author varchar,
  date timestamp,
  summary text
);

create index blog_posts_date_idx on updates (date);

create table tweets (
  id bigint primary key,
  created_at timestamp,
  user_screen_name varchar,
  user_profile_image_url varchar,
  user_description varchar,
  user_location varchar,
  user_followers_count integer,
  text varchar,
  retweet_count integer default 0
);
create index tweets_created_at_idx on tweets (created_at);


create table blogs (
  title varchar,
  html_url varchar, 
  feed_url varchar
);