14 lines
822 B
Python
14 lines
822 B
Python
from sqlalchemy import Column, Integer, String, ForeignKey, DateTime
|
|
from sqlalchemy.orm import relationship
|
|
from app.models.database import Base
|
|
import datetime
|
|
|
|
class CommunitySetMapping(Base):
|
|
"""社区集合映射模型，用于保存社区集合和社区的一对多关系"""
|
|
__tablename__ = "community_set_mappings"
|
|
|
|
id = Column(Integer, primary_key=True, index=True, autoincrement=True)
|
|
set_id = Column(Integer, ForeignKey("community_sets.id"), nullable=False, comment="社区集合ID")
|
|
community_id = Column(Integer, ForeignKey("communities.id"), nullable=False, comment="社区ID")
|
|
create_time = Column(DateTime, default=datetime.datetime.now, comment="创建时间")
|
|
update_time = Column(DateTime, default=datetime.datetime.now, onupdate=datetime.datetime.now, comment="更新时间") |