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') # 电影外键关系关联
