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
110
111
112
113
114
115
116
117
118
119
120
121
|
from django.db import models
from django.contrib.auth.models import User
# Create your models here.
events = (
('SLC', 'Scilab Conference'),
('SPC', 'Scipy Conference'),
('PTC', 'Python Textbook Companion'),
('STC', 'Scilab Textbook Companion'),
)
class Profile(models.Model):
user = models.OneToOneField(User)
# other details
uin = models.CharField(max_length=50) #2 intialletters + 6 hexadigits
attendance = models.NullBooleanField()
class Event(models.Model):
purpose = models.CharField(max_length=25, choices=events)
start_date = models.DateTimeField()
end_date = models.DateTimeField()
# other details
class Certificate(models.Model):
name = models.CharField(max_length=100)
email = models.CharField(max_length=50, null=True, blank=True)
serial_no = models.CharField(max_length=50) #purpose+uin+1stletter
counter = models.IntegerField()
workshop = models.CharField(max_length=100, null=True, blank=True)
paper = models.CharField(max_length=100, null=True, blank=True)
verified = models.IntegerField(default=0)
serial_key = models.CharField(max_length=200, null=True)
short_key = models.CharField(max_length=50, null=True)
class Scilab_participant(models.Model):
''' Autogenerated model file csvimport Mon Dec 1 07:46:00 2014 '''
id = models.IntegerField(primary_key=True, null=False)
ticket_number = models.IntegerField(default=0, null=False, blank=False)
name = models.CharField(max_length=50, null=True, blank=True)
email = models.CharField(max_length=50, null=True, blank=True)
ticket = models.CharField(max_length=50, null=True, blank=True)
date = models.CharField(max_length=50, null=True, blank=True)
order_id = models.IntegerField(default=0, null=True, blank=True)
purpose = models.CharField(max_length=10, default='SLC')
attendance = models.BooleanField(default=False)
class Meta:
managed = True
class Scilab_speaker(models.Model):
''' Autogenerated model file csvimport Wed Dec 3 05:36:56 2014 '''
id = models.IntegerField(default=0, null=False, primary_key=True, blank=False)
name = models.CharField(max_length=300)
email = models.CharField(max_length=300)
ticket = models.CharField(max_length=100)
paper = models.CharField(max_length=300)
purpose = models.CharField(max_length=10, default='SLC')
attendance = models.BooleanField(default=False)
class Scilab_workshop(models.Model):
''' Autogenerated model file csvimport Wed Dec 3 06:31:59 2014 '''
id = models.IntegerField(null=False, primary_key=True, blank=False)
name = models.CharField(max_length=300)
ticket_number = models.IntegerField(null=True)
email = models.CharField(max_length=300)
workshops = models.CharField(max_length=300)
purpose = models.CharField(max_length=10, default='SLC')
attendance = models.BooleanField(default=False)
class FeedBack(models.Model):
''' Feed back form for the event '''
name = models.CharField(max_length=100)
email = models.CharField(max_length=100)
phone = models.CharField(max_length=20)
institution = models.CharField(max_length=100)
role = models.CharField(max_length=100)
address = models.CharField(max_length=100)
city = models.CharField(max_length=50)
pin_number = models.CharField(max_length=10)
state = models.CharField(max_length=50)
purpose = models.CharField(max_length=10, default='SLC')
submitted = models.BooleanField(default=False)
answer = models.ManyToManyField('Answer')
class Question(models.Model):
question = models.CharField(max_length=500)
purpose = models.CharField(max_length=10, default='SLC')
class Answer(models.Model):
question = models.ForeignKey(Question)
answer = models.CharField(max_length=1000)
class Scipy_participant(models.Model):
id = models.IntegerField(primary_key=True, null=False)
name = models.CharField(max_length=50, null=True, blank=True)
email = models.CharField(max_length=50, null=True, blank=True)
purpose = models.CharField(max_length=10, default='SPC')
attendance = models.BooleanField(default=False)
class Scipy_speaker(models.Model):
id = models.IntegerField(default=0, null=False, primary_key=True, blank=False)
name = models.CharField(max_length=300)
email = models.CharField(max_length=300)
paper = models.CharField(max_length=300)
purpose = models.CharField(max_length=10, default='SPC')
attendance = models.BooleanField(default=False)
class Drupal_camp(models.Model):
firstname = models.CharField(max_length=200)
lastname = models.CharField(max_length=200)
email = models.EmailField(null=True, blank=True)
# Day 1 - 1, Day 2 - 2, Both days - 3, else 0
attendance = models.PositiveSmallIntegerField(default=0)
role = models.CharField(max_length=100, null=True, blank=True)
purpose = models.CharField(max_length=10, default='DCM')
is_student = models.IntegerField(default=0)
|
