Notes

# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models


# Create your models here.
class Vendor(models.Model):
id = models.AutoField(primary_key=True)
name = models.CharField(null=True, max_length=255)
type = models.CharField(null=True, max_length=255)
description = models.TextField(null=True)
code = models.CharField(null=True, max_length=255)

def __unicode__(self):
return self.name

class Meta:
db_table = "vendors"
verbose_name = "Vendor"


class Super_Category(models.Model):
id = models.AutoField(primary_key=True)
name = models.CharField(max_length=255, unique=True)

def __unicode__(self):
return self.name

class Meta:
db_table = "super_categories"
verbose_name = "Super_Categorie"


class Category(models.Model):
id = models.AutoField(primary_key=True)
super_category_id = models.ForeignKey(Super_Category, null=True, blank=True, on_delete=models.CASCADE)
name = models.CharField(max_length=255, unique=True)

def __unicode__(self):
return self.name

class Meta:
db_table = "categories"
verbose_name = "Categorie"


class Sub_Category(models.Model):
id = models.AutoField(primary_key=True)
category_id = models.ForeignKey(Category, null=True, blank=True, on_delete=models.CASCADE)
name = models.CharField(max_length=255, unique=True)

def __unicode__(self):
return u"%s" % (self.name if self.name else "Sub_Category not found")
# return self.name

class Meta:
db_table = "sub_sategories"
verbose_name = "Sub_Categorie"


class Brands(models.Model):
brand_id = models.AutoField(primary_key=True)
vender_id = models.ForeignKey(Vendor, null=True, blank=True, on_delete=models.CASCADE)
brand_name = models.CharField(max_length=255, null=True, unique=True)
brand_description = models.TextField(null=False)
other_brand_details = models.TextField(null=False)

def __unicode__(self):
return u"%s" % (self.brand_name if self.brand_name else "Brand not found")
# return self.brand_name

class Meta:
db_table = "brands"
verbose_name = "Brand"


# class Ref_Product_Types(models.Model):
# product_type_code = models.AutoField(primary_key=True)
# vender_id = models.ForeignKey(Vendor)
# perent_product_code = models.CharField(max_length=255, unique=True) # foreign key
# product_type_description = models.TextField(null=True)
#
# def __unicode__(self):
# return self.perent_product_code
#
# class Meta:
# db_table = "ref_product_types"
# verbose_name = "Ref_Product_Type"


class Products(models.Model):
product_id = models.AutoField(primary_key=True)
brand_id = models.ForeignKey(Brands, null=True, blank=True, on_delete=models.CASCADE)
vender_id = models.ForeignKey(Vendor, null=True, blank=True, on_delete=models.CASCADE)
category_id = models.ForeignKey(Category, null=True, blank=True, on_delete=models.CASCADE)
product_unique_id = models.CharField(max_length=255, null=True, unique=True)
product_name = models.TextField(null=True)
product_url = models.TextField(null=True)
category_path = models.TextField(null=True)
other_product_details = models.TextField(null=True)

def __unicode__(self):
return u"%s" % (self.product_name if self.product_name else "Product not found")
# return self.product_name

class Meta:
db_table = "products"
verbose_name = "Product"



class Ref_Colours(models.Model):
color_code = models.AutoField(primary_key=True)
color_description = models.CharField(max_length=255, null=True, unique=True)

def __unicode__(self):
return self.color_description

class Meta:
db_table = "ref_colours"
verbose_name = "Ref_Colour"


class Product_Colours(models.Model):
products_id = models.ForeignKey(Products, null=True, blank=True, on_delete=models.CASCADE)
color_code = models.ForeignKey(Ref_Colours, null=True, blank=True, on_delete=models.CASCADE)

def __unicode__(self):
return self.color_code.color_description

class Meta:
db_table = "product_colours"
verbose_name = "Product_Colour"


class Retailers(models.Model):
retailer_id = models.AutoField(primary_key=True)
retailer_name = models.CharField(max_length=255, null=True, unique=True)
retailer_average_rating = models.CharField(max_length=255, null=True)
estimated_delivery_time = models.CharField(max_length=255, null=True)
shipping_charges = models.CharField(max_length=255, null=True)

def __unicode__(self):
return self.retailer_name

