class Shop(db.Model): shop_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), index=True, unique=True) sub_title = db.Column(db.String(64)) original_price = db.Column(db.Numeric(10, 2)) promote_price = db.Column(db.Numeric(10, 2)) stock = db.Column(db.Integer) cate_id = db.Column(db.Integer) create_date = db.Column(db.DateTime, default=datetime.datetime.now())
class HallScheduling(db.Model): hsid = db.Column(db.Integer, primary_key=True, autoincrement=True) # 1未开始 2正在放映 3结束放映 status = db.Column(db.Integer, default=1) start = db.Column(db.DateTime) end = db.Column(db.DateTime) origin_price = db.Column(db.Numeric(7, 2)) current_price = db.Column(db.Numeric(7, 2)) movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id)) cinema_id = db.Column(db.Integer, db.ForeignKey(Cinema.cid)) hall_id = db.Column(db.Integer, db.ForeignKey(Hall.hid)) is_delete = db.Column(db.Boolean, default=True) ss_list = db.relationship('SeatScheduling', lazy='dynamic', backref='hs')
class Goods(db.Model): __tablename__ = "goods" id = db.Column(db.Integer, autoincrement=True, primary_key=True) good_id = db.Column(db.String(32), unique=True) cid = db.Column(db.Integer) # shop_id = db.Column(db.Integer, db.ForeignKey(GcProperty.id)) # 外键 # cid = db.Column(db.Integer) # shop_id = db.Column(db.Integer) # brand_id = db.Column(db.Integer) ################ good_name = db.Column(db.String(255), nullable=False) show_img = db.Column(db.String(255)) good_desc = db.Column(db.String(255)) good_price = db.Column(db.Numeric(11, 2)) # stocks = db.Column(db.Integer) # good_tips = db.Column(db.String(255)) # is_hot = db.Column(db.Integer) # is_new = db.Column(db.Integer) # is_recom = db.Column(db.Integer) # is_sale = db.Column(db.Integer) # good_status = db.Column(db.Integer) # sale_volume = db.Column(db.Integer) # sale_time = db.Column(db.DateTime, default=datetime.datetime.now()) # # 0:删除 1:有效 # is_delete = db.Column(db.Boolean, default=1) # # 创建时间 # create_time = db.Column(db.DateTime, default=datetime.datetime.now())
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 Order(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) # 订单号 no = db.Column(db.String(50), unique=True, nullable=False, index=True) # 关联电影 movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id)) # 影院 cinema_id = db.Column(db.Integer, db.ForeignKey(Cinema.cid)) # 影厅 hs_id = db.Column(db.Integer, db.ForeignKey(HallScheduling.hsid)) # 座位 ss_id = db.Column(db.Integer, db.ForeignKey(SeatScheduling.id)) seat_id = db.Column(db.Integer, db.ForeignKey(Seats.sid)) # 所购票数量 number = db.Column(db.Integer, nullable=False) # 取票码 ticket_code = db.Column(db.String(100)) # 总金额 total = db.Column(db.Numeric(7, 2)) # 创建的时间 create_date = db.Column(db.DateTime, default=datetime.datetime.now()) # 支付时间 pay_date = db.Column(db.DateTime) # 状态 1: 未支付 2: 已支付 3: 支付已使用 4: 支付未使用 status = db.Column(db.SmallInteger) # 支付有效期 out_time = db.Column(db.DateTime, default=datetime.datetime.now() + datetime.timedelta(minutes=15)) is_delete = db.Column(db.Boolean, default=True)
class User(db.Model): # name 表示列名 # __tablename__='' # index 索引 uid = db.Column(db.Integer, primary_key=True, autoincrement=True) username = db.Column(db.String(64), index=True, unique=True, nullable=False) password = db.Column(db.String(100), nullable=False) age = db.Column(db.Integer) create_date = db.Column(db.DateTime) id_delete = db.Column(db.Boolean) price = db.Column(db.Numeric(7, 2)) """ 重要参数 argument 关联的类名 uselist 一对一的关系 一对多必须是设置uselist=True backref 反向引用的名称 lazy 懒加载 """ address_list = db.relationship('Address', uselist=True, backref='user', lazy='dynamic')
class Travel(db.Model): travel_id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(100), unique=True, index=True, nullable=False) price = db.Column(db.Numeric(9, 2), default=0.00, nullable=False) create_date = db.Column(db.DateTime, default=datetime.datetime.now()) is_delete = db.Column(db.Boolean, default=0) images = db.relationship('Image', backref='travel', lazy='dynamic')
class Platoon(db.Model): pid = db.Column(db.Integer, primary_key=True, autoincrement=True) # 原始价格 origin_price = db.Column(db.Numeric(7, 2), default=0.00) # 折扣价 discount_price = db.Column(db.Numeric(7, 2), default=0.00) # 影片开始时间 start_time = db.Column(db.DateTime) end_time = db.Column(db.DateTime) # 1 未放映 2 正在放映 3结束放映 status = db.Column(db.Integer, default=1) create_date = db.Column(db.DateTime, default=datetime.datetime.now()) update_date = db.Column(db.DateTime, default=datetime.datetime.now()) is_delete = db.Column(db.Boolean, default=False) # 外键相关 mid = db.Column(db.Integer, db.ForeignKey(Movies.mid)) hid = db.Column(db.Integer, db.ForeignKey(Halls.hid)) cid = db.Column(db.Integer, db.ForeignKey(Cinemas.cid))
class Destination(db.Model): des_id = db.Column(db.Integer, primary_key=True, autoincrement=True) des_name = db.Column(db.String(100), unique=True, index=True, nullable=False) price = db.Column(db.Numeric(9, 2), default=0.00, nullable=False) create_date = db.Column(db.DateTime, default=datetime.datetime.now()) is_delete = db.Column(db.Boolean, default=0) photo_list = db.relationship('Photo', backref='destination', lazy='dynamic' )
class User(db.Model): user_id = db.Column(db.Integer, autoincrement=True, primary_key=True) username = db.Column(db.String(64), unique=True, index=True, nullable=False) price = db.Column(db.Numeric(10, 2), default=0.00) status = db.Column(db.Boolean, default=False) image = db.Column(db.String(100)) create_date = db.Column(db.DateTime, default=datetime.datetime.now()) desc = db.Column(db.Text)
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 User(db.Model): # name 表示列名 # 修改表名 # __tablename__ = '' user_id = db.Column(db.Integer(), primary_key=True, autoincrement=True) username = db.Column(db.String(64), index=True, unique=True, nullable=False) password = db.Column(db.String(64), nullable=False) age = db.Column(db.Integer) create_date = db.Column(db.DateTime, default=datetime.datetime.now()) is_delete = db.Column(db.Boolean, default=False) # wight = db.Column(db.Float(2)) price = db.Column(db.Numeric(7, 2), nullable=False) addresses = db.relationship('Address', backref='user')
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 Order(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) # 订单号 no = db.Column(db.String(50), unique=True, index=True, nullable=False) movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id), nullable=False) cinema_id = db.Column(db.Integer, db.ForeignKey(Cinema.cid), nullable=False) hs_id = db.Column(db.Integer, db.ForeignKey(HallScheduling.hsid)) ss_id = db.Column(db.Integer, db.ForeignKey(SeatScheduling.id)) seat_id = db.Column(db.Integer, db.ForeignKey(Seats.sid)) # 票数 number = db.Column(db.Integer, nullable=False) # 取票码 ticket_code = db.Column(db.String(100)) # 总金额 total = db.Column(db.Numeric(7, 2)) # 创建的时间 create_date = db.Column(db.DateTime, default=datetime.datetime.now()) pay_date = db.Column(db.DateTime) # 1 表示未支付 2 已支付, 3 表示支付已取票 4 表示支付未取票 5 退票 status = db.Column(db.SmallInteger, nullable=False) # 有效期 out_time = db.Column(db.DateTime, default=datetime.datetime.now() + datetime.timedelta(minutes=15)) is_delete = db.Column(db.Boolean, default=False)
class Detail(db.Model): did = db.Column(db.Integer, primary_key=True) price = db.Column(db.Numeric(10, 2)) sid = db.Column(db.Integer, db.ForeignKey(UserShop.sid))