class Cities(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=False)
parentId = db.Column(db.Integer, default=0)
regionName = db.Column(db.String(32))
cityCode = db.Column(db.Integer)
pinYin = db.Column(db.String(32))
letter_id = db.Column(db.Integer, db.ForeignKey(Letter.id))
class User(db.Model):
u_id = db.Column(db.Integer, autoincrement=True, primary_key=True)
u_name = db.Column(db.String(32), unique=True)
u_passwd = db.Column(db.String(256), nullable=False)
active = db.Column(db.Boolean, default=0)
# 权限
permission = db.Column(db.Integer)
token = db.Column(db.String(128), unique=True)
email = db.Column(db.String(64))
class Cinemas(db.Model, Settings):
id = db.Column(db.Integer, autoincrement=True, primary_key=True)
name = db.Column(db.String(64))
city = db.Column(db.String(32))
district = db.Column(db.String(32))
address = db.Column(db.String(128))
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)
flag = db.Column(db.Integer)
isdelete = db.Column(db.Boolean)
class Orders(db.Model, Settings):
id = db.Column(db.String(128), primary_key=True, autoincrement=False)
total_price = db.Column(db.Float)
user_id = db.Column(db.Integer, db.ForeignKey(User.u_id))
movie_id = db.Column(db.Integer, db.ForeignKey(Movies.id))
# order_time = db.Column(db.DateTime)
pay_time = db.Column(db.DateTime)
seat_num = db.Column(db.Integer)
class Movies(db.Model,Settings):
id = db.Column(db.Integer,primary_key=True,autoincrement=False)
showname = db.Column(db.String(128))
shownameen = db.Column(db.String(128))
director = db.Column(db.String(64))
leadingRole = db.Column(db.String(256))
type = db.Column(db.String(64))
country = db.Column(db.String(64))
language = db.Column(db.String(64))
duration = db.Column(db.Integer)
screeningmodel = db.Column(db.String(32))
openday = db.Column(db.Date)
backgroundpicture = db.Column(db.String(64))
flag = db.Column(db.Integer)
isdelete = db.Column(db.Boolean)
class Letter(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
letter = db.Column(db.String(2))