from datetime import datetime from sqlalchemy import ( Column, Integer, BigInteger, SmallInteger, String, DateTime, JSON, UniqueConstraint, Index, ) from app.core.database import Base class BookerEntry(Base): __tablename__ = "booker_entries" id = Column(BigInteger, primary_key=True, autoincrement=True) node_id = Column(String(64), nullable=False) identifier = Column(String(64), nullable=False) enable = Column(SmallInteger, nullable=False, default=0) debug = Column(SmallInteger, nullable=False, default=0) need_account = Column(SmallInteger, nullable=False, default=1) need_proxy = Column(SmallInteger, nullable=False, default=1) proxy_pool = Column(JSON, nullable=False, default=list) proxy_cd = Column(Integer, nullable=False, default=300) session_max_life = Column(Integer, nullable=False, default=1800) active_time_start = Column(String(5), nullable=False, default="00:00") active_time_end = Column(String(5), nullable=False, default="23:59") website = Column(String(512), nullable=False, default="") booker = Column(JSON, nullable=False, default=dict) plugin_config = Column(JSON, nullable=False, default=dict) appointment_types = Column(JSON, nullable=False, default=list) free_config = Column(JSON, nullable=False, default=dict) version = Column(Integer, nullable=False, default=0) updated_by = Column(String(64), nullable=True, default="system") created_at = Column(DateTime, default=datetime.utcnow, nullable=False) updated_at = Column( DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False ) __table_args__ = ( UniqueConstraint("node_id", "identifier", name="uk_booker_node_identifier"), Index("idx_booker_identifier", "identifier"), Index("idx_booker_updated_at", "updated_at"), ) class SentinelEntry(Base): __tablename__ = "sentinel_entries" id = Column(BigInteger, primary_key=True, autoincrement=True) node_id = Column(String(64), nullable=False) identifier = Column(String(64), nullable=False) enable = Column(SmallInteger, nullable=False, default=0) debug = Column(SmallInteger, nullable=False, default=0) need_account = Column(SmallInteger, nullable=False, default=1) need_proxy = Column(SmallInteger, nullable=False, default=1) proxy_pool = Column(JSON, nullable=False, default=list) proxy_cd = Column(Integer, nullable=False, default=300) session_max_life = Column(Integer, nullable=False, default=1800) active_time_start = Column(String(5), nullable=False, default="00:00") active_time_end = Column(String(5), nullable=False, default="23:59") website = Column(String(512), nullable=False, default="") sentinel = Column(JSON, nullable=False, default=dict) plugin_config = Column(JSON, nullable=False, default=dict) appointment_types = Column(JSON, nullable=False, default=list) free_config = Column(JSON, nullable=False, default=dict) version = Column(Integer, nullable=False, default=0) updated_by = Column(String(64), nullable=True, default="system") created_at = Column(DateTime, default=datetime.utcnow, nullable=False) updated_at = Column( DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False ) __table_args__ = ( UniqueConstraint("node_id", "identifier", name="uk_sentinel_node_identifier"), Index("idx_sentinel_identifier", "identifier"), Index("idx_sentinel_updated_at", "updated_at"), ) class StandaloneEntry(Base): __tablename__ = "standalone_entries" id = Column(BigInteger, primary_key=True, autoincrement=True) node_id = Column(String(64), nullable=False) order_id = Column(String(64), nullable=True) identifier = Column(String(64), nullable=False) enable = Column(SmallInteger, nullable=False, default=1) debug = Column(SmallInteger, nullable=False, default=0) plugin_config = Column(JSON, nullable=False, default=dict) account = Column(JSON, nullable=False, default=dict) proxy_pool = Column(JSON, nullable=False, default=list) query_wait = Column(JSON, nullable=False, default=dict) login_interval = Column(Integer, nullable=False, default=1800) session_max_life = Column(Integer, nullable=False, default=1800) active_time_start = Column(String(5), nullable=False, default="00:00") active_time_end = Column(String(5), nullable=False, default="23:59") appointment_types = Column(JSON, nullable=False, default=list) user_preferences = Column(JSON, nullable=False, default=dict) free_config = Column(JSON, nullable=False, default=dict) version = Column(Integer, nullable=False, default=0) updated_by = Column(String(64), nullable=True, default="system") created_at = Column(DateTime, default=datetime.utcnow, nullable=False) updated_at = Column( DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False ) __table_args__ = ( UniqueConstraint("node_id", "identifier", name="uk_standalone_node_identifier"), Index("idx_standalone_identifier", "identifier"), Index("idx_standalone_order_id", "order_id"), Index("idx_standalone_updated_at", "updated_at"), ) class NodeConfigurationRevision(Base): __tablename__ = "node_configuration_revisions" id = Column(BigInteger, primary_key=True, autoincrement=True) entry_type = Column(String(32), nullable=False, index=True) entry_id = Column(BigInteger, nullable=False, index=True) version = Column(Integer, nullable=False, default=0) action = Column(String(32), nullable=False, default="update") snapshot = Column(JSON, nullable=False, default=dict) updated_by = Column(String(64), nullable=True, default="system") created_at = Column(DateTime, default=datetime.utcnow, nullable=False) __table_args__ = ( Index("idx_node_config_rev_type_id", "entry_type", "entry_id"), )