CREATE TABLE email_repository (
    "email_id" serial
        PRIMARY KEY,                -- email ID
    "from_email" varchar(100),              -- senders email address
    "to_email" varchar(100),                -- recipients email address
    "date" timestamp WITH time zone,        -- date email was sent/recieved
    "subject" varchar(350),                 -- email subject
    "status" varchar(10),                   -- status of the email
    "assigned" varchar(20),                 -- who the email is assigned to
    "related" int,                          -- email ID of the parent message (0 for root messages)
    "follow_up" date,                       -- date email should be followed-up on
    "user_id" character(10),
    "category" varchar(20),
    "message" text,                         -- message body of the email
    "keywords" varchar(130),
    "thread_lock" BOOLEAN
        DEFAULT false,
    "lock_user" varchar(30),
    "last_thread_poll" timestamp,
    "response_times" varchar(100),          -- comma-delimited string of response times during bus. hours
    "total_responses" varchar(100),         -- comma-delimited string of all response times
    "business_art" int
        DEFAULT NULL,     -- average response time during business hours (in minutes)
    "total_art" int
        DEFAULT NULL            -- total average response time (in minutes)
);