18 lines
684 B
Python
18 lines
684 B
Python
|
from sqlalchemy import Column, Enum, ForeignKey, Integer, String
|
||
|
|
from sqlalchemy.orm import relationship
|
||
|
|
|
||
|
|
from app.core.database import Base
|
||
|
|
|
||
|
|
|
||
|
|
class User(Base):
|
||
|
|
__tablename__ = "users"
|
||
|
|
|
||
|
|
id = Column(Integer, primary_key=True, index=True)
|
||
|
|
business_id = Column(Integer, ForeignKey("businesses.id", ondelete="CASCADE"), nullable=False)
|
||
|
|
email = Column(String, unique=True, nullable=False, index=True)
|
||
|
|
hashed_password = Column(String, nullable=True)
|
||
|
|
meta_user_id = Column(String, nullable=True, unique=True)
|
||
|
|
role = Column(Enum("owner", "admin", name="user_role"), nullable=False, default="owner")
|
||
|
|
|
||
|
|
business = relationship("Business", back_populates="users")
|