From 06e73e7cd1c99ce224ee594b1e11129bc9a4e422 Mon Sep 17 00:00:00 2001
From: Jayaram Pai
Date: Wed, 25 Dec 2013 03:23:55 +0530
Subject: code tested for Scilab 5.3.3

---
 website/models.py | 69 ++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 file changed, 68 insertions(+), 1 deletion(-)

(limited to 'website/models.py')

diff --git a/website/models.py b/website/models.py
index 71a8362..76d07b7 100644
--- a/website/models.py
+++ b/website/models.py
@@ -1,3 +1,70 @@
 from django.db import models
 
-# Create your models here.
+
+"""
+Models from Scilab Database created using inspectdb
+Use it with the "scilab" database eg:using("scilab") 
+These models are used only for django orm reference.
+"""
+class TextbookCompanionPreference(models.Model):
+    id = models.IntegerField(unique=True, primary_key=True)
+    proposal_id = models.IntegerField()
+    pref_number = models.IntegerField()
+    book = models.CharField(max_length=100L)
+    author = models.CharField(max_length=100L)
+    isbn = models.CharField(max_length=25L)
+    publisher = models.CharField(max_length=50L)
+    edition = models.CharField(max_length=2L)
+    year = models.IntegerField()
+    category = models.IntegerField()
+    approval_status = models.IntegerField()
+    cloud_pref_err_status = models.IntegerField()
+    class Meta:
+        db_table = 'textbook_companion_preference'
+
+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=50L)
+    mobile = models.CharField(max_length=15L)
+    gender = models.CharField(max_length=10L)
+    how_project = models.CharField(max_length=50L)
+    course = models.CharField(max_length=50L)
+    branch = models.CharField(max_length=50L)
+    university = models.CharField(max_length=100L)
+    faculty = models.CharField(max_length=100L)
+    reviewer = models.CharField(max_length=100L)
+    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=20L)
+    operating_system = models.CharField(max_length=20L)
+    teacher_email = models.CharField(max_length=20L)
+    class Meta:
+        db_table = 'textbook_companion_proposal'
+
+class TextbookCompanionChapter(models.Model):
+    id = models.IntegerField(primary_key=True)
+    preference_id = models.IntegerField()
+    number = models.IntegerField()
+    name = models.CharField(max_length=255L)
+    cloud_chapter_err_status = models.CharField(max_length=255L)
+    class Meta:
+        db_table = 'textbook_companion_chapter'
+
+class TextbookCompanionExample(models.Model):
+    id = models.IntegerField(primary_key=True)
+    chapter_id = models.IntegerField()
+    approver_uid = models.IntegerField()
+    number = models.CharField(max_length=10L)
+    caption = models.CharField(max_length=255L)
+    approval_date = models.IntegerField()
+    approval_status = models.IntegerField()
+    timestamp = models.IntegerField()
+    cloud_err_status = models.IntegerField()
+    class Meta:
+        db_table = 'textbook_companion_example'
+
-- 
cgit