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")
);