generated from 10xac/Twitter-Data-Analysis-Template
-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
25 lines (22 loc) · 778 Bytes
/
schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
CREATE TABLE IF NOT EXISTS `TweetInformation`
(
`id` INT NOT NULL AUTO_INCREMENT,
`created_at` TEXT DEFAULT NULL,
`source` VARCHAR(300) DEFAULT NULL,
`original_text` TEXT DEFAULT NULL,
`clean_text` TEXT DEFAULT NULL,
`sentiment` TEXT DEFAULT NULL,
`polarity` FLOAT DEFAULT NULL,
`subjectivity` FLOAT DEFAULT NULL,
`lang` TEXT DEFAULT NULL,
`favorite_count` INT DEFAULT NULL,
`retweet_count` INT DEFAULT NULL,
`original_author` TEXT DEFAULT NULL,
`followers_count` INT DEFAULT NULL,
`friends_count` INT DEFAULT NULL,
`hashtags` TEXT DEFAULT NULL,
`user_mentions` TEXT DEFAULT NULL,
`place` TEXT DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci;