class InvitationCode(db.Model): ''' 邀请码 ''' __tablename__ = 'invitation_code' id = db.Column(db.Integer, primary_key=True) code = db.Column(db.String(64), unique=True, nullable=False) user = db.Column(db.String(64)) state = db.Column(db.Boolean, default=True)
class Category(db.Model): __tablename__ = 'category' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(64), unique=True, index=True) name = db.Column(db.String(64), unique=True, index=True) desp = db.Column(db.String(300)) articles = db.relationship('Article', backref='category', lazy='dynamic') def __repr__(self): return '<Name %r>' % self.name
class Picture(db.Model): ''' 图片 ''' __tablename__ = 'picture' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64)) timestamp = db.Column(db.DateTime, default=datetime.now) url = db.Column(db.String(120)) remark = db.Column(db.String(32))
class AccessLog(db.Model): ''' 请求日志 ''' __tablename__ = 'access_log' id = db.Column(db.Integer, primary_key=True) ip = db.Column(db.String(20)) url = db.Column(db.String(120)) timestamp = db.Column(db.DateTime, default=datetime.now) remark = db.Column(db.String(32))
class OnlineTool(db.Model): ''' 在线工具 ''' __tablename__ = 'online_tool' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(120)) desp = db.Column(db.String(120)) img = db.Column(db.String(200)) url = db.Column(db.String(200)) sn = db.Column(db.Integer, default=0) state = db.Column(db.Integer, default=1) timestamp = db.Column(db.DateTime, default=datetime.now)
class Recommend(db.Model): ''' 推荐 ''' __tablename__ = 'recommend' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(120)) img = db.Column(db.String(200)) url = db.Column(db.String(200)) sn = db.Column(db.Integer, default=0) state = db.Column(db.Integer, default=1) timestamp = db.Column(db.DateTime, default=datetime.now)
class Category(db.Model): __tablename__ = 'category' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(64), unique=True, index=True) name = db.Column(db.String(64), unique=True, index=True) desp = db.Column(db.String(300)) articles = db.relationship('Article', backref='category', lazy='dynamic') def __repr__(self): return '<Name %r>' % self.name article_tag = db.Table( 'article_tag', db.Column('article_id', db.Integer, db.ForeignKey('article.id'), primary_key=True), db.Column('tag_id', db.Integer, db.ForeignKey('tag.id'), primary_key=True)) class Tag(db.Model): __tablename__ = 'tag' id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(64), nullable=False, unique=True, index=True) def __repr__(self): return '<Name %r>' % self.name class Article(db.Model): __tablename__ = 'article'