Create Table Mail Message

-- ----------------------------
-- Table structure for mail_message
-- ----------------------------
DROP TABLE IF EXISTS "public"."mail_message";
CREATE TABLE "public"."mail_message" (
  "id" int4 NOT NULL DEFAULT nextval('mail_message_id_seq'::regclass),
  "subject" varchar COLLATE "pg_catalog"."default",
  "date" timestamp(6),
  "body" text COLLATE "pg_catalog"."default",
  "parent_id" int4,
  "model" varchar COLLATE "pg_catalog"."default",
  "res_id" int4,
  "record_name" varchar COLLATE "pg_catalog"."default",
  "message_type" varchar COLLATE "pg_catalog"."default" NOT NULL,
  "subtype_id" int4,
  "mail_activity_type_id" int4,
  "email_from" varchar COLLATE "pg_catalog"."default",
  "author_id" int4,
  "no_auto_thread" bool,
  "message_id" varchar COLLATE "pg_catalog"."default",
  "reply_to" varchar COLLATE "pg_catalog"."default",
  "mail_server_id" int4,
  "create_uid" int4,
  "create_date" timestamp(6),
  "write_uid" int4,
  "write_date" timestamp(6),
  "website_published" bool
)
;
COMMENT ON COLUMN "public"."mail_message"."subject" IS 'Subject';
COMMENT ON COLUMN "public"."mail_message"."date" IS 'Date';
COMMENT ON COLUMN "public"."mail_message"."body" IS 'Contents';
COMMENT ON COLUMN "public"."mail_message"."parent_id" IS 'Parent Message';
COMMENT ON COLUMN "public"."mail_message"."model" IS 'Related Document Model';
COMMENT ON COLUMN "public"."mail_message"."res_id" IS 'Related Document ID';
COMMENT ON COLUMN "public"."mail_message"."record_name" IS 'Message Record Name';
COMMENT ON COLUMN "public"."mail_message"."message_type" IS 'Type';
COMMENT ON COLUMN "public"."mail_message"."subtype_id" IS 'Subtype';
COMMENT ON COLUMN "public"."mail_message"."mail_activity_type_id" IS 'Mail Activity Type';
COMMENT ON COLUMN "public"."mail_message"."email_from" IS 'From';
COMMENT ON COLUMN "public"."mail_message"."author_id" IS 'Author';
COMMENT ON COLUMN "public"."mail_message"."no_auto_thread" IS 'No threading for answers';
COMMENT ON COLUMN "public"."mail_message"."message_id" IS 'Message-Id';
COMMENT ON COLUMN "public"."mail_message"."reply_to" IS 'Reply-To';
COMMENT ON COLUMN "public"."mail_message"."mail_server_id" IS 'Outgoing mail server';
COMMENT ON COLUMN "public"."mail_message"."create_uid" IS 'Created by';
COMMENT ON COLUMN "public"."mail_message"."create_date" IS 'Created on';
COMMENT ON COLUMN "public"."mail_message"."write_uid" IS 'Last Updated by';
COMMENT ON COLUMN "public"."mail_message"."write_date" IS 'Last Updated on';
COMMENT ON COLUMN "public"."mail_message"."website_published" IS 'Published';
COMMENT ON TABLE "public"."mail_message" IS 'Message';

-- ----------------------------
-- Indexes structure for table mail_message
-- ----------------------------
CREATE INDEX "mail_message_author_id_index" ON "public"."mail_message" USING btree (
  "author_id" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "mail_message_mail_activity_type_id_index" ON "public"."mail_message" USING btree (
  "mail_activity_type_id" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "mail_message_message_id_index" ON "public"."mail_message" USING btree (
  "message_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "mail_message_model_index" ON "public"."mail_message" USING btree (
  "model" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "mail_message_model_res_id_idx" ON "public"."mail_message" USING btree (
  "model" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "res_id" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "mail_message_parent_id_index" ON "public"."mail_message" USING btree (
  "parent_id" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "mail_message_res_id_index" ON "public"."mail_message" USING btree (
  "res_id" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "mail_message_subtype_id_index" ON "public"."mail_message" USING btree (
  "subtype_id" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table mail_message
-- ----------------------------
ALTER TABLE "public"."mail_message" ADD CONSTRAINT "mail_message_pkey" PRIMARY KEY ("id");