blob: 38ace40a664859293863b8c5851b67826f96ec88 (
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
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'
|
