· 8 years ago · Jan 14, 2018, 07:52 PM
1drop table if exists Article;
2create table Article(
3 id serial primary key not null,
4 title varchar(100),
5 DT timestamp,
6 sourceURL varchar(400),
7 content text,
8 info text
9);
10
11drop table if exists Brand;
12create table Brand(
13 id serial primary key not null,
14 title varchar(100) not null,
15 websiteURL varchar(400),
16 description text
17);
18
19drop table if exists Mention;
20create table Mention(
21 id serial primary key not null,
22 brandID int not null,
23 articleID int not null
24);