| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- from sqlalchemy import Column, String, DateTime, Integer
- from datetime import datetime
- from app.core.database import Base
- class VasUser(Base):
- __tablename__ = "vas_user"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `vas_user` (
- `id` VARCHAR(128) NOT NULL,
- `role` VARCHAR(32) NULL,
- `email` VARCHAR(128) NULL,
- `phone` VARCHAR(32) NULL,
- `nickname` VARCHAR(64) NULL,
- `avatar_url` VARCHAR(255) NULL,
- `preferred_language` VARCHAR(8) NULL,
- `timezone` VARCHAR(32) NULL,
- `register_ip` VARCHAR(64) NULL,
- `last_login_ip` VARCHAR(64) NULL,
- `password_hash` VARCHAR(255) NULL,
- `email_verified` INT NOT NULL DEFAULT 0,
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- KEY `idx_vas_user_email` (`email`),
- KEY `idx_vas_user_role` (`role`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户基础表';
- """
- id = Column(String(128), primary_key=True)
- role = Column(String(32))
- email = Column(String(128))
- phone = Column(String(32))
- nickname = Column(String(64))
- avatar_url = Column(String(255))
- preferred_language = Column(String(8))
- timezone = Column(String(32))
- register_ip = Column(String(64))
- last_login_ip = Column(String(64))
- password_hash = Column(String(255))
- email_verified = Column(Integer, default=0)
- created_at = Column(DateTime, default=datetime.utcnow)
- updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|