class Group(db.Model):
__tablename__ = 'group'
gid = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
man_user_id = db.Column(db.Integer)
description = db.Column(db.String)
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
class Papertag(db.Model):
__tablename__ = 'paper_tag'
paper_id = db.Column(db.Integer, primary_key=True)
tag_id = db.Column(db.Integer, primary_key=True)
def __repr__(self):
return '<Papertag paper_id=%s,tag_id=%s>' % (self.paper_id, self.tag_id)
class Record(db.Model):
__tablename__ = 'record'
rid = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer)
content = db.Column(db.String)
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
chapter = db.Column(db.Integer)
class Tag(db.Model):
__tablename__ = 'tag'
tag_id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
def __repr__(self):
return '<Tag tag_id=%s>' % self.tag_id
class Catalog(db.Model):
__tablename__ = 'catalog'
catalog_id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
level = db.Column(db.Integer)
pcatalog_id = db.Column(db.Integer)
def __repr__(self):
return '<Catalog catalog_id=%s>' % self.catalog_id
class Photo(db.Model):
__tablename__ = 'photo'
pid = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
fid = db.Column(db.Integer)
description = db.Column(db.String)
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
album_id = db.Column(db.Integer)
tag_ids = db.Column(db.String)
status = db.Column(db.Integer, default=0)
class Essay(db.Model):
__tablename__ = 'essay'
eid = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
content = db.Column(LONGTEXT)
author = db.Column(db.String(255))
catalog_id = db.Column(db.Integer)
photos = db.Column(db.String(255))
videos = db.Column(db.String(255))
status = db.Column(db.Integer)
def __repr__(self):
return '<Essay essay_id=%s>' % self.essay_id
class Paper(db.Model):
__tablename__ = 'paper'
paper_id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
content = db.Column(LONGTEXT)
author = db.Column(db.String(255))
catalog_id = db.Column(db.Integer)
status = db.Column(db.Integer, default=0)
book_id = db.Column(db.Integer)
update_time = db.Column(db.DateTime)
def __repr__(self):
return '<Paper paper_id=%s>' % self.paper_id
class Note(db.Model):
__tablename__ = 'note'
nid = db.Column(db.Integer, primary_key=True)
content = db.Column(db.String)
status = db.Column(db.Integer, default=1)
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
start_time = db.Column(db.DateTime)
end_time = db.Column(db.DateTime)
finish_time = db.Column(db.DateTime)
class Album(db.Model):
__tablename__ = 'album'
aid = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
description = db.Column(db.String)
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
tag_ids = db.Column(db.String)
cover = db.Column(db.Integer)
status = db.Column(db.Integer, default=0)
class User(db.Model):
__tablename__ = 'user'
user_id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
password = db.Column(db.String(255))
phone = db.Column(db.String(255))
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
openid = db.Column(db.String(255))
p_openid = db.Column(db.String(255))
unionid = db.Column(db.String(255))
def __repr__(self):
return '<User user_id=%s>' % self.user_id
class Book(db.Model):
__tablename__ = 'book'
book_id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
description = db.Column(db.String(255))
status = db.Column(db.Integer, default=0)
create_time = db.Column(db.DateTime, default=mytime.get_now_datetime)
update_time = db.Column(db.DateTime)
class UserGroup(db.Model):
__tablename__ = 'user_group'
user_id = db.Column(db.Integer, primary_key=True)
group_id = db.Column(db.Integer, primary_key=True)
class File(db.Model):
__tablename__ = 'file'
fid = db.Column(db.Integer, primary_key=True)
type = db.Column(db.String)
name = db.Column(db.String)
path = db.Column(db.String)
