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)