class City(db.Model): id = db.Column(db.Integer, primary_key=True) parentId = db.Column(db.Integer, default=0) regionName = db.Column(db.String(100)) cityCode = db.Column(db.Integer, unique=True) pinYin = db.Column(db.String(50)) letter_id = db.Column(db.Integer, db.ForeignKey(CityLetter.id))
class Category(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) catename = db.Column(db.String(100), unique=True) as_name = db.Column(db.String(20), unique=True) key_word = db.Column(db.String(100)) descri = db.Column(db.String(200)) arts = db.relationship('ArtMoel', backref='my_category', lazy=True)
class User(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(20), unique=True) passwd = db.Column(db.String(32)) def to_dict(self): return {'id': self.id, 'name': self.name, 'passwd': self.passwd}
class Catalog(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) category = db.Column(db.String(200)) catename = db.Column(db.String(200)) keypassword = db.Column(db.String(20)) said = db.Column(db.String(200)) articles = db.relationship('Article', backref='my_catalog', lazy=True)
class Preview(BaseModel): __tablename__ = 'preview' title = db.Column(db.String(255), unique=True) # 标题 logo = db.Column(db.String(255), unique=True) # 封面 add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 添加时间
class Auth(BaseModel): __tablename__ = 'auth' name = db.Column(db.String(100), unique=True) # 权限名称 url = db.Column(db.String(255), unique=True) # 权限地址 add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 添加时间
class Blog(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) title = db.Column(db.String(200)) content = db.Column(db.Text) imgurl = db.Column(db.String(250), default='/static/home/images/1.jpg') blog_type = db.Column(db.Integer, db.ForeignKey(BlogType.id)) create_time = db.Column(db.DateTime, default=datetime.now)
class Article(db.Model): id = db.Column(db.Integer,primary_key=True,autoincrement=True) title = db.Column(db.String(200),unique=True) cont = db.Column(db.String(4000)) date = db.Column(db.DateTime,default='2018-10-12 11:12:40') tag = db.Column(db.String(50),default='PHP、JavaScript') press = db.Column(db.Integer,default=0) lanmu = db.Column(db.Integer,db.ForeignKey(Lanmu.id))
class UserModel(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) username = db.Column(db.String(32), unique=True) password = db.Column(db.String(256)) email = db.Column(db.String(64), unique=True) sex = db.Column(db.Boolean(), default=False) icon = db.Column(db.String(256)) is_delete = db.Column(db.Boolean(), default=False)
class Article(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(20)) text = db.Column(db.String(800)) tags = db.Column(db.String(100)) date = db.Column(db.Date) comment_count = db.Column(db.Integer) category_id = db.Column(db.Integer, db.ForeignKey(Category.id))
class Article(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) title = db.Column(db.String(20), unique=True) date = db.Column(db.DateTime) content = db.Column(db.String(2000)) picture = db.Column(db.String(100)) # 与文章分类进行关联 article_class = db.Column(db.Integer, db.ForeignKey(ArticleClass.id))
class ArtMoel(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) title = db.Column(db.String(100), unique=True) content = db.Column(db.Text) keywords = db.Column(db.String(100)) describe = db.Column(db.String(100)) tags = db.Column(db.String(100)) date = db.Column(db.Date) category = db.Column(db.Integer, db.ForeignKey(Category.id))
class Role(BaseModel): __tablename__ = 'role' name = db.Column(db.String(100), unique=True) # 角色名称 auths = db.Column(db.String(600)) # 权限列表 add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 添加时间 admins = db.relationship('Admin', backref='role') # 管理员外键关系关联,backref互相绑定role表
class Classify(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(120), unique=True) mycount = db.Column(db.Integer, default=0) another_name = db.Column(db.String(120), unique=True) articles = db.relationship('Article', backref='my_classify', lazy=True) def __str__(self): return self.name
class MyColumn(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) name = db.Column(db.String(32), unique=True) #名称 other_name = db.Column(db.String(32)) #别名 key_word = db.Column(db.String(32)) #关键字 desc = db.Column(db.String(255)) #描述 # 文章反查 articles = db.relationship('Article',backref='column',lazy=True)
class Artical(db.Model): artical_id = db.Column(db.Integer, primary_key=True, autoincrement=True) artical_title = db.Column(db.String(100), unique=True) artical_content = db.Column(db.Text()) artical_keywords = db.Column(db.String(100)) art_descrip = db.Column(db.Text()) artical_tag = db.Column(db.String(100)) class_id = db.Column(db.Integer, db.ForeignKey(Classfy.class_id)) clsfy = db.relationship('Classfy', backref='articals', lazy=True)
class Article(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(200), unique=True) context = db.Column(db.String(5000)) date = db.Column(db.DateTime, default='2018-10-12 11:12:40') tag = db.Column(db.String(50)) press = db.Column(db.Integer, default=0) myclassify = db.Column(db.Integer, db.ForeignKey(Classify.id)) my_press = db.relationship('Mypress', backref='my_article', lazy=True)
class Classification(db.Model): __tablename__ = 'classification' # 表名 id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(20), unique=True) alias = db.Column(db.String(20)) keyword = db.Column(db.String(20)) content = db.Column(db.String(1000)) parentnode = db.Column(db.String(20)) num = db.Column(db.Integer, default=0) articles = db.relationship('Article', backref='article', lazy='dynamic')
class User(db.Model): # 用户id id = db.Column(db.Integer, primary_key=True, autoincrement=True) # 用户昵称 name = db.Column(db.String(20), unique=True) # 密码 passwd = db.Column(db.String(20)) # 管理员登录账号 username = db.Column(db.String(20), unique=True) # 用户电话 phone = db.Column(db.String(30))
class User(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) username = db.Column(db.String(20), unique=True) password = db.Column(db.String(200)) email = db.Column(db.String(100), unique=True) is_active = db.Column(db.Boolean, default=False) # 激活状态 is_delete = db.Column(db.Boolean, default=False) # 逻辑删除 user_token = db.Column(db.String(100), unique=True) # usertoken # 用户权限 permission = db.Column(db.Integer, default=1)
class Classification(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) name = db.Column(db.String(100), unique=True) alias = db.Column(db.String(100)) # 别名 keyword = db.Column(db.String(100)) # 关键字 parentnode = db.Column(db.String(50)) # 父节点 describe = db.Column(db.Text) # 描述 # 关系,关联文章 contents = db.relationship('Content', backref='my_classification', lazy='dynamic')
class Article(db.Model): __tablename__ = 'article' # 表名 id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(20), unique=True) content = db.Column(db.String(1000), default='无') imgsrc = db.Column(db.String(50), default='无') label = db.Column(db.String(50), default='无') comment = db.Column(db.Integer, default=0) data = db.Column(db.Date) keyword = db.Column(db.String(20)) classification = db.Column(db.Integer, db.ForeignKey(Classification.id))
class Article(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) title = db.Column(db.String(32), unique=True) # 标题 content = db.Column(db.String(2048)) # 内容 key_word = db.Column(db.String(32)) # 关键字 desc = db.Column(db.String(255)) # 描述 tag = db.Column(db.String(32),default='Python') # 标签 atime = db.Column(db.DateTime, default=datetime.now().strftime("%Y-%m-%d %X")) # 时间 # 栏目外键 my_column = db.Column(db.Integer,db.ForeignKey(MyColumn.id))
class Classification(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(100), unique=True) alias = db.Column(db.String(100)) keyword = db.Column(db.String(100)) parentnode = db.Column(db.String(100)) describe = db.Column(db.Text) # 建立一个关系 是让2个模型建立关系,不会在数据库中创建字段的 # 这里是反向关联,用分类中的属性联系到文章 contents = db.relationship("Content", backref="my_classification", lazy="dynamic")
class Content(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) title = db.Column(db.String(200), unique=True) text = db.Column(db.Text) # 文本内容 comment = db.Column(db.Integer, default=0) keyword = db.Column(db.String(50)) describe = db.Column(db.Text) # 描述 label = db.Column(db.String(50), default='无') # 标签 img = db.Column(db.String(200)) data = db.Column(db.DateTime) # 关联栏目外键 classification = db.Column(db.Integer, db.ForeignKey(Classification.id))
class Cinemas(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(50)) city = db.Column(db.String(100)) district = db.Column(db.String(100)) address = db.Column(db.String(100)) phone = db.Column(db.String(100)) score = db.Column(db.Float) hallnum = db.Column(db.Integer) servicecharge = db.Column(db.Float) astrict = db.Column(db.Integer) flag = db.Column(db.Integer, default=1) isdelete = db.Column(db.Boolean, default=False)
class Admin(BaseModel): __tablename__ = 'admin' name = db.Column(db.String(100), unique=True) # 管理员账号 pwd = db.Column(db.String(100)) # 密码 is_super = db.Column(db.SmallInteger) # 是否为超级管理员,0为超级管理员 role_id = db.Column(db.Integer, db.ForeignKey('role.id')) # 所属角色 add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 添加时间 adminlogs = db.relationship( 'AdminLog', backref='admin') # 管理员日志外键关系关联,backref互相绑定admin表 operatelogs = db.relationship('OperateLog', backref='operatelog') # 管理员操作日志外键关系关联
class UserLog(BaseModel): __tablename__ = "userlog" user_id = db.Column(db.Integer, db.ForeignKey('user.id')) # 所属会员 ip = db.Column(db.String(100)) # 登录IP add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 登录时间
class Category(db.Model): # Classification __tablename__ = 'category' # 表名 id = db.Column(db.Integer, primary_key=True, autoincrement=True) # 分类名 name = db.Column(db.String(50), unique=True) # 分类别名 alias = db.Column(db.String(50)) # 关键字 keyword = db.Column(db.String(50)) # 内容 content = db.Column(db.Text) # 父节点 parentnode = db.Column(db.String(50)) # 文章类外键 num = db.Column(db.Integer, default=0) articles = db.relationship('Article', backref='article', lazy='dynamic')
class Tag(BaseModel): __tablename__ = 'tag' name = db.Column(db.String(100), unique=True) # 标题 add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 添加时间 movies = db.relationship('Movie', backref='tag') # 电影外键关系关联