Table "atomic.mail_inbox"

ColumnTypeNullableDefaultStorageDescription
"projectId"integernot nullplain
"mailId"character varying(45)not nullextended
"toEmails"text[]not nullextended
"sentAt"timestamp with time zoneplain
"insertedAt"timestamp with time zonenot nullCURRENT_TIMESTAMPplain
"to"jsonbextended
"cc"jsonbextended
"from"jsonbextended
"subject"character varying(150)extended
"textPreview"character varying(150)extended
"headers"character varying(10000)extended
"senderIp"inetmain
"envelope"jsonbextended
"dkim"character varying(200)extended
"spf"character varying(200)extended
"isHtml"booleanplain
"attachementRefs"jsonbextended
"attachmentCount"integerplain
"toEmailsLowerCased"text[]extended
"softDeletedAt"timestamp with time zoneplain

Indexes:

"PersonInbox_pkey" PRIMARY KEY, btree ("projectId", "toEmails", "insertedAt")
"personinbox_mailid_unique" UNIQUE CONSTRAINT, btree ("mailId")
"PersonInbox_toEmails" gin ("toEmails")

Access method:

heap
Last updated on by John Gracey