class Seat(db.Model, Model):
__tablename__ = "seats"
id = db.Column(db.Integer, primary_key=True)
cinemaID = db.Column(db.Integer, db.ForeignKey("cinemas.id"))
hallID = db.Column(db.Integer, db.ForeignKey("halls.id"))
# 1普通 2沙发 3床
seatType = db.Column(db.Integer)
x = db.Column(db.Integer)
y = db.Column(db.Integer)
isAllowSell = db.Column(db.Boolean, default=True)
# (0损坏、1正常)
flag = db.Column(db.Integer, default=1)
isDelete = db.Column(db.Boolean, default=False)
def __init__(self, cinemaID, hallID, seatType, x, y):
self.cinemaID = cinemaID
self.hallID = hallID
self.seatType = seatType
self.x = x
self.y = y
class Hall(db.Model, Model):
__tablename__ = "halls"
id = db.Column(db.Integer, primary_key=True)
cinemaID = db.Column(db.Integer, db.ForeignKey("cinemas.id"))
name = db.Column(db.String(32))
# 普通、高清、超清
screenType = db.Column(db.String(16))
# 普通、环绕、杜比
soundType = db.Column(db.String(16))
seatNum = db.Column(db.Integer)
# (close关闭、dispark开放)
flag = db.Column(db.Integer, default=FlagStatus.dispark)
isDelete = db.Column(db.Boolean, default=False)
def __init__(self,cinemaID,name,screenType,soundType,seatNum):
self.cinemaID =cinemaID
self.name =name
self.screenType =screenType
self.soundType =soundType
self.seatNum =seatNum
class SeatScheduling(db.Model, Model):
__tablename__ = "seatschedulings"
id = db.Column(db.Integer, primary_key=True)
cinemaID = db.Column(db.Integer, db.ForeignKey("cinemas.id"))
hallID = db.Column(db.Integer, db.ForeignKey("halls.id"))
seatID = db.Column(db.Integer, db.ForeignKey("seats.id"))
hsID = db.Column(db.Integer, db.ForeignKey("hallschedulings.id"))
orderID = db.Column(db.String(128), db.ForeignKey("orders.orderID"))
createTime = db.Column(db.TIMESTAMP(True),
nullable=False,
server_default=text("CURRENT_TIMESTAMP"))
def __init__(self, cinemaID, hallID, seatID, hsID, orderID):
self.cinemaID = cinemaID
self.hallID = hallID
self.seatID = seatID
self.hsID = hsID
self.orderID = orderID
class Cinema(db.Model, Model):
__tablename__ = "cinemas"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(32))
city = db.Column(db.String(32))
district = db.Column(db.String(32))
address = db.Column(db.String(256))
phone = db.Column(db.String(32))
score = db.Column(db.Float)
hallnum = db.Column(db.Integer)
servicecharge = db.Column(db.Float)
astrict = db.Column(db.Integer)
#(business营业、rest休息)
flag = db.Column(db.Integer, default=FlagStatus.business)
isDelete = db.Column(db.Boolean, default=False)
class HallScheduling(db.Model, Model):
__tablename__ = "hallschedulings"
id = db.Column(db.Integer, primary_key=True)
movieID = db.Column(db.Integer, db.ForeignKey("movies.id"))
cinemaID = db.Column(db.Integer, db.ForeignKey("cinemas.id"))
hallID = db.Column(db.Integer, db.ForeignKey("halls.id"))
# originalPrice原价 price售价
pressType = db.Column(db.Integer, default=FlagStatus.price)
originalPrice = db.Column(db.Float)
price = db.Column(db.Float)
startTime = db.Column(db.Time)
duration = db.Column(db.Integer)
createTime = db.Column(db.TIMESTAMP(True),
nullable=False,
server_default=text("CURRENT_TIMESTAMP"))
lastTime = db.Column(db.Time, onupdate=func.now())
#notShow未放映、showing正在放映、endShow结束放映
flag = db.Column(db.Integer, default=FlagStatus.notShow)
isDelete = db.Column(db.Boolean, default=False)
def __init__(self, movieID, cinemaID, hallID, originalPrice, price,
startTime, duration):
self.movieID = movieID
self.cinemaID = cinemaID
self.hallID = hallID
self.originalPrice = originalPrice
self.price = price
self.startTime = startTime
self.duration = duration
class Movie(db.Model, Model):
__tablename__ = "movies"
id = db.Column(db.Integer, primary_key=True)
showName = db.Column(db.String(64))
showNameEN = db.Column(db.String(64))
director = db.Column(db.String(32))
leadingRole = db.Column(db.String(256))
type = db.Column(db.String(64))
country = db.Column(db.String(32))
language = db.Column(db.String(32))
duration = db.Column(db.Integer)
screeningModel = db.Column(db.String(16))
openDay = db.Column(db.Date)
backgroundPicture = db.Column(db.String(256))
# (hotingShow热映 prepareShow即将上映)
flag = db.Column(db.Integer)
isDelete = db.Column(db.Boolean, default=False)
class Order(db.Model, Model):
__tablename__ = "orders"
orderID = db.Column(db.String(128), primary_key=True)
movieID = db.Column(db.Integer, db.ForeignKey("movies.id"))
cinemaID = db.Column(db.Integer, db.ForeignKey("cinemas.id"))
hallID = db.Column(db.Integer, db.ForeignKey("halls.id"))
hsID = db.Column(db.Integer, db.ForeignKey("hallschedulings.id"))
#"1,2,3,4,5,6"
seatIDStr = db.Column(db.String(128))
#"1,2,3,4,5,6"
ssIDStr = db.Column(db.String(128))
qupiaoStr = db.Column(db.String(32))
piaoNum = db.Column(db.Integer)
piaoPrice = db.Column(db.Float)
createTime = db.Column(db.TIMESTAMP(True),
nullable=False,
server_default=text("CURRENT_TIMESTAMP"))
payTime = db.Column(db.Time)
getTime = db.Column(db.Time)
tuikuanTime = db.Column(db.Time)
lastTime = db.Column(db.Time, onupdate=func.now())
#(notPay未支付、payNotTicket已支付未取票、payAndTicket已支付已取票、refundTicket退票)
flag = db.Column(db.Integer, default=FlagStatus.notPay)
isDelete = db.Column(db.Boolean, default=False)
def __init__(self, orderID, movieID, cinemaID, hallID, hsID, seatIDStr,
ssIDStr, piaoNum, piaoPrice):
self.orderID = orderID
self.movieID = movieID
self.cinemaID = cinemaID
self.hallID = hallID
self.hsID = hsID
self.seatIDStr = seatIDStr
self.ssIDStr = ssIDStr
self.piaoNum = piaoNum
self.piaoPrice = piaoPrice