class TransactionProducts(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    transaction_id = db.Column(db.Integer,
                               db.ForeignKey("transactions.id"),
                               nullable=False)
    product_id = db.Column(db.Integer,
                           db.ForeignKey("products.id"),
                           nullable=False)
    product_qty = db.Column(db.Integer, nullable=False)
    transaction = relationship("Transactions", backref="transaction_products")
    product = relationship("Products", backref="transaction_products")
class TransactionProducts(db.Model):
	id = db.Column(db.Integer, primary_key=True, autoincrement=True)
	transaction_id = db.Column(db.Integer, db.ForeignKey("transactions.customer_transaction_id"), nullable=False)
	product_id = db.Column(db.Integer, db.ForeignKey("products.id"), nullable=False)
	product_qty = db.Column(db.Integer, nullable=False)
	transaction = relationship("Transactions", backref="transaction_products")
	#transaction = relationship("Transactions")
	#product = relationship("Products", backref="transaction_products")
	product = relationship("Products")
	event_time = db.Column(db.DateTime, nullable=False)


	def __init__(self):
		self.event_time = datetime.now()