summaryrefslogtreecommitdiff
path: root/app/database/models/user.py
diff options
context:
space:
mode:
Diffstat (limited to 'app/database/models/user.py')
-rw-r--r--app/database/models/user.py14
1 files changed, 14 insertions, 0 deletions
diff --git a/app/database/models/user.py b/app/database/models/user.py
new file mode 100644
index 0000000..a04e185
--- /dev/null
+++ b/app/database/models/user.py
@@ -0,0 +1,14 @@
+from sqlalchemy import BigInteger, String, Date
+from sqlalchemy.orm import mapped_column
+from app.database import db
+
+
+class User(db.Model):
+ __tablename__ = 'users'
+
+ id = mapped_column(BigInteger, primary_key=True)
+ email = mapped_column(String, nullable=False)
+ first_name = mapped_column(String, nullable=False)
+ last_name = mapped_column(String, nullable=False)
+ role = mapped_column(String(10), nullable=False)
+ created_at = mapped_column(Date, nullable=False)