summaryrefslogtreecommitdiff
path: root/website/models.py
blob: 76d07b7d6f0c66a63243a386ba04e43db4309707 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
from django.db import models


"""
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'