from django.db import models

# Create your models here.

class TextbookCompanionCategoryList(models.Model):
    id = models.IntegerField(unique=True, primary_key=True)
    category_name = models.CharField(max_length=100)
    category_id = models.IntegerField()
    maincategory = models.CharField(max_length=255)

    class Meta:
        db_table = 'list_of_category'

class TextbookCompanionSubCategoryList(models.Model):
    id = models.IntegerField(unique=True, primary_key=True)
    subcategory_id = models.IntegerField()
    subcategory = models.CharField(max_length=255)
    maincategory_id = models.IntegerField()

    class Meta:
        db_table = 'list_of_subcategory'

class TextbookCompanionProposal(models.Model):
    id = models.IntegerField(unique=True, primary_key=True)
    uid = models.IntegerField()
    approver_uid = models.IntegerField()
    full_name = models.CharField(max_length=50)
    mobile = models.CharField(max_length=15)
    gender = models.CharField(max_length=10)
    how_project = models.CharField(max_length=50)
    course = models.CharField(max_length=50)
    branch = models.CharField(max_length=50)
    university = models.CharField(max_length=100)
    faculty = models.CharField(max_length=100)
    reviewer = models.CharField(max_length=100)
    completion_date = models.IntegerField()
    creation_date = models.IntegerField()
    approval_date = models.IntegerField()
    proposal_status = models.IntegerField()
    message = models.TextField()
    scilab_version = models.CharField(max_length=20)
    operating_system = models.CharField(max_length=20)
    teacher_email = models.CharField(max_length=20)

    class Meta:
        db_table = 'textbook_companion_proposal'


class TextbookCompanionPreference(models.Model):
    id = models.IntegerField(unique=True, primary_key=True)
    proposal = models.ForeignKey(
        TextbookCompanionProposal, on_delete=models.CASCADE)
    pref_number = models.IntegerField()
    book = models.CharField(max_length=100)
    author = models.CharField(max_length=100)
    isbn = models.CharField(max_length=25)
    publisher = models.CharField(max_length=50)
    edition = models.CharField(max_length=2)
    year = models.IntegerField()
    category = models.IntegerField()
    approval_status = models.IntegerField()
    cloud_pref_err_status = models.IntegerField()

    class Meta:
        db_table = 'textbook_companion_preference'


class TextbookCompanionChapter(models.Model):
    id = models.IntegerField(primary_key=True)
    preference = models.ForeignKey(
        TextbookCompanionPreference, on_delete=models.CASCADE)
    number = models.IntegerField()
    name = models.CharField(max_length=255)
    cloud_chapter_err_status = models.CharField(max_length=255)

    class Meta:
        db_table = 'textbook_companion_chapter'


class TextbookCompanionExample(models.Model):
    id = models.IntegerField(primary_key=True)
    chapter = models.ForeignKey(
        TextbookCompanionChapter, on_delete=models.CASCADE)
    approver_uid = models.IntegerField()
    number = models.CharField(max_length=10)
    caption = models.CharField(max_length=255)
    approval_date = models.IntegerField()
    approval_status = models.IntegerField()
    timestamp = models.IntegerField()
    cloud_err_status = models.IntegerField()

    class Meta:
        db_table = 'textbook_companion_example'


class TextbookCompanionExampleFiles(models.Model):
    id = models.IntegerField(primary_key=True)
    example = models.ForeignKey(
        TextbookCompanionExample, on_delete=models.CASCADE)
    filename = models.CharField(max_length=255)
    filepath = models.CharField(max_length=500)
    filemime = models.CharField(max_length=255)
    filesize = models.IntegerField()
    filetype = models.CharField(max_length=1)
    caption = models.CharField(max_length=100)
    timestamp = models.IntegerField()

    class Meta:
        db_table = 'textbook_companion_example_files'