class Group(db.Model): __tablename__ = 'Groups' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30)) users = db.relationship('User', secondary=user_group_relationship, backref='groups')
class Answer(db.Model): __tablename__ = 'Answers' id = db.Column(db.Integer, primary_key=True)
class Question(db.Model): __tablename__ = 'Questions' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20), unique=True) text = db.Column(db.Text)
class Project(db.Model): __tablename__ = 'Projects' id = db.Column(db.Integer, primary_key=True) name = db.String(30)
class Tag(db.Model): __tablename__ = 'Tags' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20), unique=True) group_id = db.Column(db.Integer, db.ForeignKey('Group.id'))
class User(db.Model): __tablename__ = 'Users' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60))
from flask_ui import db # Many to many relationship user_group_relationship = db.Table( 'User-Group-Relationship', db.Column('user_id', db.Integer, db.ForeignKey('User.id')), db.Column('group_id', db.Integer, db.ForeignKey('Group.id'))) class Group(db.Model): __tablename__ = 'Groups' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30)) users = db.relationship('User', secondary=user_group_relationship, backref='groups') class User(db.Model): __tablename__ = 'Users' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60)) class Tag(db.Model): __tablename__ = 'Tags' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20), unique=True) group_id = db.Column(db.Integer, db.ForeignKey('Group.id'))