from django.db import models

# Create your models here.
class company_table(models.Model):
    name                = models.CharField(max_length=50,null=True)
    company_code        = models.CharField(max_length=10,null=True)
    email               = models.CharField(max_length=50,null=True)
    address_line_1      = models.CharField(max_length=150, null=True)
    address_line_2      = models.CharField(max_length=150, null=True)
    city                = models.CharField(max_length=15, null=True)
    state               = models.CharField(max_length=15, null=True)
    pincode             = models.IntegerField(null=True)
    gst                 = models.CharField(max_length=20, null=True)
    cin                 = models.CharField(max_length=25, null=True)
    statecode           = models.IntegerField(null=True)
    sales_phone         = models.CharField(max_length=50, null=True)
    service_phone       = models.CharField(max_length=50, null=True)
    store_support_phone = models.CharField(max_length=50, null=True)
    current_fy          = models.IntegerField(null=True)   
    tax_id              = models.IntegerField(null=True, default=0)   
    cp_name             = models.CharField(max_length=100, null=True)
    cp_phone            = models.IntegerField(null=True)
    tax_id              = models.IntegerField(null=True)
    cp_mobile           = models.IntegerField(null=True)
    cp_mail             = models.CharField(max_length=50 ,null=True)
    report_mail         = models.CharField(max_length=50 ,null=True)
    latitude            = models.FloatField(null=True)
    longitude           = models.FloatField(null=True)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="company"