45 lines
1.7 KiB
Python
45 lines
1.7 KiB
Python
from datetime import datetime, date, timezone
|
|
|
|
from sqlalchemy import Column, Date, DateTime, Integer, String, Text
|
|
|
|
from app.database import Base
|
|
|
|
|
|
class Permit(Base):
|
|
__tablename__ = "permits"
|
|
|
|
id = Column(Integer, primary_key=True, autoincrement=True)
|
|
# Core identification
|
|
permit_number = Column(String(100), nullable=True, index=True)
|
|
source_file = Column(String(500), nullable=True)
|
|
source_system = Column(String(100), nullable=True)
|
|
|
|
# Extracted metadata (FR-03)
|
|
applicant_name = Column(String(200), nullable=True, index=True)
|
|
permit_holder_name = Column(String(200), nullable=True)
|
|
issuer_name = Column(String(200), nullable=True)
|
|
location = Column(String(300), nullable=True, index=True)
|
|
issue_date = Column(Date, nullable=True)
|
|
expiry_date = Column(Date, nullable=True)
|
|
applicable_law = Column(String(200), nullable=True)
|
|
work_type = Column(String(200), nullable=True)
|
|
water_type = Column(String(200), nullable=True)
|
|
embankment_type = Column(String(200), nullable=True)
|
|
|
|
# AI classification
|
|
permit_type = Column(String(100), nullable=True, index=True)
|
|
|
|
# Archive compliance (FR-09/10/11, BR-01 to BR-06)
|
|
archive_nomination = Column(String(50), nullable=True) # bewaren / vernietigen
|
|
retention_years = Column(Integer, nullable=True)
|
|
archive_status = Column(String(100), nullable=True)
|
|
|
|
# Full text
|
|
extracted_text = Column(Text, nullable=True)
|
|
|
|
# Processing
|
|
status = Column(String(50), default="processing")
|
|
error_message = Column(Text, nullable=True)
|
|
upload_date = Column(DateTime, default=lambda: datetime.now(timezone.utc))
|
|
created_at = Column(DateTime, default=lambda: datetime.now(timezone.utc))
|