from sqlalchemy import Column, BigInteger, String, Text, TIMESTAMP, func from app.core.database import Base class ShortUrl(Base): __tablename__ = "short_url" __ddl__ = """ CREATE TABLE IF NOT EXISTS `short_url` ( `id` BIGINT NOT NULL AUTO_INCREMENT, `short_key` VARCHAR(10) NOT NULL COMMENT '短链接Key', `long_url` TEXT NOT NULL COMMENT '原始长链接', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `uq_short_url_short_key` (`short_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短链接映射表'; """ id = Column(BigInteger, primary_key=True, autoincrement=True) short_key = Column(String(10), unique=True, nullable=False, comment="短链接Key") long_url = Column(Text, nullable=False, comment="原始长链接") created_at = Column(TIMESTAMP, server_default=func.now(), comment="创建时间")