BrandAnalyst DB schema

gistfile1.sql

drop table if exists InfoSource;
create table InfoSource(
	id int primary key not null,
	title varchar(100),
	description text,
	website varchar(400)
);

drop table if exists Article;
create table Article(
	id int primary key not null,
	infosource_id int,
	title varchar(100),
	publ_time timestamp,
	author varchar(150),
	content text
);

drop table if exists Mention;
create table Mention(
	brand_id int,
	article_id int,
	opinion text,
	primary key (brand_id, article_id)
);

drop table if exists Brand;
create table Brand(
	id int primary key not null,
	title varchar(100),
	description text,
	website varchar(400),
	additional_info text
);

drop table if exists BrandStats;
create table BrandStats(
	brand_id int,
	stats_data text,
	data_time timestamp,
	primary key (brand_id, data_time)
);