server/models/mail.py

from sqlalchemy import Column, String, ForeignKey, Integer
from sqlalchemy.dialects.postgresql import UUID as pgUUID
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import DateTime
import uuid

Base = declarative_base()

class mail(Base):
    __tablename__ = "emails"

    id = Column(pgUUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
    subject = Column(String)
    bodyPlainRedacted = Column(String)
    contactId = Column(Integer, ForeignKey("contacts.id"))
    date = Column(DateTime(timezone=True))