File size: 860 Bytes
71b4454 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | from sqlalchemy import Column, Integer, String, DateTime, Text, JSON, Boolean
from sqlalchemy.ext.declarative import declarative_base
from datetime import datetime
Base = declarative_base()
class Resource(Base):
__tablename__ = "resources"
id = Column(Integer, primary_key=True)
resource_id = Column(String(64), unique=True, nullable=False)
name = Column(String(128), nullable=False)
description = Column(Text, nullable=True)
resource_type = Column(String(32), nullable=False) # e.g., "file", "database", "api"
uri = Column(String(256), nullable=False)
mime_type = Column(String(64), nullable=True)
meta = Column(JSON, default={})
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
is_public = Column(Boolean, default=True)
|