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)