Advertisement
hilmawanyr

notification table

Apr 8th, 2020
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.39 KB | None | 0 0
  1. -- db_siakadlive.notification definition
  2.  
  3. CREATE TABLE `notification` (
  4.   `id` int(11) NOT NULL AUTO_INCREMENT,
  5.   `type` varchar(100) NOT NULL,
  6.   `message` text NOT NULL,
  7.   `to` varchar(100) NOT NULL,
  8.   `from` varchar(100) NOT NULL,
  9.   `url` text,
  10.   `is_read` tinyint(4) NOT NULL,
  11.   `created_at` datetime NOT NULL,
  12.   PRIMARY KEY (`id`)
  13. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement