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')))