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 CONSTRAINT user_id REFERENCES user(id),
	"profession" varchar(255),
	"working_city" varchar(255)
);
CREATE TABLE "patient" (
	"user_id" int PRIMARY KEY CONSTRAINT user_id REFERENCES user(id),
	"age" int,
	"gender" int
);
CREATE TABLE "category" (
	"id" int,
	"name" varchar(255),
	"url_name" varchar(255) CONSTRAINT url_name REFERENCES url(name)
);
CREATE TABLE "tag" (
	"id" int,
	"name" varchar(255),
	"url_name" varchar(255) CONSTRAINT url_name REFERENCES url(name)
);
CREATE TABLE "question" (
	"id" int,
	"user_id" int CONSTRAINT user_id REFERENCES user(id),
	"created_date" datetime,
	"title" varchar(255),
	"statu" bool,
	"hit" int
);
CREATE TABLE "message" (
	"id" int,
	"question_id" int CONSTRAINT question_id REFERENCES question(id),
	"created_date" datetime,
	"user_id" int,
	"content" varchar(255),
	"statu" bool,
	"message_type" int
);
CREATE TABLE "tag_question" (
	"id" int,
	"tag_id" int CONSTRAINT tag_id REFERENCES tag(id),
	"question_id" int CONSTRAINT question_id REFERENCES question(id)
);
CREATE TABLE "category_tag" (
	"id" int,
	"category_id" int CONSTRAINT category_id REFERENCES category(id),
	"tag_id" int CONSTRAINT tag_id REFERENCES tag(id)
);
CREATE TABLE "message_like" (
	"id" int,
	"created_date" datetime,
	"message_id" int CONSTRAINT message_id REFERENCES message(id),
	"user_id" int CONSTRAINT user_id REFERENCES user(id)
);