class City(db.Model):
__tablename__ = 'city'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120))
venues = db.relationship('Venue', backref='city', lazy=True)
artists = db.relationship('Artist', backref='city', lazy=True)
state_id = db.Column(db.Integer, db.ForeignKey('state.id'))
class Venue(db.Model):
__tablename__ = 'venue'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
address = db.Column(db.String(120))
phone = db.Column(db.String(120))
city_id = db.Column(db.Integer, db.ForeignKey('city.id'))
image_link = db.Column(db.String(500))
facebook_link = db.Column(db.String(120))
website = db.Column(db.String(500), nullable=True)
seeking_talent = db.Column(db.Boolean)
seeking_description = db.Column(db.String(500), nullable=True)
shows = db.relationship('Show', backref=db.backref('venue', lazy='joined'))
genres = db.relationship(
'Genre', secondary=venue_genres, backref=db.backref('venues', lazy='dynamic'))
class Artist(db.Model):
__tablename__ = 'artist'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String)
phone = db.Column(db.String(120))
city_id = db.Column(db.Integer, db.ForeignKey('city.id'))
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), nullable=True)
website = db.Column(db.String(500), nullable=True)
genres = db.relationship('Genre',
secondary=artist_genres,
backref=db.backref('artists', lazy='dynamic'))
shows = db.relationship('Show',
backref=db.backref('artist', lazy='select'))
class Show(db.Model):
__tablename__ = 'show'
id = db.Column(db.Integer, primary_key=True)
artist_id = db.Column('artist_id', db.Integer, db.ForeignKey('artist.id'))
venue_id = db.Column('venue_id', db.Integer, db.ForeignKey('venue.id'))
start_time = db.Column(db.DateTime(timezone=True))
class State(db.Model):
__tablename__ = 'state'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120))
cities = db.relationship('City', backref='state', lazy=True)
class Genre(db.Model):
__tablename__ = 'genre'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
from startup.db import db
class Genre(db.Model):
__tablename__ = 'genre'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
venue_genres = db.Table(
'venue_genres', db.Column('genre_id', db.Integer,
db.ForeignKey('genre.id')),
db.Column('venue_id', db.Integer, db.ForeignKey('venue.id')))
artist_genres = db.Table(
'artist_genres',
db.Column('genre_id', db.Integer, db.ForeignKey('genre.id')),
db.Column('artist_id', db.Integer, db.ForeignKey('artist.id')))