from sqlalchemy import Column, BigInteger, Integer, String, Enum, DateTime, func from app.core.database import Base class VasPaymentConfirmation(Base): __tablename__ = "vas_payment_confirm" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_payment_confirm` ( `id` BIGINT NOT NULL AUTO_INCREMENT, `payment_id` BIGINT NOT NULL, `amount` INT NOT NULL, `currency` VARCHAR(10) NOT NULL, `random_offset` INT NOT NULL, `user_id` VARCHAR(128) NOT NULL, `status` ENUM('pending','confirmed','ignored') NOT NULL DEFAULT 'pending', `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `confirmed_at` DATETIME NULL, `admin_id` VARCHAR(128) NULL, `admin_confirmed_at` DATETIME NULL, PRIMARY KEY (`id`), KEY `idx_vas_pay_conf_payment` (`payment_id`), KEY `idx_vas_pay_conf_user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='人工支付确认审核记录表'; """ id = Column(BigInteger, primary_key=True, autoincrement=True) payment_id = Column(BigInteger, nullable=False) amount = Column(Integer, nullable=False) currency = Column(String(10), nullable=False) random_offset = Column(Integer, nullable=False) user_id = Column(String(128), nullable=False) status = Column(Enum("pending","confirmed","ignored"), nullable=False, default="pending") created_at = Column(DateTime, nullable=False, server_default=func.now()) confirmed_at = Column(DateTime, nullable=True) admin_id = Column(String(128), nullable=True) admin_confirmed_at = Column(DateTime, nullable=True)