# TODO: Create a model called `Event` with the following fields:
# - id: primary key
# - title: String column
# - description: String column
# - date_and_time: DateTime column
# - guests: relationship to "Guest" table with a secondary table
# STRETCH CHALLENGE: Add a field `event_type` as an Enum column that denotes the
# type of event (Party, Study, Networking, etc)
class Event(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(80), nullable=False)
description = db.Column(db.String(200), nullable=False)
date_and_time = db.Column(db.DateTime(100), nullable=False)
guests = db.relationship('Guest',
secondary='table',
back_populates="events_attending")
# TODO: Create a table `guest_event_table` with the following columns:
# - event_id: Integer column (foreign key)
# - guest_id: Integer column (foreign key)
guest_event_table = db.Table(
"table", db.Column('guest_id', db.Integer, db.ForeignKey('guest.id')),
db.Column('event_id', db.Integer, db.ForeignKey('event.id')))
# Create a model called `Event` with the following fields:
# - id: primary key
# - title: String column
# - description: String column
# - date_and_time: DateTime column
# - guests: relationship to "Guest" table with a secondary table
# STRETCH CHALLENGE: Add a field `event_type` as an Enum column that denotes the
# type of event (Party, Study, Networking, etc)
class Event(db.Model):
"""Event model."""
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
description = db.Column(db.String(1000), nullable=False)
date_and_time = db.Column(db.DateTime, nullable=False)
# event_type = db.Column(db.Enum, nullable = True)
guests = db.relationship("Guest",
secondary="guest_event_table",
back_populates="events_attending")
# Create a table `guest_event_table` with the following columns:
# - event_id: Integer column (foreign key)
# - guest_id: Integer column (foreign key)
guest_event_table = db.Table(
"guest_event_table",
db.Column("event_id", db.Integer, db.ForeignKey("event.id")),
db.Column("guest_id", db.Integer, db.ForeignKey("guest.id")))
