class SampleCases(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
s_description = db.Column(db.String(64))
s_type = db.Column(db.String(32))
s_modelClsId = db.Column(db.Integer, db.ForeignKey(Cnns.id))
s_modelDetId = db.Column(db.Integer, db.ForeignKey(Cnns.id))
s_dataId = db.Column(db.Integer, db.ForeignKey(DataSets.id))
class Orders(db.Model, BaseModel):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
money = db.Column(db.Integer, nullable=False)
paytime = db.Column(db.DateTime, default=datetime.now)
uid = db.Column(db.Integer, db.ForeignKey('bbs_user.uid'))
tid = db.Column(db.Integer, db.ForeignKey('bbs_posts.id'))
__tablename__ = 'bbs_order'
class ApiCases(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
a_description = db.Column(db.String(64))
a_level = db.Column(db.String(16))
a_type = db.Column(db.String(32))
a_modelId = db.Column(db.Integer, db.ForeignKey(Cnns.id))
a_dataId = db.Column(db.Integer, db.ForeignKey(DataSets.id))
class HallMovie(BaseModel):
h_movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id))
h_hall_id = db.Column(db.Integer, db.ForeignKey(Hall.id))
h_time = db.Column(db.DateTime)
class Video(db.Model):
__tablename__ = 'video'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255), unique=True)
url = db.Column(db.String(255), unique=True) # 地址
info = db.Column(db.Text) # 简介
logo = db.Column(db.String(255), unique=True) # 封面
star = db.Column(db.SmallInteger) # 星级评分
playnum = db.Column(db.BigInteger) # 播放量
commentnum = db.Column(db.BigInteger) # 评论量
col_num = db.Column(db.Integer, default=0) #收藏量
up_num = db.Column(db.Integer, default=0)
tag_id = db.Column(db.Integer, db.ForeignKey('tag.id')) # 所属标签
user_id = db.Column(db.Integer, db.ForeignKey('user.id')) # 所属用户
comments = db.relationship('Comment', backref='video') # 评论
video_cols = db.relationship('Videocol', backref='video') # 收藏
video_ups = db.relationship('Videoup', backref='video') #点赞
release_time = db.Column(db.Date) # 上映时间
area = db.Column(db.String(255)) # 上映地区
length = db.Column(db.String(100)) # 播放时长
addtime = db.Column(db.DateTime, index=True,
default=datetime.now()) # 添加时间
def __repr__(self):
return "<Video %r>" % self.title
class Flight(BaseModel):
__tablename__ = 'cinema_flight'
f_movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id))
f_hall_id = db.Column(db.Integer, db.ForeignKey(Hall.id))
f_time = db.Column(db.DateTime)
f_price = db.Column(db.Float, default=40.0)
movieorder = db.relationship('MovieOrder', backref='Flight', lazy=True)
class Order(BaseModel, db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
o_user = db.Column(db.Integer, db.ForeignKey(User.id))
o_movie_plan = db.Column(db.String(128), db.ForeignKey(MoviePlan.id))
# 1：已下单，未付款 2：已下单，已付款 3.....
o_status = db.Column(db.Integer, default=1)
class MovieOrder(BaseModel):
__tablename__ = 'movie_order'
o_user_id = db.Column(db.Integer, db.ForeignKey(MovieUser.id))
o_flight_id = db.Column(db.Integer, db.ForeignKey(Flight.id))
o_status = db.Column(db.Integer, default=ORDER_STATUS_NOT_PAY)
o_time = db.Column(db.DateTime)
o_seat = db.Column(db.String(128))
o_price = db.Column(db.Float)
class SeatOrder(BaseModel):
s_user = db.Column(db.Integer, db.ForeignKey(ViewerUser.id))
s_paidang = db.Column(db.Integer, db.ForeignKey(PaiDang.id))
s_price = db.Column(db.Float, default=1)
s_seats = db.Column(db.String(128))
s_status = db.Column(db.Integer, default=SEAT_ORDER_STATUS_NOT_PAY)
s_expire = db.Column(db.DateTime)
class MovieOrder(BaseModel):
# o_user_id = db.Column(db.Integer, db.ForeignKey(MovieUser.id))
o_user_id = db.Column(db.Integer, db.ForeignKey("movie_user.id"))
o_hall_movie_id = db.Column(db.Integer, db.ForeignKey("hall_movie.id"))
o_time = db.Column(db.DateTime)
o_status = db.Column(db.Integer, default=ORDER_STATUS_NOT_PAY)
o_seats = db.Column(db.String(128))
o_price = db.Column(db.Float, default=0)
class Videoup(db.Model):
__tablename__ = "videoup"
id = db.Column(db.Integer, primary_key=True)
video_id = db.Column(db.Integer, db.ForeignKey('video.id'))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
addtime = db.Column(db.DateTime, index=True, default=datetime.now())
def __repr__(self):
return "<Videocol %r>" % self.id
class Tasks(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
t_description = db.Column(db.String(64))
t_caseType = db.Column(db.String(16))
t_hostId = db.Column(db.Integer, db.ForeignKey(Hosts.id))
t_apiCaseId = db.Column(db.Integer, db.ForeignKey(ApiCases.id))
t_sampleCaseId = db.Column(db.Integer, db.ForeignKey(SampleCases.id))
t_duration = db.Column(db.Integer, default=1)
t_status = db.Column(db.String(16))
class ModelResponse(db.Model):
response_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer)
trial_number = db.Column(db.Integer)
recorded_response = db.Column(db.Integer,
db.ForeignKey('answer.answer_id'))
expected_response = db.Column(db.Integer,
db.ForeignKey('answer.answer_id'))
correct = db.Column(db.Boolean)
class MoviePlan(db.Model):
id = db.Column(db.String(128), primary_key=True)
mp_movie = db.Column(db.Integer, db.ForeignKey(Movie.id))
mp_hall = db.Column(db.Integer, db.ForeignKey(Hall.id))
mp_time = db.Column(db.DateTime)
class HallMovie(BaseModel):
h_movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id))
h_hall_id = db.Column(db.Integer, db.ForeignKey(Hall.id))
h_time = db.Column(db.DateTime)
h_orders = db.relationship('MovieOrder', backref='HallMovie', lazy=True)
class Comment(db.Model):
__tablename__ = "comment"
id = db.Column(db.Integer, primary_key=True)
content = db.Column(db.Text)
video_id = db.Column(db.Integer, db.ForeignKey('video.id'))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
addtime = db.Column(db.DateTime, index=True, default=datetime.now())
def __repr__(self):
return "<Comment %r>" % self.id
class Cart(db.Model):
__tablename__ = 'axf_cart'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
c_user = db.Column(db.INTEGER, db.ForeignKey(AXFUser.id))
c_goods = db.Column(db.INTEGER, db.ForeignKey(Goods.id))
c_goods_num = db.Column(db.INTEGER, default=1)
c_is_select = db.Column(db.Boolean, default=True)
class Message(BaseModel):
body = db.Column(db.Text, nullable=False)
timestamp = db.Column(db.DateTime, default=datetime.now(), index=True)
message_author = db.Column(db.Integer,
db.ForeignKey('user.id'),
nullable=False)
message_room = db.Column(db.Integer,
db.ForeignKey('room.id'),
nullable=False)
class Reply(db.Model, BaseModel):
rid = db.Column(db.Integer, primary_key=True, autoincrement=True)
content = db.Column(db.String(1000))
istop = db.Column(db.Integer, default=0) # 置顶
isdel = db.Column(db.SmallInteger, default=0) # 删除 0表示未删除，1表示删除
isblock = db.Column(db.SmallInteger, default=0)
createtime = db.Column(db.DateTime, default=datetime.now)
uid = db.Column(db.Integer, db.ForeignKey('bbs_user.uid'))
tid = db.Column(db.Integer,
db.ForeignKey('bbs_posts.id', ondelete='CASCADE'))
__tablename__ = 'bbs_reply'
class CommentLike(BaseModel, db.Model):
"""评论点赞"""
__tablename__ = "info_comment_like"
comment_id = db.Column("comment_id",
db.Integer,
db.ForeignKey("info_comment.id"),
primary_key=True) # 评论编号
user_id = db.Column("user_id",
db.Integer,
db.ForeignKey("info_user.id"),
primary_key=True) # 用户编号
class ItemInfo(BaseModel):
id = db.Column(db.String(64), primary_key=True)
info = db.Column(db.String(16))
type = db.Column(db.String(16),
db.ForeignKey(ItemType.type, ondelete="SET DEFAULT"),
default="其它")
image = db.Column(db.String(128))
desc = db.Column(db.String(1024))
date = db.Column(db.DateTime)
place = db.Column(db.String(64))
campus = db.Column(db.String(32))
uid = db.Column(db.String(16), db.ForeignKey(User.id))
claim_date = db.Column(db.DateTime)
is_claim = db.Column(db.Boolean, default=False)
is_delete = db.Column(db.Boolean, default=False)
class Appointment(db.Model):
# 给表重新定义一个名称，默认名称是类名的小写，appointment借阅记录。
__tablename__ = "appointment"
appointmentID = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
userID = db.Column(db.String(7),
db.ForeignKey('client.userID'),
nullable=False)
bookID = db.Column(db.String(7),
db.ForeignKey('book.bookID'),
nullable=False)
bookNum = db.Column(db.Integer, nullable=True)
DataTime = db.Column(db.DateTime, default=datetime.datetime.now)
class Ticket(BaseModel, db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
t_order = db.Column(db.Integer, db.ForeignKey(Order.id))
t_seat = db.Column(db.Integer)
class City(BaseModel):
letter_id = db.Column(db.Integer, db.ForeignKey(Letter.id))
c_id = db.Column(db.Integer, default=0)
c_parent_id = db.Column(db.Integer, default=0)
c_region_name = db.Column(db.String(16))
c_city_code = db.Column(db.Integer, default=0)
c_pinyin = db.Column(db.String(64))
class City(db.Model):
id = db.Column(db.Integer, primary_key=True)
regionName = db.Column(db.String(16))
cityCode = db.Column(db.Integer)
pinYin = db.Column(db.String(128))
#外键设置的语法 是 ForeignKey（类名.主键名字）
letter = db.Column(db.Integer, db.ForeignKey(Letter.id))
class Comment(BaseModel, db.Model):
"""评论"""
__tablename__ = "info_comment"
id = db.Column(db.Integer, primary_key=True) # 评论编号
user_id = db.Column(db.Integer,
db.ForeignKey("info_user.id"),
nullable=False) # 用户id
news_id = db.Column(db.Integer,
db.ForeignKey("info_blog.id"),
nullable=False) # blog的id
content = db.Column(db.Text, nullable=False) # 评论内容
parent_id = db.Column(db.Integer,
db.ForeignKey("info_comment.id")) # 父评论id
parent = db.relationship("Comment", remote_side=[id]) # 自关联
like_count = db.Column(db.Integer, default=0) # 点赞条数
class Blog(BaseModel, db.Model):
"""博客"""
__tablename__ = "info_blog"
id = db.Column(db.Integer, primary_key=True) # 用户编号
title = db.Column(db.String(256), nullable=False) # 标题
source = db.Column(db.String(64), nullable=False) # 来源
digest = db.Column(db.String(512), nullable=False) # 摘要
index_image_url = db.Column(db.String(256)) # 博客列表图片路径
category_id = db.Column(db.Integer, db.ForeignKey("info_category.id"))
user_id = db.Column(db.Integer,
db.ForeignKey("info_user.id")) # 当前blog的作者id
status = db.Column(db.Integer,
default=0) # 当前blog状态 如果为0代表审核通过，1代表审核中，-1代表审核不通过
reason = db.Column(db.String(256)) # 未通过原因，status = -1 的时候使用
# 当前新闻的所有评论
comments = db.relationship("Comment", lazy="dynamic")
class Post(db.Model):
__tablename__ = "user_post"
id = db.Column(db.Integer(), primary_key=True, autoincrement=True)
title = db.Column(db.String(100))
text = db.Column(db.Text())
publish_date = db.Column(db.DateTime())
user_id = db.Column(db.Integer(), db.ForeignKey('user.id'))
class City(db.Model):
id = db.Column(db.Integer, primary_key=True)
parentId = db.Column(db.Integer, default=0)
regionName = db.Column(db.String(100))
cityCode = db.Column(db.Integer)
pinYin = db.Column(db.String(40))
c_letter = db.Column(db.Integer, db.ForeignKey(Letter.id))
class User(ModelBase, db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
u_name = db.Column(db.String(16), unique=True)
u_age = db.Column(db.Integer)
a_id = db.Column(db.Integer, db.ForeignKey('address.id'))
address = db.relationship('Address',
backref=db.backref('user', lazy='dynamic'))