class Show(db.Model):
__tablename__ = 'Shows'
id = db.Column(db.Integer, primary_key=True)
start_time = db.Column(db.DateTime)
venue_id = db.Column(db.Integer, db.ForeignKey('Venues.id'), nullable=False)
venue = db.relationship('Venue', back_populates='shows', lazy='joined')
artist_id = db.Column(db.Integer, db.ForeignKey('Artists.id'), nullable=False)
artist = db.relationship('Artist', back_populates='shows', lazy='joined')
class Artist(db.Model):
__tablename__ = 'Artists'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
phone = db.Column(db.String(120))
website_link = db.Column(db.String(500))
image_link = db.Column(db.String(500))
facebook_link = db.Column(db.String(120))
seeking_venue = db.Column(db.Boolean)
seeking_description = db.Column(db.String(500))
city_id = db.Column(db.Integer, db.ForeignKey('Cities.id'), nullable=False)
city = db.relationship('City', back_populates='artists', lazy='joined')
shows = db.relationship('Show', back_populates='artist', lazy='joined')
genres = db.relationship("Genre",
secondary=artistgenre_table,
back_populates="artists",
lazy='joined')
from data_access import db
artistgenre_table = db.Table(
'ArtistsGenres',
db.Column('artist_id',
db.Integer,
db.ForeignKey('Artists.id'),
primary_key=True),
db.Column('genre_id',
db.Integer,
db.ForeignKey('Genres.id'),
primary_key=True))
from data_access import db
venuegenre_table = db.Table('VenuesGenres',
db.Column('venue_id', db.Integer, db.ForeignKey('Venues.id'), primary_key=True),
db.Column('genre_id', db.Integer, db.ForeignKey('Genres.id'), primary_key=True)
)
from data_access import db
movie_genre_table = db.Table("movies_genres", db.Column("movie_id", db.Integer, db.ForeignKey("movies.id"), primary_key=True), db.Column("genre_id", db.Integer, db.ForeignKey("genres.id"), primary_key=True))
from data_access import db
movie_language_table = db.Table(
"movies_languages",
db.Column("movie_id",
db.Integer,
db.ForeignKey("movies.id"),
primary_key=True),
db.Column("language_id",
db.Integer,
db.ForeignKey("languages.id"),
primary_key=True))