DDL untuk ProsesTwMentahDB

CREATE TABLE IF NOT EXISTS `hashtag` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id_internal_tw_jadi` BIGINT(20) NOT NULL,
  `text` VARCHAR(150) NOT NULL,
  PRIMARY KEY (`id_internal`),
  KEY `id_interntal_tw` (`id_internal_tw_jadi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.



CREATE TABLE IF NOT EXISTS `keywords_stat_per_jam` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id_stat_per_jam` BIGINT(20) NOT NULL DEFAULT '0',
  `keywords` tinytext NOT NULL,
  PRIMARY KEY (`id_internal`),
  KEY `id_stat_per_jam` (`id_stat_per_jam`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='keywords yang merepresentasikan tweet dalam jam terentu. Harusnya diisi oleh algoritma yang mencari tweet yang paling relevan dan penting';

-- Data exporting was unselected.



CREATE TABLE IF NOT EXISTS `media` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id` BIGINT(20) NOT NULL,
  `media_url` VARCHAR(300) NOT NULL,
  `media_url_https` VARCHAR(300) NOT NULL,
  `url` VARCHAR(400) NOT NULL,
  `display_url` VARCHAR(100) DEFAULT NULL,
  `expanded_url` VARCHAR(600) NOT NULL,
  `type` VARCHAR(50) NOT NULL,
  `id_internal_tw_jadi` BIGINT(20) NOT NULL,
  PRIMARY KEY (`id_internal`),
  KEY `id_internal_tw` (`id_internal_tw_jadi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.



CREATE TABLE IF NOT EXISTS `stat_per_hari` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `tgl_jam` datetime NOT NULL,
  `is_loaded` INT(11) NOT NULL DEFAULT '0',
  `tahun` INT(11) NOT NULL,
  `bulan` INT(11) NOT NULL,
  `hari` INT(11) NOT NULL,
  `kelas` INT(11) NOT NULL,
  `jum` INT(11) NOT NULL,
  `keywords` VARCHAR(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tahun` (`tahun`),
  KEY `bulan` (`bulan`),
  KEY `hari` (`hari`),
  KEY `kelas` (`kelas`),
  KEY `TGL_WAKTU` (`tgl_jam`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.



CREATE TABLE IF NOT EXISTS `stat_per_jam` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `tgl_jam` datetime NOT NULL,
  `is_loaded` INT(11) NOT NULL DEFAULT '0',
  `is_loaded_rep_tw` INT(11) NOT NULL DEFAULT '0',
  `is_loaded_rep_keywords` INT(10) DEFAULT '0',
  `tahun` INT(11) NOT NULL,
  `bulan` INT(11) NOT NULL,
  `hari` INT(11) NOT NULL,
  `jam` INT(11) NOT NULL,
  `kelas` INT(11) NOT NULL,
  `jum` INT(11) NOT NULL,
  `old_jum` INT(11) NOT NULL DEFAULT '0',
  `keywords` VARCHAR(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tahun` (`tahun`),
  KEY `bulan` (`bulan`),
  KEY `hari` (`hari`),
  KEY `jam` (`jam`),
  KEY `kelas` (`kelas`),
  KEY `TGL_WAKTU` (`tgl_jam`),
  KEY `is_loaded` (`is_loaded`),
  KEY `is_loaded_rep_tw` (`is_loaded_rep_tw`),
  KEY `is_loaded_rep_keywords` (`is_loaded_rep_keywords`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.



CREATE TABLE IF NOT EXISTS `tw_jadi` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id_internal_tw_mentah` BIGINT(20) NOT NULL,
  `id` BIGINT(20) NOT NULL,
  `is_class_defined` INT(11) NOT NULL DEFAULT '0',
  `kelas` INT(11) NOT NULL DEFAULT '-1' COMMENT '0: nonopini, 1: negatif, 2:positif',
  `created_at` VARCHAR(50) NOT NULL,
  `created_at_wib` datetime NOT NULL COMMENT 'versi datetime, dengan gmt+7',
  `is_loaded` INT(11) NOT NULL DEFAULT '0' COMMENT 'sudah diload dari database',
  `from_user` VARCHAR(50) NOT NULL,
  `from_user_id` BIGINT(20) NOT NULL,
  `from_user_name` VARCHAR(50) NOT NULL,
  `location` VARCHAR(50) DEFAULT NULL,
  `keywords` VARCHAR(200) DEFAULT NULL,
  `bobot` DOUBLE DEFAULT NULL,
  `iso_language_code` CHAR(10) DEFAULT NULL,
  `profile_image_url` VARCHAR(400) NOT NULL,
  `profile_image_url_https` VARCHAR(400) NOT NULL,
  `source` VARCHAR(200) NOT NULL,
  `text` VARCHAR(300) NOT NULL,
  `to_user` VARCHAR(100) DEFAULT NULL,
  `to_user_id` BIGINT(20) DEFAULT NULL,
  `to_user_name` VARCHAR(100) DEFAULT NULL,
  `in_reply_to_status_id` BIGINT(20) DEFAULT NULL,
  `geo_coordinate` VARCHAR(100) DEFAULT NULL,
  `geo_type` VARCHAR(50) DEFAULT NULL,
  ` time_stamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `geo_lat` VARCHAR(30) DEFAULT NULL,
  `geo_long` VARCHAR(30) DEFAULT NULL,
  `text_prepro` VARCHAR(200) DEFAULT NULL,
  `is_prepro` INT(11) NOT NULL DEFAULT '0',
  `is_duplicate` INT(11) DEFAULT '0',
  `is_duplicate_checked` INT(11) DEFAULT '0',
  PRIMARY KEY (`id_internal`),
  UNIQUE KEY `id` (`id`,`from_user_id`),
  KEY `from_user_id` (`from_user_id`),
  KEY `is_class_defined` (`is_class_defined`,`kelas`),
  KEY `is_prepro` (`is_prepro`),
  KEY `created_at_wib` (`created_at_wib`),
  KEY `is_loaded` (`is_loaded`),
  KEY `text_prepro` (`text_prepro`),
  KEY `is_duplicate` (`is_duplicate`),
  KEY `is_duplicate_checked` (`is_duplicate_checked`),
  KEY `id_internal_tw_mentah` (`id_internal_tw_mentah`),
  KEY `bobot` (`bobot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.


-- Dumping structure for table indosat1.tw_jadi_flag_duplicate
CREATE TABLE IF NOT EXISTS `tw_jadi_flag_duplicate` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id_internal_tw_mentah` BIGINT(20) NOT NULL,
  `id` BIGINT(20) NOT NULL,
  `is_class_defined` INT(11) NOT NULL DEFAULT '0',
  `kelas` INT(11) NOT NULL DEFAULT '-1' COMMENT '0: nonopini, 1: negatif, 2:positif',
  `created_at` VARCHAR(50) NOT NULL,
  `created_at_wib` datetime NOT NULL COMMENT 'versi datetime, dengan gmt+7',
  `is_loaded` INT(11) NOT NULL DEFAULT '0' COMMENT 'sudah diload dari database',
  `from_user` VARCHAR(50) NOT NULL,
  `from_user_id` BIGINT(20) NOT NULL,
  `from_user_name` VARCHAR(50) NOT NULL,
  `location` VARCHAR(50) DEFAULT NULL,
  `iso_language_code` CHAR(10) DEFAULT NULL,
  `profile_image_url` VARCHAR(400) NOT NULL,
  `profile_image_url_https` VARCHAR(400) NOT NULL,
  `source` VARCHAR(200) NOT NULL,
  `text` VARCHAR(200) NOT NULL,
  `to_user` VARCHAR(100) DEFAULT NULL,
  `to_user_id` BIGINT(20) DEFAULT NULL,
  `to_user_name` VARCHAR(100) DEFAULT NULL,
  `in_reply_to_status_id` BIGINT(20) DEFAULT NULL,
  `geo_coordinate` VARCHAR(100) DEFAULT NULL,
  `geo_type` VARCHAR(50) DEFAULT NULL,
  ` time_stamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `geo_lat` VARCHAR(30) DEFAULT NULL,
  `geo_long` VARCHAR(30) DEFAULT NULL,
  `text_prepro` VARCHAR(200) DEFAULT NULL,
  `is_prepro` INT(11) NOT NULL DEFAULT '0',
  `is_duplicate` INT(11) DEFAULT '0',
  `is_duplicate_checked` INT(11) DEFAULT '0',
  PRIMARY KEY (`id_internal`),
  UNIQUE KEY `id` (`id`,`from_user_id`),
  KEY `from_user_id` (`from_user_id`),
  KEY `is_class_defined` (`is_class_defined`,`kelas`),
  KEY `is_prepro` (`is_prepro`),
  KEY `created_at_wib` (`created_at_wib`),
  KEY `is_loaded` (`is_loaded`),
  KEY `text_prepro` (`text_prepro`),
  KEY `is_duplicate` (`is_duplicate`),
  KEY `is_duplicate_checked` (`is_duplicate_checked`),
  KEY `id_internal_tw_mentah` (`id_internal_tw_mentah`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


CREATE TABLE IF NOT EXISTS `tw_stat_per_jam` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id_stat_per_jam` BIGINT(20) NOT NULL DEFAULT '0',
  `id_tw_jadi` BIGINT(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_internal`),
  KEY `id_stat_per_jam` (`id_stat_per_jam`),
  KEY `id_tw_jadi` (`id_tw_jadi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='tweet yang merepresentasikan tweet dalam jam terentu. Harusnya diisi oleh algoritma yang mencari tweet yang paling relevan dan penting';

-- Data exporting was unselected.



CREATE TABLE IF NOT EXISTS `url` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id_internal_tw_jadi` BIGINT(20) NOT NULL,
  `url` VARCHAR(600) NOT NULL,
  `expanded_url` VARCHAR(600) DEFAULT NULL,
  `display_url` VARCHAR(200) DEFAULT NULL,
  PRIMARY KEY (`id_internal`),
  KEY `id_interntal_tw` (`id_internal_tw_jadi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


CREATE TABLE IF NOT EXISTS `user_mention` (
  `id_internal` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `id_internal_tw_jadi` BIGINT(20) NOT NULL,
  `screen_name` VARCHAR(50) NOT NULL,
  `name` VARCHAR(75) NOT NULL,
  `user_id` BIGINT(20) NOT NULL,
  PRIMARY KEY (`id_internal`),
  KEY `id_interntal_tw` (`id_internal_tw_jadi`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;