short_url.py 982 B

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