Python ForeignKey Beispiele

Beispiel #1

class WishlistModel(db.Model):
    __tablename__ = 'Mywhislist'
    id = db.Column(db.Integer, primary_key=True)
    product_id = db.Column(db.Integer,
                           db.ForeignKey('product.id'),
                           nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

Beispiel #2

Datei: CartModel.py Projekt: vikash93825/Flipkart_clone

class CartModel(db.Model):
    __tablename__ = 'cart'
    id = db.Column(db.Integer, primary_key=True)
    quantity = db.Column(db.Integer, nullable=False)
    total_cost = db.Column(db.Integer, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    product_id = db.column(db.Integer, db.ForeignKey('product.id'))

Beispiel #3

class CommentDetail(db.Model):
    __tablename__ = 'comment_user'
    id = db.Column(db.Integer,primary_key=True)
    product_id = db.Column(db.Integer,db.ForeignKey('product.id'),nullable=False)
    comment_id = db.Column(db.Integer, db.ForeignKey('comments.id'), unique=True, nullable=False)
    upvote = db.Column(db.Integer,nullable=True)
    downvote=db.Column(db.Integer,nullable=True)

Beispiel #4

Datei: OrderModel.py Projekt: nileshcoding/Flipkart_clone

class Orders(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    paid = db.Column(db.Boolean, nullable=False)
    payment_id = db.Column(db.Integer,
                           db.ForeignKey('payment.id'),
                           unique=True,
                           nullable=False)

Beispiel #5

Datei: OrderModel.py Projekt: nileshcoding/Flipkart_clone

class OrderDetail(db.Model):
    _tablename__ = 'order_detail'
    id = db.Column(db.Integer, primary_key=True)
    order_id = db.Column(db.Integer, db.ForeignKey('orders.id'))
    product_id = db.Column(db.Integer, db.ForeignKey('product.id'))
    quantity = db.Column(db.Integer, nullable=False)
    amount = db.Column(db.Integer, nullable=False)
    ship_address = db.Column(db.String(100), nullable=False)

Beispiel #6

class Comments(db.Model):
    __tablename__='comments'
    id = db.Column(db.Integer, primary_key=True)
    comment=db.Column(db.String(255),nullable=False)
    upvote = db.Column(db.Integer,nullable=True)
    downvote=db.Column(db.Integer,nullable=True)
    user_id = db.Column(db.Integer,db.ForeignKey('user.id'))
    product_id=db.Column(db.Integer,db.ForeignKey('product.id'))

Beispiel #7

Datei: CartModel.py Projekt: nileshcoding/Flipkart_clone

class CartDetail(db.Model):
    __tablename__ = 'cart_detail'
    id = db.Column(db.Integer, primary_key=True)
    cart_id = db.Column(db.Integer, db.ForeignKey('cart.id'), nullable=False)
    product_id = db.Column(db.Integer,
                           db.ForeignKey('product.id'),
                           nullable=False)
    quantity = db.Column(db.Integer, nullable=False)
    amount = db.Column(db.Float, nullable=False)

Beispiel #8

Datei: OrderModel.py Projekt: vikash93825/Flipkart_clone

class OrderModel(db.Model):
    __tablename__ = 'order'
    id = db.Column(db.Integer, primary_key=True)
    amount = db.Column(db.Integer, nullable=False)
    shipment = db.Column(db.String(100), nullable=False)
    ship_Address = db.Column(db.String(100), nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

Beispiel #9

class UserAddress(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.String(250), nullable=False)
    user_id = db.Column(db.Integer,
                        db.ForeignKey('user.id'),
                        nullable=False,
                        Unique=True)

Beispiel #10

Datei: CartModel.py Projekt: nileshcoding/Flipkart_clone

class Cart(db.Model):
    __tablename__ = 'cart'
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

Beispiel #11

Datei: product_meta.py Projekt: nileshcoding/Flipkart_clone

class Productmeta(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    image_path = db.Column(db.String(100), nullable=False)
    product_id = db.Column(db.Integer, db.ForeignKey('product.id'))

Beispiel #12

class PaymentModel(db.Model):
    __tablename__ = 'payment'
    id = db.Column(db.Integer, primary_key=True)
    payment_type = db.Column(db.String(200), nullable=False)
    amount = db.Column(db.Integer, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

Beispiel #13

Datei: ProductModel.py Projekt: nileshcoding/Flipkart_clone

class Product(db.Model):
    __tablename__ = 'product'
    id = db.Column(db.Integer, primary_key=True)
    product_name = db.Column(db.String(100), nullable=False)
    product_price = db.Column(db.Float, nullable=False)
    product_category_id = db.Column(db.Integer, db.ForeignKey('category.id'))

Beispiel #14

class WhislistModel(db.model):
    __tablename__ = 'Mywhislist'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

Beispiel #15

Datei: OrderModel.py Projekt: vikash93825/Flipkart_clone

class OrderProduct(db.Model):
    _tablename__ = 'orderproduct'
    id = db.Column(db.Integer, primary_key=True)
    order_id = db.Column(db.Integer, db.ForeignKey('order.id'))
    product_id = db.Column(db.Integer, db.ForeignKey('product.id'))

Beispiel #16

Datei: CategoriesModel.py Projekt: nileshcoding/Flipkart_clone

class TreePath(db.Model):
    __tablename__ = 'Treepath'
    id = db.Column(db.Integer, primary_key=True)
    ancestor = db.Column(db.Integer, db.ForeignKey('category.id'))
    descendants = db.Column(db.Integer, db.ForeignKey('category.id'))