<gh_stars>0
from sqlalchemy import *

class DbSchema:

    _metadata = MetaData()

    mlas = Table('mlas', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('RidingNumber', Integer),
        Column('RidingName', Text),
        Column('Title', Text),
        Column('FirstName', Text),
        Column('LastName', Text),
        Column('HansardName', Text),
        Column('Caucus', Text),
        Column('LegislativePhoneNumber', Text),
        Column('RidingPhoneNumber', Text),
        Column('Email', Text)
    )

    parties = Table('parties', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('Name', Text),
        Column('Seats', Integer)
    )

    documents = Table('documents', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('DateCode', Text),
        Column('DateString', Text),
        Column('Date', Text),
        Column('Url', Text)
    )

    ranks = Table('ranks', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('MLARank', Integer),
        Column('PartyRank', Integer),
        Column('Sentence', Text),
        Column('DocumentId', Integer, ForeignKey("documents.Id")),
        Column('MLAId', Integer, ForeignKey("mlas.Id")),
        Column('Caucus', Text)
    )

    comparison = Table('mlacomparison', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('MLAId', Integer, ForeignKey('mlas.Id')),
        Column('MostSimilar', Integer, ForeignKey('mlas.Id')),
        Column('MostSimilarDistance', Float),
        Column('LeastSimilar', Integer, ForeignKey('mlas.Id')),
        Column('LeastSimilarDistance', Float)
    )

    images = Table('images', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('LastName', Text),
        Column('URL', Text)
    )

from sqlalchemy import *

class DbSchema:

    _metadata = MetaData()

    mlas = Table('mlas', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('RidingNumber', Integer),
        Column('RidingName', Text),
        Column('Title', Text),
        Column('FirstName', Text),
        Column('LastName', Text),
        Column('HansardName', Text),
        Column('Caucus', Text),
        Column('LegislativePhoneNumber', Text),
        Column('RidingPhoneNumber', Text),
        Column('Email', Text)
    )

    parties = Table('parties', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('Name', Text),
        Column('Seats', Integer)
    )

    documents = Table('documents', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('DateCode', Text),
        Column('DateString', Text),
        Column('Date', Text),
        Column('Url', Text)
    )

    ranks = Table('ranks', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('MLARank', Integer),
        Column('PartyRank', Integer),
        Column('Sentence', Text),
        Column('DocumentId', Integer, ForeignKey("documents.Id")),
        Column('MLAId', Integer, ForeignKey("mlas.Id")),
        Column('Caucus', Text)
    )

    comparison = Table('mlacomparison', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('MLAId', Integer, ForeignKey('mlas.Id')),
        Column('MostSimilar', Integer, ForeignKey('mlas.Id')),
        Column('MostSimilarDistance', Float),
        Column('LeastSimilar', Integer, ForeignKey('mlas.Id')),
        Column('LeastSimilarDistance', Float)
    )

    images = Table('images', _metadata,
        Column('Id', Integer, primary_key=True, autoincrement=True),
        Column('LastName', Text),
        Column('URL', Text)
    )