CREATE TABLE `users` (
	`id` int PRIMARY KEY,
	`name` varchar(255),
	`token` varchar(255)
);
CREATE TABLE `commands` (
	`id` int PRIMARY KEY,
	`command` varchar(255)
);
CREATE TABLE `parsers` (
	`id` int PRIMARY KEY,
	`event_type_id` int,
	`name` varchar(255),
	FOREIGN KEY(`event_type_id`) REFERENCES `event_types` (`id`)
);
CREATE TABLE `event_types` (
	`id` int PRIMARY KEY,
	`name` varchar(255)
);
CREATE TABLE `questions` (
	`id` int PRIMARY KEY,
	`question` varchar(255)
);
CREATE TABLE `answers` (
	`id` int PRIMARY KEY,
	`question_id` int,
	`answer` varchar(255),
	FOREIGN KEY(`question_id`) REFERENCES `questions` (`id`)
);
CREATE TABLE `user_infomation` (
	`id` int,
	`user_id` int,
	`question_id` int,
	`answer_id` int,
	FOREIGN KEY(`user_id`) REFERENCES `users` (`id`),
	FOREIGN KEY(`question_id`) REFERENCES `questions` (`id`),
	FOREIGN KEY(`answer_id`) REFERENCES `answers` (`id`)
);
CREATE TABLE `events` (
	`id` int,
	`type_id` int,
	`name` varchar(255),
	`datetime` datetime,
	`image` varchar(255),
	`address` varchar(255),
	`description` varchar(255),
	FOREIGN KEY(`type_id`) REFERENCES `event_types` (`id`)
);
CREATE TABLE `cp_connection` (
	`id` int,
	`command_id` varchar(255),
	`parse_id` varchar(255),
	FOREIGN KEY(`command_id`) REFERENCES `commands` (`id`),
	FOREIGN KEY(`parse_id`) REFERENCES `parsers` (`id`)
);