class Notifications_v2(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(600), nullable=False) email = db.Column(db.String(600), nullable=False) subscribed_to = db.Column(db.Integer, db.ForeignKey('users_v2.id'), nullable=False)
class Event(db.Model): id = db.Column(db.Integer, primary_key=True) event_name = db.Column(db.String(500), nullable=False) details = db.Column(db.String(2000)) start_time = db.Column(db.DateTime) end_time = db.Column(db.DateTime) owner_id = db.Column(db.Integer, db.ForeignKey("user.id"))
class Comments(db.Model): id = db.Column(db.Integer, primary_key=True) comment = db.Column(db.String(600), nullable=False) commenter_name = db.Column(db.String(600), nullable=False) comment_time = db.Column(db.String(600), nullable=False) comment_likes = db.Column(db.Integer) comment_message = db.Column(db.Integer, db.ForeignKey('messages.id'), nullable=False)
class Groups(db.Model): id = db.Column(db.Integer, primary_key=True) group_name = db.Column(db.String(500)) group_emails = db.Column(db.String(500)) owner_id = db.Column(db.Integer, db.ForeignKey("user.id"))
class Invites(db.Model): id = db.Column(db.Integer, primary_key=True) invitee_email = db.Column(db.String(500)) accepted = db.Column(db.Boolean, default=False) event_id = db.Column(db.Integer, db.ForeignKey("event.id"))