class Association(Base):
    __tablename__ = 'association'
    left_id = Column(String, ForeignKey('users.username'), primary_key=True)
    right_id = Column(String, ForeignKey('clients.client_id'), primary_key=True)
    access_token = Column(String)
    user_token = Column(String)
    scope = Column(String)
    user = relationship("User", back_populates="clients_store")
    Client = relationship("Client", back_populates="users_store")


class User(Base):

    __tablename__ = "users"

    username = Column(String, primary_key=True)

    first_name = Column(String)
    last_name = Column(String)
    password = Column(String)
    created = Column(DateTime)
    admin = Column(Boolean, default=False)
    settings = Column(PickleType)
    clients = relationship("Association", back_populates="users_store")
    notifications = relationship("Notification")


class Client(Base):
    __tablename__ = "clients"

    client_id = Column(String, primary_key=True)
    official = Column(Boolean, default=False)
    secret_key = Column(String)
    scope = Column(String)
    users = relationship("Association", back_populates="clients_store")