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