CREATE TABLE visa_mails ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), subject VARCHAR(255) NOT NULL, sender_email VARCHAR(255) NOT NULL, sender_name VARCHAR(255), body_text TEXT, -- Plain text body body_html TEXT, -- HTML body (for rendering) status VARCHAR(50) DEFAULT 'new', -- 'new', 'in_progress', 'processed', 'spam' assigned_to UUID REFERENCES users(id), -- Admin ID created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP );
| Country | Physical Visa Mail | E-visa / Email | Courier Partner(s) | |---------|--------------------|----------------|---------------------| | USA | Yes (passport return) | No – visa sticker only | DHL, USPS (priority) | | Schengen (France, Germany, etc.) | Yes (via VAC) | No – sticker required | TLScontact, VFS Global | | UK | Yes | No – biometric card via courier | DX Courier, Royal Mail | | Australia | No | Yes – ETA, Visitor e-visa (PDF) | N/A | | India (e-Visa) | No | Yes – PDF emailed | N/A | | Canada | Yes (for counterfoil) | No – sticker only | Canada Post, Purolator | | Turkey | Hybrid – e-visa online; some physical for work visas | Yes for tourism | PTT (national post) |
CREATE TABLE visa_mails ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), subject VARCHAR(255) NOT NULL, sender_email VARCHAR(255) NOT NULL, sender_name VARCHAR(255), body_text TEXT, -- Plain text body body_html TEXT, -- HTML body (for rendering) status VARCHAR(50) DEFAULT 'new', -- 'new', 'in_progress', 'processed', 'spam' assigned_to UUID REFERENCES users(id), -- Admin ID created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP );
| Country | Physical Visa Mail | E-visa / Email | Courier Partner(s) | |---------|--------------------|----------------|---------------------| | USA | Yes (passport return) | No – visa sticker only | DHL, USPS (priority) | | Schengen (France, Germany, etc.) | Yes (via VAC) | No – sticker required | TLScontact, VFS Global | | UK | Yes | No – biometric card via courier | DX Courier, Royal Mail | | Australia | No | Yes – ETA, Visitor e-visa (PDF) | N/A | | India (e-Visa) | No | Yes – PDF emailed | N/A | | Canada | Yes (for counterfoil) | No – sticker only | Canada Post, Purolator | | Turkey | Hybrid – e-visa online; some physical for work visas | Yes for tourism | PTT (national post) | visa mail