user model

1 files changed, 12 insertions, 0 deletions

diff --git a/server/models/auth.py b/server/models/auth.py
new file mode 100644
index 0000000..0bf1d18
--- /dev/null
+++ b/server/models/auth.py
@@ -0,0 +1,12 @@
+from sqlalchemy import Column, Integer, String
+from sqlalchemy.orm import relationship
+from db import Base
+
+class User(Base):
+    __tablename__ = "users"
+
+    id = Column(Integer, primary_key=True, index=True)
+    username = Column(String, unique=True, index=True, nullable=False)
+    password = Column(String, nullable=False)
+
+    bids = relationship("Bid", back_populates="user")