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