gistfile1.txt

CREATE TABLE users (
    phone       char(13),
    active      boolean,
    frequency   integer,
    news_weight  integer,
    entertainment_weight integer,
    facts_weight integer,
    romance_weight integer,
);

CREATE TABLE prompts (
    content text,
    category char(13),
    domain varchar,
    url varchar,
    ups integer
);


CREATE TABLE bursts (
    user_id integer,
    prompt_ids integer[],
    sent boolean default FALSE,
    sent_at date,
    created_at date
);


CREATE TABLE histories (
    user_id integer,
    prompt_id integer
);

And add an ID column to bursts

ALTER TABLE bursts ADD COLUMN id SERIAL PRIMARY KEY;