Model Proposal: User

[hasansezertasan]

Why do you need this model? What does it solve? Please describe.
Almost every application requires a user model. It's the most copied/pasted, rethought, and restructured model that ever existed.

Describe the solution you'd like
There are a lot of user authentication/authorization systems that are already used in thousands of projects. We can get inspired by looking at them.

Fields

Field Name	Python Type	Description	Unique	Required	Index
username	str	Unique username.	Yes	Yes	Yes
hashed_password	str	Hashed Password.	No	Yes	No
email	str	Email Address of the user.	Yes	No	Yes
date_email_verified	datetime	Date when email was verified.	No	No	No

[hasansezertasan]

Checkout:

• Useful SQLAlchemy Mixins
• bboe/sqla_mixins: A python module that contains a number of simple declarative sqlalchemy mixins.
• ergo/ziggurat_foundations: Framework agnostic set of sqlalchemy classes that make building applications that require permissions an easy task.
• fastapi-users/fastapi_users/models.py at master · fastapi-users/fastapi-users
• fief-dev/fief: Users and authentication management SaaS
• Django models, forms, and auth system are in this folder: django/django/contrib/auth at main · django/django
• hashbang/hashbang: Repository for general issues, documentation, guides, etc.
• membership/membership.db: SQL database schema boilerplate for user accounts, roles and authentication tokens for use in web apps (PostgreSQL, Microsoft SQL Server, Azure SQL Database, LocalDb, SQLite)
• TAPPGuild/sqlalchemy-models: Generic user and login models for SQLAlchemy and json schema.
• pocketbase/pocketbase: Open Source realtime backend in 1 file, it also has a lot of ready schemas to be used in general.
• dropkickdev/featheradmin: Minimalist admin which implements RBAC for use in FastAPI
• codemation/easyauth: Create a centralized Authentication and Authorization token server. Easily secure FastAPI endpoints based on Users, Groups, Roles or Permissions with very little database usage.
• There are many models at lingthio/Flask-User: Customizable User Authorization & User Management: Register, Confirm, Login, Change username/password, Forgot password and more.
• LonelyVikingMichael/litestar-users: Authentication and user management for the Starlite framework
• tataraba/soccerlite: Litestar web app for an amateur soccer league using the PyHAT stack.
• litestar-org/litestar-fullstack: Litestar Fullstack Reference Application with React, Vite, SQLAlchemy, Docker, Task Queues, and more!