Spaces:
Sleeping
Sleeping
File size: 540 Bytes
8419546 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
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))
|