class Draw(db.Model):
__tablename__ = 'draw'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
create_user_id = db.Column(db.Integer, index=True, nullable=False)
name = db.Column(db.String(40))
create_time = db.Column(db.Integer, default=time)
class DrawRecord(db.Model):
__tablename__ = 'draw_record'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
draw_id = db.Column(db.Integer, index=True, nullable=False)
content = db.Column(db.String(40))
total_count = db.Column(db.Integer, nullable=False)
create_time = db.Column(db.Integer, default=time)
class UserToken(db.Model):
__tablename__ = 'user_token'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, unique=True, nullable=False)
token = db.Column(db.String(40), unique=True)
create_time = db.Column(db.Integer, default=time)
class Activity(db.Model):
__tablename__ = 'activity'
id = db.Column(db.Integer, primary_key=True)
create_user_id = db.Column(db.Integer, index=True, nullable=False)
name = db.Column(db.String(80))
create_time = db.Column(db.Integer, index=True, default=time)
end_time = db.Column(db.Integer)
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
open_id = db.Column(db.String(80), unique=True, nullable=False)
username = db.Column(db.String(40))
user_avatar = db.Column(db.String(1024))
def __repr__(self):
return '<User %r>' % self.open_id
class DrawParticipant(db.Model):
__tablename__ = 'draw_participant'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
draw_record_id = db.Column(db.Integer, index=True, nullable=False)
create_time = db.Column(db.Integer, default=time)
user_id = db.Column(db.Integer, nullable=False, index=True)
draw_id = db.Column(db.Integer, index=True, nullable=False)
__table_args__ = (UniqueConstraint('user_id',
'draw_id',
name='uix_user_draw'))
class ActivityParticipant(db.Model):
TYPE = EmuObject((
('agree', 1, '参加'),
('refuse', 2, '拒绝'))
)
__tablename__ = 'activity_participant'
id = db.Column(db.Integer, primary_key=True)
activity_id = db.Column(db.Integer, index=True, nullable=False)
user_id = db.Column(db.Integer, index=True, nullable=False)
create_time = db.Column(db.Integer, index=True, default=time)
is_creator = db.Column(db.Boolean, default=False)
type = db.Column(db.SmallInteger, default=TYPE.agree)
def type_desc(self):
self.TYPE.get_desc(self.type)