· 6 years ago · Dec 27, 2019, 03:46 AM
1-- Dumping structure for table kanaya-db.t_push_notif
2CREATE TABLE IF NOT EXISTS `t_push_notif` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `member_id` int(11) DEFAULT NULL,
5 `marketing_id` int(11) DEFAULT NULL,
6 `judul` varchar(150) NOT NULL DEFAULT '',
7 `keterangan` text NOT NULL DEFAULT '',
8 `logo` varchar(300) DEFAULT NULL,
9 `tanggal` datetime NOT NULL,
10 KEY `Index 1` (`id`),
11 KEY `push_member_id` (`member_id`),
12 KEY `push_marketing_id` (`marketing_id`),
13 CONSTRAINT `push_marketing_id` FOREIGN KEY (`marketing_id`) REFERENCES `pegawai` (`id`),
14 CONSTRAINT `push_member_id` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='digunakan untuk menampilkan notif per member per marketing';
16
17-- Data exporting was unselected.