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)