from django.db import models

# Create your models here.
class RateLists(models.Model):
    id : models.AutoField(primary_key=True)
    day_types = ((0, 'Day'), (1, 'Night'), (2, 'complete Day'))
    day = models.IntegerField(default=0, choices=day_types)
    duration = models.IntegerField(default=0, null=False, blank=False)
    uniform_types = ((0, 'No'), (1, 'Yes'))
    uniform_type = models.IntegerField(default=0, choices=uniform_types)
    station_types = ((0, 'In Station'), (1, 'Out Station'))
    station_type = models.IntegerField(default=0, choices=station_types)
    trip_types = ((0, 'One way'), (1, 'Round'))
    trip_type = models.IntegerField(default=0, choices=trip_types)
    rate = models.FloatField(null=False, blank=False)
    created_at = models.DateTimeField(auto_now_add=True)   
    updated_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        managed = True
        db_table = 'rates_ratelists'


class AdditionalCharges(models.Model):
    id = models.BigAutoField(primary_key=True)
    title = models.CharField(max_length=255)
    price = models.CharField(max_length=255)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        managed = True
        db_table = 'rates_additionalcharges'


class Taxes(models.Model):
    id = models.BigAutoField(primary_key=True)
    title = models.CharField(max_length=255)
    tax_percentage = models.CharField(max_length=255)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        managed = True
        db_table = 'rates_taxes'

class Daytimes(models.Model):
    id = models.BigAutoField(primary_key=True)
    day_type = models.IntegerField()
    start_time = models.CharField(max_length=255)
    end_time = models.CharField(max_length=255)
    created_at = models.DateTimeField()
    updated_at = models.DateTimeField()

    class Meta:
        managed = True
        db_table = 'rates_daytimes'