createsql

# Tables schema

# --- !Ups

CREATE TABLE public.Likes
(
  tweet_id integer,
  liker_id integer,
  post_owner_id integer,
  date date
);
CREATE TABLE public.Trends
(
  id integer SERIAL PRIMARY KEY,
  date date,
  type character(1),
  link character varying,
  ranking integer,
);
CREATE TABLE public.Hashtag_Tweet_Relation
(
  tweet_id integer,
  hashtag_id integer
);

CREATE TABLE public.Location
(
  Location_id integer NOT NULL P,
  name character varying,
  CONSTRAINT location_id PRIMARY KEY (Location_id)
);

CREATE TABLE public.Accounts
(
  account_id SERIAL PRIMARY KEY,
  total_likes integer,
  username character varying,
  password character varying,
  FOREIGN KEY (account_id) REFERENCES public.Tweets (tweet_owner) ON DELETE CASCADE,
  FOREIGN KEY (account_id) REFERENCES public.Likes (liker_id) ON DELETE CASCADE
);

CREATE TABLE public.Hashtags
(
  hashtag_id integer NOT NULL,
  created_date date,
  CONSTRAINT hashtag_id PRIMARY KEY (hashtag_id)
	REFERENCES public.Hashtag_Tweet_Relation (hashtag_id) MATCH SIMPLE
	ON UPDATE CASCADE ON DELETE CASCADE
);

CREATE TABLE public.Tweets
(
  tweet_id integer,
  tweet_owner character varying,
  tweet_owner_id integer
  tweet_text character varying,
  total_likes integer,
  location_id integer,
  CONSTRAINT tweet_id PRIMARY KEY (tweet_id),
  CONSTRAINT tweet_owner FOREIGN KEY (tweet_owner)
		REFERENCES public.Accounts (account_id) MATCH SIMPLE
		ON UPDATE NO ACTION ON DELETE CASCADE
);

# --- !Downs

DROP TABLE public.Likes;
DROP TABLE public.Trends;
DROP TABLE public.Hashtag_Tweet_Relation;
DROP TABLE public.Location;
DROP TABLE public.Accounts;
DROP TABLE public.Hashtags;
DROP TABLE public.Tweets;