test24 / models.py
Niansuh's picture
Create models.py
3a9617f verified
raw
history blame
755 Bytes
# models.py
from sqlalchemy import Column, Integer, String, Text, DateTime
from sqlalchemy.sql import func
from database import Base
class Image(Base):
__tablename__ = "images"
id = Column(Integer, primary_key=True, index=True)
image_url = Column(String(255), nullable=False)
description = Column(Text, nullable=True)
created_at = Column(DateTime(timezone=True), server_default=func.now())
class Log(Base):
__tablename__ = "logs"
id = Column(Integer, primary_key=True, index=True)
timestamp = Column(DateTime(timezone=True), server_default=func.now())
level = Column(String(50), nullable=False)
message = Column(Text, nullable=False)
client_ip = Column(String(45), nullable=True) # IPv6 compatible