class Meta:
db_table = "retailers"
verbose_name = "Retailer"


class Retailer_Product_Prices(models.Model):
products_id = models.ForeignKey(Products, null=True, blank=True, on_delete=models.CASCADE)
retailer_id = models.ForeignKey(Retailers, null=True, blank=True, on_delete=models.CASCADE)
min_price = models.CharField(max_length=255, null=True)
max_price = models.CharField(max_length=255, null=True)

currency = models.CharField(max_length=255, null=True)
large_image_url = models.TextField(null=True)
medium_image_url = models.TextField(null=True)
small_image_url = models.TextField(null=True)
reviews = models.TextField(null=True)

def __unicode__(self):
return self.products_id.product_name

class Meta:
db_table = "retailer_product_prices"
verbose_name = "Retailer_Product_Price"


class Special_Offers(models.Model):
special_offers_id = models.AutoField(primary_key=True)
products_id = models.ForeignKey(Products, null=True, blank=True, on_delete=models.CASCADE)
retailer_id = models.ForeignKey(Retailers, null=True, blank=True, on_delete=models.CASCADE)
start_date = models.DateTimeField()
end_date =models.DateTimeField()
min_price = models.CharField(max_length=255, null=True)
max_price = models.CharField(max_length=255, null=True)
terms_and_conditions = models.TextField(null=True)
other_details = models.TextField(null=True)

def __unicode__(self):
return self.products_id.product_name

class Meta:
db_table = "special_offers"
verbose_name = "Special_Offer"

#
# class Payment_Method(models.Model):
# payment_method_code = models.AutoField(primary_key=True)
# products_id = models.ForeignKey(Products)
# retailer_id = models.ForeignKey(Retailers)
#
# class Meta:
# db_table = "payment_method"
# verbose_name = "Payment_Method"


class Customers(models.Model):
customers_id = models.AutoField(primary_key=True)
# payment_method_code = models.ForeignKey(Payment_Method)
customer_code = models.CharField(max_length=255)
customer_name = models.CharField(max_length=255)
customer_address = models.CharField(max_length=255)
customer_phone = models.IntegerField(null=True)
customer_email = models.EmailField(null=True)
other_customer_details = models.TextField(null=True)

def __unicode__(self):
return self.customer_name

class Meta:
db_table = "customers"
verbose_name = "Customer"


class Customer_Orders(models.Model):
order_id = models.AutoField(primary_key=True)
customer_id = models.ForeignKey(Customers, null=True, blank=True, on_delete=models.CASCADE)
# order_state_code = models.ForeignKey(Status)
order_date = models.DateTimeField()
other_details = models.TextField()

def __unicode__(self):
return self.customer_id.customer_name

class Meta:
db_table = "customer_Orders"
verbose_name = "Customer_Order"


class Customer_Order_Products(models.Model):
order_id = models.ForeignKey(Customer_Orders, null=True, blank=True, on_delete=models.CASCADE)
retailer_id = models.ForeignKey(Retailers, null=True, blank=True, on_delete=models.CASCADE)
product_id = models.ForeignKey(Products, null=True, blank=True, on_delete=models.CASCADE)
quantity = models.IntegerField(null=True)
other_details = models.TextField(null=True)

def __unicode__(self):
return self.product_id.product_name

class Meta:
db_table = "customer_order_products"
verbose_name = "Customer_Order_Product"


class Customer_Orders_Special_Offers(models.Model):
order_id = models.ForeignKey(Customer_Orders, null=True, blank=True, on_delete=models.CASCADE)
special_offer_id = models.ForeignKey(Special_Offers, null=True, blank=True, on_delete=models.CASCADE)
date_order_placed = models.DateTimeField()
quantity = models.IntegerField(null=True)
total_value = models.IntegerField(null=True)
other_details = models.TextField(null=True)

def __unicode__(self):
return self.special_offer_id.products_id.products_name

class Meta:
db_table = "customer_orders_special_offers"
verbose_name = "Customer_Orders_Special_Offer"


class Search_Items(models.Model):
item_id = models.AutoField(primary_key=True)
item = models.CharField(unique=True, max_length=255)

def __unicode__(self):
return self.item

class Meta:
db_table = "search_Items"
verbose_name = "Search_Item"