from pybo import db
question_voter = db.Table(
'question_voter',
db.Column('user_id',
db.Integer,
db.ForeignKey('user.id', ondelete='CASCADE'),
primary_key=True),
db.Column('question_id',
db.Integer,
db.ForeignKey('question.id', ondelete='CASCADE'),
primary_key=True))
class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
subject = db.Column(db.String(200), nullable=False)
content = db.Column(db.Text(), nullable=False)
create_date = db.Column(db.DateTime(), nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey('user.id', ondelete='CASCADE'),
nullable=False)
user = db.relationship('User', backref=db.backref('question_set'))
modify_date = db.Column(db.DateTime(), nullable=True)
voter = db.relationship('User',
secondary=question_voter,
backref=db.backref('question_voter_set'))
answer_voter = db.Table(
'answer_voter',
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(150), unique=True, nullable=False)
password = db.Column(db.String(200), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
question_voter = db.Table(
"question_voter",
db.Column(
"user_id",
db.Integer,
db.ForeignKey("user.id", ondelete="CASCADE"),
primary_key=True,
),
db.Column(
"question_id",
db.Integer,
db.ForeignKey("question.id", ondelete="CASCADE"),
primary_key=True,
),
)
class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
subject = db.Column(db.String(200), nullable=False)
content = db.Column(db.Text(), nullable=False)
create_date = db.Column(db.DateTime(), nullable=False)
modify_date = db.Column(db.DateTime(), nullable=True)
