yeslets-schema

gistfile1.txt

DROP TABLE users CASCADE;
CREATE TABLE users (
	id serial primary key,
	name text,
	email text,
  password text,
	created_at timestamptz );

DROP TABLE signals CASCADE;
CREATE TABLE signals (
	id serial primary key,
	user_id integer references users(id),
	action text,
	topic text,
	created_at timestamptz );

DROP TABLE yesletses CASCADE;
CREATE TABLE yesletses (
	id serial primary key,
	signal_id integer references signals(id),
	user_id integer references users(id),
	created_at timestamptz);