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)