class likes(db.Model):
LikesID = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250),
db.ForeignKey('user.email'),
nullable=False)
pushPinID = db.Column(db.Integer,
db.ForeignKey('pushpin.pushPinID'),
nullable=False)
class comment(db.Model):
commentID = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250),
db.ForeignKey('user.email'),
nullable=False)
content = db.Column(db.String(250), nullable=True)
pushPinID = db.Column(db.Integer,
db.ForeignKey('pushpin.pushPinID'),
nullable=False)
added_time = db.Column(db.DateTime, nullable=True)
class corkboard(db.Model):
corkBoardID = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250),
db.ForeignKey('user.email'),
nullable=False)
cat_name = db.Column(db.String(250),
db.ForeignKey('category.cat_name'),
nullable=False)
title = db.Column(db.String(250), nullable=False)
last_update = db.Column(db.DateTime, nullable=True)
class pushpin(db.Model):
pushPinID = db.Column(db.Integer, primary_key=True)
corkBoardID = db.Column(db.Integer,
db.ForeignKey('corkboard.corkBoardID'),
nullable=False)
image_URL = db.Column(db.String(250), nullable=False)
description = db.Column(db.String(200), nullable=False)
pinned_time = db.Column(db.DateTime, nullable=True)
class watch(db.Model):
WatchID = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(250), nullable=False)
corkBoardID = db.Column(db.Integer,
db.ForeignKey('corkboard.corkBoardID'),
nullable=False)
class tag(db.Model):
tagID = db.Column(db.Integer, primary_key=True)
pushPinID = db.Column(db.Integer,
db.ForeignKey('pushpin.pushPinID'),
nullable=False)
tag = db.Column(db.String(20), nullable=False)
class privatecorkboard(db.Model):
corkBoardID = db.Column(db.Integer,
db.ForeignKey('corkboard.corkBoardID'),
primary_key=True)
password = db.Column(db.String(250), nullable=False)
last_update = db.Column(db.DateTime, nullable=True)