class User(db.Model): # type: ignore
id = db.Column(db.Integer, primary_key=True)
uuid = db.Column(db.String(36), unique=True, nullable=False)
email = db.Column(db.String(100), unique=True, nullable=False)
name = db.Column(db.String(255, collation=DEFAULT_COLLATION),
nullable=False)
surname = db.Column(db.String(255, collation=DEFAULT_COLLATION),
nullable=False)
authmethod = db.Column(db.String(20), nullable=False)
password = db.Column(db.String(255), nullable=False)
mfa_hash = db.Column(db.String(255))
first_login = db.Column(db.DateTime(timezone=True))
last_login = db.Column(db.DateTime(timezone=True))
last_password_change = db.Column(db.DateTime(timezone=True))
is_active = db.Column(db.Boolean, default=True)
privacy_accepted = db.Column(db.Boolean, default=True)
expiration = db.Column(db.DateTime(timezone=True))
roles = db.relationship("Role",
secondary=roles_users,
backref=db.backref("users", lazy="dynamic"))
group_id = db.Column(db.Integer, db.ForeignKey("group.id"))
belongs_to = db.relationship("Group",
backref=db.backref("members"),
foreign_keys=[group_id])
class Login(db.Model): # type: ignore
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.DateTime(timezone=True), nullable=False)
# same length of User.email
username = db.Column(db.String(100))
IP = db.Column(db.String(46))
location = db.Column(db.String(256))
user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=True)
user = db.relationship("User",
backref=db.backref("logins", lazy="dynamic"))
failed = db.Column(db.Boolean, default=False)
flushed = db.Column(db.Boolean, default=False)
class Token(db.Model): # type: ignore
id = db.Column(db.Integer, primary_key=True)
jti = db.Column(db.String(36), unique=True, nullable=False)
# token = db.Column(db.String(360), unique=True)
token = db.Column(db.Text(), nullable=False)
token_type = db.Column(db.String(1), nullable=False)
creation = db.Column(db.DateTime(timezone=True), nullable=False)
expiration = db.Column(db.DateTime(timezone=True))
last_access = db.Column(db.DateTime(timezone=True))
IP = db.Column(db.String(46))
location = db.Column(db.String(256))
user_id = db.Column(db.Integer, db.ForeignKey("user.id"))
emitted_for = db.relationship("User",
backref=db.backref("tokens", lazy="dynamic"))