1 files changed, 116 insertions, 0 deletions
diff --git a/website/models.py b/website/models.py
index 71a8362..a10670a 100644
--- a/website/models.py
+++ b/website/models.py
@@ -1,3 +1,119 @@
 from django.db import models
 
 # Create your models here.
+
+class Banner(models.Model):
+    title = models.CharField(max_length=500)
+    banner = models.TextField(max_length=1000)
+    position = models.IntegerField()
+    visible = models.BooleanField()
+
+    def __str__(self):
+        return self.banner
+
+
+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'