NGmUaQAB

1CREATE TABLE IF NOT EXISTS `Articles` (
2  `article_id` int(10) NOT NULL,
3  `url` varchar(255) NOT NULL,
4  `Headline` varchar(255) NOT NULL,
5  `journalist_id` int(10) NOT NULL,
6  `source_id` int(10) NOT NULL,
7  `submitted_by` int(10) NOT NULL,
8  PRIMARY KEY (`article_id`)
9)
10
11CREATE TABLE IF NOT EXISTS `Journalists` (
12  `journalist_id` int(10) NOT NULL AUTO_INCREMENT,
13  `name` varchar(255) NOT NULL,
14  PRIMARY KEY (`journalist_id`)
15)
16
17CREATE TABLE IF NOT EXISTS `Sources` (
18  `source_id` int(10) NOT NULL AUTO_INCREMENT,
19  `source_name` varchar(255) NOT NULL,
20  PRIMARY KEY (`source_id`)
21)
22
23CREATE TABLE IF NOT EXISTS `Predictions` (
24  `article_id` int(10) NOT NULL,
25  `contract_id` int(10) NOT NULL,
26  `prediction` varchar(255) NOT NULL
27)
28
29CREATE TABLE IF NOT EXISTS `Contracts` (
30  `contract_id` int(10) NOT NULL AUTO_INCREMENT,
31  `statement` varchar(255) NOT NULL,
32  `outcome` varchar(255) NOT NULL,
33  `maintained_by` int(10) NOT NULL,
34  PRIMARY KEY (`contract_id`)
35)
36
37CREATE TABLE IF NOT EXISTS `Users` (
38  `user_id` int(10) NOT NULL AUTO_INCREMENT,
39  `username` varchar(255) NOT NULL,
40  `password` varchar(255) NOT NULL,
41  PRIMARY KEY (`user_id`)
42)