class Permission(Model): __tablename__ = "permission" __table_args__ = (UniqueConstraint( "entity", "entity_type", "method_id", "endpoint_id", name="uix_permission_entity_entity_type_method_id_endpoint_id", ), ) entity = db.Column(db.String()) entity_type = db.Column(db.String()) method_id = db.Column( UUID(), ForeignKey("method.id", use_alter=True, ondelete="SET NULL"), nullable=False, ) endpoint_id = db.Column( UUID(), ForeignKey("endpoint.id", use_alter=True, ondelete="SET NULL"), nullable=False, ) service_id = db.Column( UUID(), ForeignKey("service.id", use_alter=True, ondelete="SET NULL"), nullable=False, )
class TokenSessions(Model): __tablename__ = "token_session" iss = db.Column(db.String(), unique=True, nullable=False) exp = db.Column(db.DateTime(timezone=True), nullable=False) identity = db.Column(db.String(), nullable=False, index=True) type = db.Column(db.String(), nullable=False) status = db.Column(db.Boolean(), nullable=False, default=True) iat = db.Column(db.DateTime(timezone=True), nullable=False) role = db.Column(db.String(), nullable=False)
class Users(Model): __tablename__ = "users" identity = db.Column(db.String(), nullable=False, index=True, unique=True) claim = db.Column(JSON(), nullable=True) groups = relationship("Groups", back_populates="user")
class Endpoint(Model): __tablename__ = "endpoint" __table_args__ = (UniqueConstraint( "service_id", "prefix", name="uix_endpoint_service_id_prefix"), ) service_id = db.Column( UUID(), ForeignKey("service.id", use_alter=True, ondelete="SET NULL"), nullable=False, ) prefix = db.Column(db.String())
class Example(Model): __tablename__ = "example" name = db.Column(db.String(), nullable=False) email = db.Column(db.String(), nullable=False, index=True)
class Method(Model): __tablename__ = "method" name = db.Column(db.String(), nullable=False, index=True, unique=True)
class Service(Model): __tablename__ = "service" name = db.Column(db.String(), nullable=False, index=True, unique=True)