class Guess(models.Model):
# Auto Primary Key id
user_id = models.ForiegnKey(User, on_delete=models.CASCADE)
group_id = models.ForiegnKey(Group, on_delete=models.CASCADE)
quote_id = models.ForiegnKey(Quote, on_delete=models.CASCADE)
guess = models.CharField(max_length=50)
is_correct = models.BooleanField(default=false)
class Quote(models.model):
# Auto Primary Key id
group_id = models.ForiegnKey(Group, on_delete=models.CASCADE)
user_id = models.ForiegnKey(User, on_delete=models.CASCADE)
quote = models.CharField(max_length=200)
quote_details = models.CharField(max_length=200)
answer = models.CharField(max_length=50)
post_date = models.DateTimeField('date posted')
class GroupMember(models.Model):
group = models.ForiegnKey(Group, related_name='memberships')
user = models.ForiegnKey(User, related_name='user_groups')
def __str__(self):
return self.user.username
class Meta:
unique_together = ('group', 'user')
class Category(MP_Node):
name = models.CharField(max_length=100, blank=False, null=False)
node_order_by = ['name']
parent_category = models.ForeignKey(Category, blank=True) # If Category has no parent, it is a prime category
TYPE_CHOICES = (
('PRIME', 'Prime Category'),
('SUB', 'Sub-Catagory'),
('OBJ', 'Asset')
)
_type = models.CharField(max_length=15, choices=TYPE_CHOICES, default='OBJ', blank=False, null=False)
description = models.CharField(max_length=500, blank=True)
features = models.CharField(max_length=300, blank=True)
ISBN = models.CharField(max_length=13, blank=True)
model_number = models.CharField(max_length=100, blank=True)
publish_date = models.DateFIeld(blank=True)
edition = models.CharField(max_length=50, blank=True)
author = models.CharField(max_length=300, blank=True)
publisher = models.CharField(max_length=300, blank=True)
vendor = models.CharField(max_length=300, blank=True)
value = models.DecimalField(max_digits=None, decimal_places=2, blank=True)
picture = models.ImageField(upload_to=None, height_field=None, width_field=None, max_length=100, blank=True)
current = models.BooleanField() # Is this asset the most current, or is it out of date
admin = models.ForiegnKey(User, blank=True) # If blank or null, then category must inhertit admin from parent category, prime category must have admin
consumables = models.ManyToManyField(Consumable, blank=True) #do i use null or blank?
def __str__(self):
if self._type == 'OBJ':
return 'Asset Type: %s' % self.name
else:
return 'Category: %s' % self.name
class Post(models.Model):
user = models.ForeignKey(User, related_name='posts')
created_at = models.DateTimeField(auto_now=True)
message = models.TextField()
message_html = models.TextField(editable=False)
group = models.ForiegnKey(Group,
related_name='posts',
null=True,
blank=True)
def __str__(self):
return self.message
def save(self, *args, **kwargs):
self.message_html = misaka.html(self.message)
super().save(*args, **kwargs)
def get_absolute_url(self):
return reverse('posts:single',
kwargs={
'username': self.user.username,
'pk': self.pk
})
class Meta:
[ordering] = ['-created_at']
unique_together = ['user', 'message']
class OpinionForDrug(models.Model):
objects = jmodels.jManager()
drug = models.ForeignKey('Drug', on_delete = models.CASCADE, null = False, blank = False, verbose_name = 'دارو')
author = models.ForiegnKey('MyUser', on_delete = models.CASCADE, null = False, blank = False, verbose_name = 'نویسنده')
title = models.CharField(db_index = True, max_length = 300, null = True, blank = True, verbose_name = 'عنوان')
text = models.TextField(max_length = 1000, null = False, blank = False, verbose_name = 'متن')
date = jmodels.jDateField(default = jdatetime.date.today, null = False = blank = True, verbose_name = 'تاریخ ثبت')
class Event(models.Model):
"""
An event entry for an organization.
"""
name = models.CharField(max_length=100, db_index=True)
description = models.TextField(max_length=1000, null=True, blank=True)
tagline = models.CharField(max_length=200, null=True, blank=True)
organization = models.ForiegnKey(Organization, db_index=True)
class Meta:
db_table = 'events'
class Progression(model.Model):
met = models.BooleanField(default=False)
creds = models.IntegerField
courses = models.ManyToManyField('Course')
reqtype = models.BooleanField #T=Specific, F=Generic
sreq = models.ForeignKey('SpecificRequirement', on_delete=models.CASCADE)
greq = models.ForiegnKey('GenericRequirement', on_delete=models.CASCADE)
def get_req():
if(req):
return sreq
else:
return greq
class Page(models.Model):
serchword = models.ForiegnKey(Searchword)
url = models.CharField(max_length = 100)
title = models.CharField(max_length = )
def page_preview():
return " content preview"
pass
page_preview = models.TextField(max_length = "some number" , default = page_preview() )
rank = models.FloatField(max_degit = 19 , decimal_places = "some_number" , editable = False)
def number_clicks():
pass
clicks = models.IntegerField(max_length = 4 , default = number_clicks())
class Meta:
db_table = page
def __unicode__ (self):
return self.url
class Asset(models.Model):
active = models.BooleanField()
asset_tag = models.CharField(db_index=True, max_length=10, primary_key=True, null=False, blank=False)
category = models.ForiegnKey(Category, blank=False, null=False)
name = models.CharField(max_length=300, blank=False, null=False)
serial_number = models.CharField(max_length=100, blank=True)
CONDITION_CHOICES = (
('10', 'New'),
('8', 'Great'),
('6', 'Good'),
('4', 'Acceptable'),
('2', 'Poor'),
('0', 'Terrible')
)
condition = models.CharField(max_length=20, choices=CONDITION_CHOICES, default='10', blank=True)
possession = models.ForeignKey(User, blank=True) #Who has the asset right now
def __str__(self):
return "%s %s" % (self.asset_tag, self.name)
class Movie(models.Model):
NOT_RATED = 0
RATED_G = 1
RATED_PG = 2
RATED_R = 3
RATINGS = (
(NOT_RATED, "NR - Not Rated"),
(RATED_G, "G - General Audiences"),
(RATED_PG, "PG - Parent Guidance Suggested"),
(RATED_R, "R - Restricted"),
)
title = models.CharField(max_length = 140)
plot = models.TextField()
year = models.PositiveIntegerField()
rating = models.PositiveIntegerField(
choices=RATINGS,
default=NOT_RATED
)
runtime = models.PositiveIntegerField()
website = models.URLField(blank = True)
poster = models.ImageField(upload_to='media/uploads/%Y/%m/%d/', blank= True)
director = models.ForiegnKey(
to="Person",
on_delete =models.SET_NULL,
related_name="directed",
null=True,
blank=True )
writer = models.ManyToManyField(
to="Person",
related_name="writing_credits",
blank=True)
class Meta:
ordering = ("-year", "title")
def __str__(self):
return "{} ({})" .format(self.title, self.year)
class peer(models.Model):
file_hash = models.ForiegnKey(fileorFolder, on_delete=models.CASCADE)
peer = models.CharField(max_length=16)
class Speeches(models.Model):
mem_id = models.ForiegnKey(Members)
speech_number = models.IntegerField()
speech_title = models.CharField(max_length=128)
class Roles(models.Model):
meeting_date = models.DateTimeField('Meeting Date')
thought_of_day = models.ForiegnKey(Members)
ah_counter = models.ForiegnKey(Members)
grammarian = models.ForiegnKey(Members)
timer = models.ForiegnKey(Members)
gen_eval = models.ForiegnKey(Members)
speech1 = mmodels.ForiegnKey(Members)
speech2 = mmodels.ForiegnKey(Members)
speech3 = models.ForiegnKey(Members)
speech4 = mmodels.ForiegnKey(Members)
table_topics = models.ForiegnKey(Members)
eval1 = models.ForiegnKey(Members)
eval2 = models.ForiegnKey(Members)
eval3 = models.ForiegnKey(Members)
eval4 = models.ForiegnKey(Members)
attendee1 = models.ForiegnKey(Members)
attendee2 = models.ForiegnKey(Members)
attendee3 = models.ForiegnKey(Members)
attendee4 = mmodels.ForiegnKey(Members)
attendee5 = models.ForiegnKey(Members)
attendee6 = models.ForiegnKey(Members)
attendee7 = models.ForiegnKey(Members)
attendee8 = models.ForiegnKey(Members)
attendee9 = models.ForiegnKey(Members)
attendee10 = models.ForiegnKey(Members)
class TelecomTrans(object):
"""docstring for TelecomTrans"""
phone_number = models.CharField()
company = models.ForiegnKey('TelecomBrand')
service_fees = models.FloatField()
class Users_Poke(models.Model):
poke = models.ForiegnKey(Poke)
User = models.ForiegnKey(User)
created_at = models.DateTimeField(auto_now_add = True)
updated_at = models.DateTimeField(auto_now = True)
class FoodReview (models.Model):
writer = models.ForeignKey('Person')
food = models.ForiegnKey('Food')
content = models.CharField(max_length = 1000)
class Poke(models.Model):
poke = models.IntegerField(default=0)
user = models.ForiegnKey(User)
created_at = models.DateTimeField(auto_now_add = True)
updated_at = models.DateTimeField(auto_now = True)
class Card(models.Model):
number = models.CharField(max_length=100)
balance = models.FloatField()
user = models.ForiegnKey('User')
bank = models.ForiegnKey('Bank')
class CardTrans(object):
"""docstring for CardTrans"""
card_to = models.ForiegnKey('Card')
service_fees = models.FloatField()
class Song(models.Model):
album = models.ForiegnKey(Albums, on_delete=models.CASCADE)
file_type = models.CharField(max_length=10)
song_title = models.charField(max_length=100)
class Transaction(models.Model):
amount = models.FloatField()
card_from = models.ForiegnKey('Card')
date = models.DateTimeField(auto_now=True)
class Plant(SiteSpecificModel):
name = models.CharField(verbose_name='Common Name',
max_length=128,
help_text="Common name for this plant")
sku = models.CharField(
verbose_name='Inventory SKU',
max_length=32,
)
latin_name = models.CharField(
verbose_name='Latin Name',
max_length=128,
blank=True,
null=True,
help_text="Latin name for this plant, e.g. <em>Lathyrus odoratus</em>")
plant_family = models.ForiegnKey(
PlantType,
verbose_name="Plant Family",
on_delete=models.PROTECT,
help_text="Of which plant family is this plant a part?")
season = models.ManyToManyField(
GrowingSeason,
on_delete=models.PROTECT,
null=True,
db_table='plant_season',
help_text="During what growing seasons does this plant grow?")
# plant image
# seed image
# seed flowering image
# Consider django-measurement for this
plant_height = models.IntegerField(
'Plant height',
blank=True,
null=True,
help_text="Average height of plant when full grown, in inches")
# ------------------
# Planting info
# ------------------
planting_instructions = models.TextField(
verbose_name='Planting Instructions',
blank=True,
null=True,
help_text="Enter any planting instructions specific to this plant")
# Consider django-measurement for this
planting_depth = models.IntegerField(
verbose_name='Planting depth',
blank=True,
null=True,
help_text="Optimal planting depth for seeds, in inches")
# Consider django-measurement for this
planting_spacing = models.IntegerField(
'Planting spacing',
blank=True,
null=True,
help_text="Optimal spacing for plants when planting, in inches")
# ------------------
# Growing info
# ------------------
growing_instructions = models.TextField(
verbose_name='Growing Instructions',
blank=True,
null=True,
help_text="Enter any post-planting growing instructions here.")
sun = models.ForeignKey(verbose_name='Sun Exposure',
on_delete=models.PROTECT,
null=True,
help_text='What kind of sun does this plant need?')
water = models.TextField(verbose_name='Watering requirements',
blank=True,
null=True,
help_text='Watering instructions for this plant?')
days_to_germination = models.PositiveIntegerField(
verbose_name='Days to Germination',
blank=True,
null=True,
help_text="Number of days since planting before the seed germinates")
days_to_germination = models.PositiveIntegerField(
verbose_name='Days to Maturity',
blank=True,
null=True,
help_text="Number of days since planting before the plant is mature")
days_to_seed_output = models.PositiveIntegerField(
verbose_name='Days to Maturity',
blank=True,
null=True,
help_text="Number of days since planting before seeds can be "
"harvested from the mature plant")
seed_saving_instructions = models.TextField(
verbose_name='Seed Saving Instructions',
blank=True,
null=True,
help_text="Instructions on how to save seeds for this plant")
class Meta:
db_table = "plant"
verbose_name = "Plant"
verbose_name_plural = "Plants"
ordering = ["name"]
unique_together = ['site', 'name']
class Rider(models.Model):
def__init__(self, name, rider_is_member):
self.name= models.ForiegnKey(Rider, on_delete = models.CASCADE)
