File size: 715 Bytes
e418416 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | from sqlalchemy import Column, Integer, String, Float, DateTime, Text
from app.database import Base
from datetime import datetime
class AnalysisHistoryModel(Base):
__tablename__ = "analysis_history"
id = Column(Integer, primary_key=True, index=True)
tender_code = Column(String(50), index=True)
tender_name = Column(String(255))
decision = Column(String(50))
score = Column(Integer)
summary = Column(Text)
risks = Column(Text) # JSON string
technical_analysis = Column(Text)
legal_analysis = Column(Text)
commercial_analysis = Column(Text)
proposal_draft = Column(Text)
report_markdown = Column(Text)
created_at = Column(DateTime, default=datetime.utcnow)
|