CREATE TABLE "user" (
	"id" int,
	"created_date" datetime,
	"email" varchar(255),
	"full_name" varchar(255),
	"display_name" varchar(255),
	"password" varchar(255),
	"role" int,
	"status" bool,
	"access_token" varchar(255),
	"access_token_expire_date" datetime
);
CREATE TABLE "specialist" (
	"user_id" int PRIMARY KEY,
	"profession" varchar(255),
	"working_city" varchar(255),
	FOREIGN KEY("user_id") REFERENCES "user" ("id")
);
CREATE TABLE "patient" (
	"user_id" int PRIMARY KEY,
	"age" int,
	"gender" int,
	FOREIGN KEY("user_id") REFERENCES "user" ("id")
);
CREATE TABLE "category" (
	"id" int,
	"name" varchar(255),
	"url_name" varchar(255),
	FOREIGN KEY("url_name") REFERENCES "url" ("name")
);
CREATE TABLE "tag" (
	"id" int,
	"name" varchar(255),
	"url_name" varchar(255),
	FOREIGN KEY("url_name") REFERENCES "url" ("name")
);
CREATE TABLE "question" (
	"id" int,
	"user_id" int,
	"created_date" datetime,
	"title" varchar(255),
	"statu" bool,
	"hit" int,
	FOREIGN KEY("user_id") REFERENCES "user" ("id")
);
CREATE TABLE "message" (
	"id" int,
	"question_id" int,
	"created_date" datetime,
	"user_id" int,
	"content" varchar(255),
	"statu" bool,
	"message_type" int,
	FOREIGN KEY("question_id") REFERENCES "question" ("id")
);
CREATE TABLE "tag_question" (
	"id" int,
	"tag_id" int,
	"question_id" int,
	FOREIGN KEY("tag_id") REFERENCES "tag" ("id"),
	FOREIGN KEY("question_id") REFERENCES "question" ("id")
);
CREATE TABLE "category_tag" (
	"id" int,
	"category_id" int,
	"tag_id" int,
	FOREIGN KEY("category_id") REFERENCES "category" ("id"),
	FOREIGN KEY("tag_id") REFERENCES "tag" ("id")
);
CREATE TABLE "message_like" (
	"id" int,
	"created_date" datetime,
	"message_id" int,
	"user_id" int,
	FOREIGN KEY("message_id") REFERENCES "message" ("id"),
	FOREIGN KEY("user_id") REFERENCES "user" ("id")
);