class User(db.Model,UserMixin): __tablename__ = 'User' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) profile = db.Column(db.String(400), nullable=False,default='なし') def __repr__(self): return "User('{}', '{}','{}','{}')".format(self.id, self.username,self.email,self.profile)
class Comment(db.Model): __tablename__ = 'Comment' id = db.Column(db.Integer, primary_key=True) value = db.Column(db.String(400),nullable=False) pdf_id = db.Column(db.Integer,nullable=False,default=1) user_id = db.Column(db.Integer,nullable=False) user_name=db.Column(db.String(20), nullable=False) span_page= db.Column(db.Integer,nullable=False) span_left= db.Column(db.Float,nullable=False) span_top= db.Column(db.Float,nullable=False) created = db.Column(db.DATETIME, default=datetime.now, nullable=False) def __repr__(self): return "comment('{}', '{}','{}','{}','{}','{}','{}','{}','{}')".format(self.id, self.value,self.pdf_id,self.user_id,self.user_name,self.span_page,self.span_left,self.span_top,self.created)
class PDF(db.Model): __tablename__ = 'PDF' id = db.Column(db.Integer, primary_key=True) pdfname = db.Column(db.String(50),nullable=False) user_id = db.Column(db.Integer,nullable=False) created = db.Column('created', db.DATETIME, default=datetime.now, nullable=False) permission = db.Column(db.Integer,default = 1) def __repr__(self): return "PDF('{}', '{}','{}','{}','{}')".format(self.id, self.pdfname,self.user_id,self.created,self.permission)