user.py 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. from sqlalchemy import Column, String, DateTime, Integer
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasUser(Base):
  5. __tablename__ = "vas_user"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_user` (
  8. `id` VARCHAR(128) NOT NULL,
  9. `role` VARCHAR(32) NULL,
  10. `email` VARCHAR(128) NULL,
  11. `phone` VARCHAR(32) NULL,
  12. `nickname` VARCHAR(64) NULL,
  13. `avatar_url` VARCHAR(255) NULL,
  14. `preferred_language` VARCHAR(8) NULL,
  15. `timezone` VARCHAR(32) NULL,
  16. `register_ip` VARCHAR(64) NULL,
  17. `last_login_ip` VARCHAR(64) NULL,
  18. `password_hash` VARCHAR(255) NULL,
  19. `email_verified` INT NOT NULL DEFAULT 0,
  20. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  21. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  22. PRIMARY KEY (`id`),
  23. KEY `idx_vas_user_email` (`email`),
  24. KEY `idx_vas_user_role` (`role`)
  25. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户基础表';
  26. """
  27. id = Column(String(128), primary_key=True)
  28. role = Column(String(32))
  29. email = Column(String(128))
  30. phone = Column(String(32))
  31. nickname = Column(String(64))
  32. avatar_url = Column(String(255))
  33. preferred_language = Column(String(8))
  34. timezone = Column(String(32))
  35. register_ip = Column(String(64))
  36. last_login_ip = Column(String(64))
  37. password_hash = Column(String(255))
  38. email_verified = Column(Integer, default=0)
  39. created_at = Column(DateTime, default=datetime.utcnow)
  40. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)