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, )