tree_structure.py 728 B

1234567891011121314151617181920212223
  1. from sqlalchemy import Column, Integer, String, Text
  2. from sqlalchemy.ext.declarative import declarative_base
  3. Base = declarative_base()
  4. class TreeStructure(Base):
  5. __tablename__ = 'kg_tree_structures'
  6. id = Column(Integer, primary_key=True)
  7. user_id = Column(Integer, nullable=False)
  8. graph_id = Column(Integer, nullable=False)
  9. content = Column(Text, nullable=False)
  10. def __repr__(self):
  11. return f"<TreeStructure(id={self.id}, user_id={self.user_id}, graph_id={self.graph_id})>"
  12. class KgGraphCategory(Base):
  13. __tablename__ = 'kg_graph_category'
  14. id = Column(Integer, primary_key=True)
  15. user_id = Column(Integer)
  16. graph_id = Column(Integer)
  17. category = Column(String(64))