| from sqlalchemy import Column, Integer, String, DateTime, ForeignKey | |
| from sqlalchemy.orm import relationship | |
| from sqlalchemy.ext.declarative import declarative_base | |
| Base = declarative_base() | |
| class User(Base): | |
| __tablename__ = 'users' | |
| id = Column(Integer, primary_key=True) | |
| username = Column(String, unique=True) | |
| password = Column(String) | |
| profile = Column(String) | |
| tags = Column(String) | |
| class Team(Base): | |
| __tablename__ = 'teams' | |
| id = Column(Integer, primary_key=True) | |
| name = Column(String, unique=True) | |
| created_at = Column(DateTime, default=datetime.datetime.utcnow) | |
| class UserTeam(Base): | |
| __tablename__ = 'user_teams' | |
| user_id = Column(Integer, ForeignKey('users.id'), primary_key=True) | |
| team_id = Column(Integer, ForeignKey('teams.id'), primary_key=True) |