ur_ingest_session_imap_acct_folder_message

Column	Type	PK	Required	Default
ur_ingest_session_imap_acct_folder_message_id	TEXT	Yes	Yes
ingest_session_id	TEXT	No	Yes
ingest_imap_acct_folder_id	TEXT	No	Yes
message	TEXT	No	Yes
message_id	TEXT	No	Yes
subject	TEXT	No	Yes
from	TEXT	No	Yes
cc	TEXT	No	Yes
bcc	TEXT	No	Yes
status	TEXT[]	No	Yes
date	DATE	No	No
email_references	TEXT	No	Yes
created_at	TIMESTAMPTZ	No	No	CURRENT_TIMESTAMP
created_by	TEXT	No	No	'UNKNOWN'
updated_at	TIMESTAMPTZ	No	No
updated_by	TEXT	No	No
deleted_at	TIMESTAMPTZ	No	No
deleted_by	TEXT	No	No
activity_log	TEXT	No	No

Foreign Keys

Column Name	Foreign Key
ingest_imap_acct_folder_id	ingest_imap_acct_folder_id references ur_ingest_session_imap_acct_folder.ur_ingest_session_imap_acct_folder_id
ingest_session_id	ingest_session_id references ur_ingest_session.ur_ingest_session_id

Indexes

Column Name	Index Name
message	ur_ingest_session_imap_acct_folder_message_message_message_id_unique
message_id	ur_ingest_session_imap_acct_folder_message_message_message_id_unique
ingest_session_id	idx_ur_ingest_session_imap_acct_folder_message__ingest_session_id
ur_ingest_session_imap_acct_folder_message_id	sqlite_autoindex_ur_ingest_session_imap_acct_folder_message_1

SQL DDL

CREATE TABLE `ur_ingest_session_imap_acct_folder_message` (
	`ur_ingest_session_imap_acct_folder_message_id` text PRIMARY KEY NOT NULL,
	`ingest_session_id` text NOT NULL,
	`ingest_imap_acct_folder_id` text NOT NULL,
	`message` text NOT NULL,
	`message_id` text NOT NULL,
	`subject` text NOT NULL,
	`from` text NOT NULL,
	`cc` text NOT NULL,
	`bcc` text NOT NULL,
	`status` TEXT[] NOT NULL,
	`date` DATE,
	`email_references` text NOT NULL,
	`created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
	`created_by` text DEFAULT 'UNKNOWN',
	`updated_at` TIMESTAMPTZ,
	`updated_by` text,
	`deleted_at` TIMESTAMPTZ,
	`deleted_by` text,
	`activity_log` text,
	FOREIGN KEY (`ingest_session_id`) REFERENCES `ur_ingest_session`(`ur_ingest_session_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`ingest_imap_acct_folder_id`) REFERENCES `ur_ingest_session_imap_acct_folder`(`ur_ingest_session_imap_acct_folder_id`) ON UPDATE no action ON DELETE no action,
	CONSTRAINT "cc_check_valid_json" CHECK(json_valid("ur_ingest_session_imap_acct_folder_message"."cc") OR "ur_ingest_session_imap_acct_folder_message"."cc" IS NULL),
	CONSTRAINT "bcc_check_valid_json" CHECK(json_valid("ur_ingest_session_imap_acct_folder_message"."bcc") OR "ur_ingest_session_imap_acct_folder_message"."bcc" IS NULL),
	CONSTRAINT "email_references_check_valid_json" CHECK(json_valid("ur_ingest_session_imap_acct_folder_message"."email_references") OR "ur_ingest_session_imap_acct_folder_message"."email_references" IS NULL)
)