class Cinema(db.Model):
"""
影院表
"""
cid = db.Column(db.Integer, primary_key=True, autoincrement=True)
# 影院的名称
name = db.Column(db.String(100), unique=True, nullable=False, index=True)
# 城市
city = db.Column(db.String(64))
# 区域
district = db.Column(db.String(64))
# 地址
address = db.Column(db.String(255))
# 联系电话
phone = db.Column(db.String(11))
# 评分
score = db.Column(db.Float(3, 1))
# 影厅的数量
hall_num = db.Column(db.Integer)
# True 营业 false 休息
flag = db.Column(db.Integer, default=1)
# 服务费
service_money = db.Column(db.Numeric(3, 1))
# 限购数量
astrict = db.Column(db.Integer)
# 是否删除
is_delete = db.Column(db.Boolean, default=True)
hs_list = db.relationship('HallScheduling',
lazy='dynamic',
backref='cinema')
halls = db.relationship('Hall', lazy='dynamic', backref='cinema')
class User_6_20(db.Model):
#重命名
# __tablename__ = 't_user'
uid = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), index=True, unique=True, nullable=True)
weight = db.Column(db.Float(10, 2))
#相当于decimal
money = db.Column(db.Numeric(10, 2))
create_date = db.Column(db.DateTime, default=datetime.datetime.now())
#不要在text字段上加索引
msg = db.Column(db.Text())
class Cinema(db.Model):
cid = db.Column(db.Integer, autoincrement=True, primary_key=True)
name = db.Column(db.String(64), nullable=False, index=True, unique=True)
city = db.Column(db.String(64), nullable=False)
district = db.Column(db.String(64), nullable=False)
address = db.Column(db.String(255), nullable=False)
phone = db.Column(db.String(16), nullable=False)
score = db.Column(db.Float(3, 1))
hall_num = db.Column(db.Integer, nullable=False)
# 服务费
service_money = db.Column(db.Numeric(3, 1))
# 限购数量
astrict = db.Column(db.Integer)
# 电影院状态 True营业 False不营业
flag = db.Column(db.Integer, default=1)
is_delete = db.Column(db.Boolean, default=True)
hs_list = db.relationship('HallScheduling',
lazy='dynamic',
backref='cinema')
halls = db.relationship('Hall', lazy='dynamic', backref='cinema')
class Cinemas(db.Model):
cid = db.Column(db.Integer, primary_key=True, autoincrement=True)
# 影院的名称
name = db.Column(db.String(100), unique=True, nullable=False, index=True)
# 城市
city = db.Column(db.String(64))
# 区域
district = db.Column(db.String(64))
# 地址
address = db.Column(db.String(255))
# 联系电话
phone = db.Column(db.String(255))
# 评分
score = db.Column(db.Float(3, 1))
# 影厅的数量
hallnum = db.Column(db.String(100))
# 手续费
servicecharge = db.Column(db.String(100))
# 限购数量
astrict = db.Column(db.String(100))
# True 营业 false 休息
flag = db.Column(db.Integer, default=1)
# 是否删除
isdelete = db.Column(db.Boolean, default=True)
class Rating(db.Model):
sid = db.Column(db.Integer, primary_key=True, autoincrement=True)
# 评分字段
score = db.Column(db.Float(3, 1), default=0.0)
# 关联电影
movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id, ondelete='CASCADE'))
class Rating(db.Model):
rid = db.Column(db.Integer, primary_key=True, autoincrement=True)
score = db.Column(db.Float(3, 1), default=0.0)
movie_id = db.Column(db.Integer,
db.ForeignKey(Movie.id),
onupdate='CASCADE')