class MovieCollect(BaseModel):
__tablename__ = 'moviecollect'
movie_id = db.Column(db.Integer,
db.ForeignKey('movie.id')) # 所属电影，在movie表中创建关联
user_id = db.Column(db.Integer,
db.ForeignKey('user.id')) # 所属用户，在user表中创建外键关联
add_time = db.Column(db.DateTime,
index=True,
default=datetime.datetime.utcnow) # 添加时间
class Comment(BaseModel):
__tablename__ = 'comment'
content = db.Column(db.Text) # 评论内容
movie_id = db.Column(db.Integer,
db.ForeignKey('movie.id')) # 所属电影，在movie表中创建关联
user_id = db.Column(db.Integer,
db.ForeignKey('user.id')) # 所属用户，在user表中创建外键关联
add_time = db.Column(db.DateTime,
index=True,
default=datetime.datetime.utcnow) # 添加时间
class Comment(db.Model):
__tablename__ = 'comment'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
content = db.Column(db.Text, nullable=False)
create_time = db.Column(db.DateTime, default=datetime.now)
# 外键1
question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
# 外键2
author_id = db.Column(db.Integer, db.ForeignKey('user.id'))
# 参数order_by = create_time.desc()表示获取question对应的comments时是按时间倒序的
question = db.relationship('Question',
backref=db.backref('comments',
order_by=create_time.desc()))
author = db.relationship('User', backref=db.backref('comments'))
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 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 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 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 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 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 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 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 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 Question(db.Model):
__tablename__ = 'question'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(100), nullable=False)
desc = db.Column(db.Text, nullable=False)
# 注意是：datetime.now。now是每次创建一个模型的时候都获取当前时间，now()是服务器第一次运行的时间
create_time = db.Column(db.DateTime, default=datetime.now)
# 使用外键,db.ForeignKey('user.id')指定外键用到的是user表的id字段
author_id = db.Column(db.Integer, db.ForeignKey('user.id'))
# 建立关系屬性,参数1表示要引用的模型，参数2指定反转时要用到的属性，就是User模型通过哪个属性来获取当前用户发布的所有问题
author = db.relationship('User', backref=db.backref('questions'))
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 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 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 Movie(BaseModel):
__tablename__ = 'movie'
title = db.Column(db.String(255), unique=True) # 标题
url = db.Column(db.String(255), unique=True) # 播放地址
info = db.Column(db.Text) # 简介
logo = db.Column(db.String(255), unique=True) # 封面
star = db.Column(db.SmallInteger) # 星级
play_num = db.Column(db.BigInteger) # 播放量
comment_num = db.Column(db.BigInteger) # 评论量
tag_id = db.Column(db.Integer, db.ForeignKey('tag.id')) # 所属标签
area = db.Column(db.String(255)) # 上映地区
release_time = db.Column(db.Date) # 上映时间
length = db.Column(db.String(100)) # 播放时长
add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 添加时间
comments = db.relationship('Comment', backref='movie') # 用户评论外键关系关联
moviecollects = db.relationship('MovieCollect', backref='movie') # 用户收藏电影外键关系关联
class Article(db.Model):
__tablename__ = 'article' # 表名
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(50), unique=True)
# 内容详情
content = db.Column(db.Text, default='无')
# 文章简述
desc = db.Column(db.String(200))
# 图片地址
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.DateTime)
# 关键字
keyword = db.Column(db.String(50))
# 与分类的id关联的外键
classification = db.Column(db.Integer, db.ForeignKey(Category.id))
class CartModel(db.Model):
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
user = db.Column(db.Integer, db.ForeignKey(UserModel.id))
goods = db.Column(db.Integer, db.ForeignKey(Goods.id))
c_num = db.Column(db.Integer, default=1)
is_select = db.Column(db.Boolean, default=True)
class Article(db.Model):
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
title = db.Column(db.String(20), unique=True)
detail = db.Column(db.String(2000))
catalogid = db.Column(db.Integer, db.ForeignKey(Catalog.id))
class OperateLog(BaseModel):
__tablename__ = "operatelog"
admin_id = db.Column(db.Integer, db.ForeignKey('admin.id')) # 所属管理员
ip = db.Column(db.String(100)) # 登录ip
reason = db.Column(db.String(600)) # 操作原因
add_time = db.Column(db.DateTime, index=True, default=datetime.datetime.utcnow) # 时间
class Article(db.Model):
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
name = db.Column(db.String(200))
content = db.Column(db.String(255))
my_sort = db.Column(db.Integer, db.ForeignKey(Sort.id))
pic = db.Column(db.Integer)
class Mypress(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
content = db.Column(db.String(1000))
date = db.Column(db.DateTime, default='2018-10-12 11:12:40')
articles = db.Column(db.Integer, db.ForeignKey(Article.id))
class OrderGoodsModel(db.Model):
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
goods = db.Column(db.Integer, db.ForeignKey(Goods.id))
order = db.Column(db.Integer, db.ForeignKey(OrderModel.id))
goods_num = db.Column(db.Integer, default=1)
class OrderModel(db.Model):
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
user = db.Column(db.Integer, db.ForeignKey(UserModel.id))
o_num = db.Column(db.String(64))
o_status = db.Column(db.Integer, default=0)
o_create = db.Column(db.DateTime, )
