from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy.orm import relationship

from database.sqlalchemy import Base

from .company import Company


class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True, index=True, autoincrement=True)
    username = Column(String, unique=True, index=True)
    password = Column(String)
    token = Column(String)
    company_id = Column(Integer, ForeignKey("organizaciones.id"))

    company = relationship("Company", back_populates="users")