Newer
Older
smart-home-server / database_dump / smart-home-server_table_notifications.sql

-- --------------------------------------------------------

--
-- Структура таблицы `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'for user with id...',
  `type` varchar(50) NOT NULL COMMENT '"system" | "script" | "aside"',
  `icon` varchar(255) NOT NULL COMMENT 'Load from icon pack or url to img',
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `link` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;