Spaces:
Sleeping
Sleeping
| from sqlalchemy import Column, Integer, String, Boolean, DateTime | |
| from sqlalchemy.sql import func | |
| from database import Base | |
| class User(Base): | |
| __tablename__ = "users" | |
| id = Column(Integer, primary_key=True, index=True) | |
| name = Column(String, nullable=False) | |
| email = Column(String, unique=True, index=True, nullable=False) | |
| hashed_password = Column(String, nullable=False) | |
| role = Column(String, default="viewer") # viewer, analyst, admin | |
| is_active = Column(Boolean, default=True) | |
| created_at = Column(DateTime(timezone=True), server_default=func.now()) |