class Product(db.Model):

    __tablename__ = "product"
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String)
    description = db.Column(db.String)

class ProductUser(db.Model):

    __tablename__ = "userproducts"
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    quantity = db.Column(db.Integer)

	product_id = db.Column(db.Integer, db.Foreignkey('product_id'))
    product = db.releationship('Product',
        backref=db.backref('users', lazy='dynamic'))


    user_id = db.Column(db.Integer,db.Foreignkey('user_id'))
    user = db.releationship('User',
        backref=db.backref('products', lazy='dynamic'))


class User(db.Model):

    __tablename__ = "users"
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    username = db.Column(db.String)
    password = db.Column(db.String)

    def __init__(self, username, password):
        self.username = username
        self.password = password

    def __repr__(self):
        return '<User %r>' % self.username