class FareModel(models.Model): baseFare = models.FloatField() vehicleTypeId = models.TextField() fromTime = models.TimeField(auto_now_add=True) toTime = models.TimeField(auto_now_add=True) status = models.BooleanField(default=True) isDeleted = models.BooleanField(default=False)
class Classes(models.Model): class_id = models.UUIDField(primary_key=True, blank=False, default=uuid.uuid4, editable=False) credit = models.IntegerField(blank=False, verbose_name='credit') section_id = models.PositiveSmallIntegerField( verbose_name="class section ID", blank=False) start_time = models.TimeField(auto_now=False, blank=False, verbose_name="class start time") end_time = models.TimeField(auto_now=False, blank=False, verbose_name="class end time") course_part = models.ForeignKey(to='Courses', on_delete=models.CASCADE, verbose_name='Course part') grade_scale = models.ForeignKey(to='GpaScale', on_delete=models.CASCADE, verbose_name='Grade Scale', blank=False) weights = models.ForeignKey(to='Weights', on_delete=models.CASCADE, verbose_name='Grade weights', blank=False) students = models.ArrayReferenceField(to=Student, on_delete=models.CASCADE) teachers = models.ArrayReferenceField(to=Teacher, on_delete=models.CASCADE) def __str__(self): return str(self.course_part) + '_' + str(self.section_id)
class TimeLine(models.Model): description = models.CharField(max_length=255, null=True) action = models.CharField(max_length=7, choices=ACTIONS) team = models.CharField( max_length=5, choices=(('Black', 'Black'), ('White', 'White')), null=True, ) foul = models.ForeignKey(Foul, models.CASCADE, null=True) time = models.TimeField() timestamp = models.TimeField() class Meta: abstract = True # TODO: Refactor def __str__(self): if self.description: return self.action + ' | ' + self.description if self.action == 'Start' or self.action == 'End' or 'Half Time' in self.action or 'Warning' in self.action: return str( self.timestamp.replace(tzinfo=None)) + ' | ' + self.action line = str(self.timestamp.replace(tzinfo=None)) + ' | ' + str( self.time) + ' | ' + self.action if self.action == 'Foul': return line + ' | ' + self.team + ' | ' + str(self.foul) return line if not self.team else line + ' | ' + self.team
class AttendanceLab(models.Model): date = models.DateField() from_time = models.TimeField() to_time = models.TimeField() lab = models.CharField(max_length=10) batch = models.CharField(max_length=5) year = models.CharField(max_length=3) attendance = models.ArrayModelField(model_container=Attendance)
class SlotF(models.Model): date = models.DateField() time_s = models.TimeField() time_e = models.TimeField() class Meta: abstract = True
class AttendanceSubject(models.Model): date = models.DateField() from_time = models.TimeField() to_time = models.TimeField() subject = models.CharField(max_length=10) division = models.CharField(max_length=5) year = models.CharField(max_length=3) slots = models.IntegerField() attendance = models.ArrayModelField(model_container=Attendance)
class Voccupy(models.Model): eid = models.CharField(max_length=10) edate = models.DateField(default=date.today) etime_s = models.TimeField() etime_e = models.TimeField() class Meta: abstract = True
class Event(models.Model): organiser = models.ForeignKey(User, on_delete=models.PROTECT, related_name="Organiser") title = models.CharField(max_length=50) description = models.CharField(max_length=2500) venue = models.CharField(max_length=100) date = models.DateField() startTime = models.TimeField() endTime = models.TimeField() video = EmbedVideoField(default='') calendar_link = models.CharField(max_length=500, default='')
class Fare(models.Model): _id = models.ObjectIdField(default="") baseFare = models.FloatField() vehicleTypeId = models.TextField() fromTime = models.TimeField(auto_now_add=True) toTime = models.TimeField(auto_now_add=True) status = models.BooleanField(default=True) isDeleted = models.BooleanField(default=False) def __str__(self): return self.vehicleTypeId
class Hashtag(commonInfo): _id = models.ObjectIdField() hashtag_name = models.CharField(max_length=150) strategy = models.ForeignKey(Strategy, on_delete=models.CASCADE) number_of_likes_per_day = models.PositiveIntegerField(default=0) initial_time_to_like_posts = models.TimeField() final_time_to_like_posts = models.TimeField() initial_time_to_comment_posts = models.TimeField() final_time_to_comment_posts = models.TimeField() def __str__(self): return self.hashtag_name
class FondosEmbebido(models.Model): descripcion = models.CharField(max_length=255, blank=False, default='') orientacion = models.CharField(max_length=20, blank=False, default='') url_verde = models.CharField(max_length=255, blank=False, default='') url_ambar = models.CharField(max_length=255, blank=False, default='') url_rojo = models.CharField(max_length=255, blank=False, default='') url_cerrado = models.CharField(max_length=255, blank=False, default='') hora_apertura = models.TimeField(blank=False) hora_cierre = models.TimeField(blank=False) class Meta: abstract = True
class Attendance(models.Model): # Collection name user = models.ForeignKey(User, on_delete=models.CASCADE) date = models.DateField(default=timezone.now) office_hours = models.TimeField() off_hours = models.TimeField() clockin_time = models.TimeField(blank=True, null=True) clockout_time = models.TimeField(blank=True, null=True) clockin_status = models.CharField(max_length=20) clockout_status = models.CharField(max_length=20) total_working_hours = models.FloatField() abnormal_hours = models.FloatField() def __str__(self): return f"{self.user.username}'s Attendance"
class Garage(models.Model): # name of the parking garage/structure/lot. Cannot be None/NULL/Empty String name = models.CharField(max_length=50, null=False, blank=False) # start of the enforcement period. Cannot be None/NULL start_enforce_time = models.TimeField(null=False, blank=False) # end of the enforcement period. Cannot be None/NULL end_enforce_time = models.TimeField(null=False, blank=False) # whether the enforcement period applies to weekends. Default is False enforced_on_weekends = models.BooleanField(default=False) # array/list of DayProbability. [0] = Sunday, ..., [6] = Saturday probability = models.ArrayField(model_container=DayProbability) latitude = models.FloatField() longitude = models.FloatField() def __str__(self): return self.name
class Probability(models.Model): # start time for the probability (15 minute duration). ie) 00:00 == 00:00 <= time < 00:15 time = models.TimeField() # probability value. 0 <= value <= 1 probability = models.FloatField( validators=[MinValueValidator(0.0), MaxValueValidator(1.0)])
class Note(models.Model): title = models.CharField( 'Название', max_length=100, ) description = models.TextField(blank=True, null=True, default=None) theme = models.ArrayReferenceField(to=Theme, verbose_name='Тема заметки', on_delete=models.SET_NULL, blank=True, null=True, default=None) user = models.ArrayReferenceField(to=User, verbose_name='Автор заметки', validators=[ validate_user_field, ]) date = models.DateField( 'Дата напоминания', blank=True, default=None, null=True, ) time = models.TimeField( 'Время напоминания', blank=True, default=None, null=True, ) def __str__(self): return f'{self.title}'
class Bid(models.Model): """ Bid object. The criteria a buyer specifies for a swipe such that he/she is willing to purchase the swipe. """ BID_STATES = [ ( '0', 'Pending' ), # Doesn't meet minimum, sits in the queue until an eligible listing pops up ( '1', 'Accepted' ), # Pairing between buyer and seller has been made (either at the time of bid or after a swipe was created) ( '2', 'Confirmed' ), # Transaction has occured between buyer and seller, whether successful or refund-based ] bid_id = models.AutoField(primary_key=True) status = models.CharField(max_length=1, choices=BID_STATES, default=0) swipe = models.ForeignKey(Swipe, on_delete=models.CASCADE, null=True) buyer = models.ForeignKey(User, on_delete=models.DO_NOTHING) hall_id = models.ForeignKey(DiningHall, on_delete=models.DO_NOTHING) bid_price = models.DecimalField(max_digits=5, decimal_places=2) desired_time = models.TimeField(null=True) visibility = models.ListField( blank=True, null=True, default=[] ) # An array of JSON objects that contains intervals when this buyer wants the swipe
class GenericModel(models.Model): big_int = models.BigIntegerField() bool = models.BooleanField() char = models.CharField(max_length=20) comma_int = models.CommaSeparatedIntegerField() date = models.DateField() date_time = models.DateTimeField() decimal = models.DecimalField(max_digits=10, decimal_places=5) email = models.EmailField() float = models.FloatField() integer = models.IntegerField() null_bool = models.NullBooleanField() pos_int = models.PositiveIntegerField() pos_small_int = models.PositiveSmallIntegerField() slug = models.SlugField() small_int = models.SmallIntegerField() text = models.TextField() time = models.TimeField() url = models.URLField() ip = models.GenericIPAddressField() uuid = models.UUIDField() # TODO: add these # basic_file = models.FileField() # image = models.ImageField() objects = models.DjongoManager()
class myCamaras(models.Model): _id = models.ObjectIdField() instalacion = models.EmbeddedField( model_container=InstalacionEmbebido, null=True, blank=True, ) nombre_camara = models.CharField(max_length=250, blank=False, default='') serial_camara = models.CharField(max_length=250, blank=False, default='') ts = models.TimeField(blank=False) fecha = models.DateField(auto_now_add=True, blank=True, null=True) zonas_camara = models.ArrayField( model_container=ZonaCamara, null=True, blank=True, ) def __unicode__(self): return self.nombre_camara def __str__(self, ): return str(self.nombre_camara) class Meta: db_table = "camaras_historico"
class Message(models.Model): identifier = models.IntegerField() source = models.CharField(max_length=50) # User time_stamp = models.TimeField(auto_now=False, auto_now_add=False) message = models.TextField() def __str__(self): return self.identifier
class Influencer(commonInfo): _id = models.ObjectIdField() strategy = models.ForeignKey(Strategy, on_delete=models.CASCADE) influencer_instagram_id = models.CharField( max_length=255 ) # I don't really know in this moment if needed and the type de Instagram ID from API Oficial Instagram name = models.CharField( max_length=150) # Influencer name, it will be the @ on Instagram number_of_users_to_follow = models.PositiveIntegerField( default=0) # It represents how many users follow in the schedule days_has_to_pass_to_unfollow = models.PositiveIntegerField( default=0) # It sets how many days has to unfollow initial_time_to_follow = models.TimeField( ) # Initial hour to follow people final_time_to_follow = models.TimeField() # Final hour to follow people def __str__(self): return self.name
class Build(models.Model): time_stamp = models.TimeField(auto_now=False, auto_now_add=False) image = models.ImageField(upload_to=None, height_field=None, width_field=None, max_length=None) name = models.CharField(max_length=50) description = models.TextField() source = models.CharField(max_length=50) # User
class reviews(models.Model): class Meta: unique_together = (('review_user_id', 'movie_id'),) review_user_id = models.CharField(max_length=30, blank=False, unique=False) #movie = models.ForeignKey(movies,to_field='movie_id', related_name='movie', on_delete=models.CASCADE, default=None) movie_id = models.IntegerField(unique=False,default=0) review = models.CharField(max_length=300, blank=True, unique=False) rating=models.FloatField(default=0.0) wishlist=models.BooleanField(default=False) liked=models.BooleanField(default=False) watched=models.BooleanField(default=False) review_time=models.TimeField(auto_now=False, default=datetime.datetime.now().time()) review_date=models.DateField(auto_now=False, default=datetime.date.today()) Time=models.TimeField(auto_now=True) Date=models.DateField(auto_now=True) upvote_count=models.IntegerField(default=0) like_reviewers = MultiSelectField(default= None) follow=models.BooleanField(default=False)
class DayTime(models.Model): day_of_week = models.CharField(max_length=20) time = models.TimeField() objects = models.DjongoManager() def __init__(self, *args, **kwargs): super().__init__(*args, **kwargs) def __iter__(self): yield 'day_of_week', self.day_of_week yield 'time', self.time
class Episode(models.Model): series = models.ForeignKey(Series, on_delete=models.CASCADE) episode_id = models.IntegerField() episode_name = models.CharField(max_length=255) episode_length = models.TimeField() episode_date = models.DateField() episode_link = models.URLField() #! Should use file field episode_rating = models.IntegerField() review = models.ForeignKey(Review, on_delete=models.CASCADE) def __str__(self): return self.episode_name
class Abstract_Reading_Collection(models.Model): _id = models.AutoField(primary_key=True, null=False) rack = models.IntegerField() sensor = models.IntegerField() sensor_type = models.CharField(max_length=15) sensor_value = models.IntegerField() datetime = models.IntegerField() date = models.DateField() time = models.TimeField() class Meta: abstract = True
class UserDetails(models.Model): usrId = models.TextField() usrName = models.TextField() usrFirstName = models.TextField() usrLastName = models.TextField() usrMail = models.EmailField() usrImage = models.ImageField() usrPassword = models.TextField() usrCreated = models.TimeField() #models.DateTimeField() def __str__(self): return self.usrName
class Product(models.Model): name = models.CharField(unique=True, max_length=255, null=False) category = models.CharField(max_length=255, null=False) price = models.FloatField(max_length=17, null=False) sku = models.CharField(max_length=13, help_text="Enter Product Stock Keeping Unit") subcategory = models.ForeignKey(SubCategory, on_delete=models.CASCADE) quantity = models.FloatField(help_text="Enter Product Quantity") discription = models.CharField(max_length=255, null=False) created_date = models.TimeField(default=timezone.now) last_updated = models.TimeField(default=timezone.now, editable=True) image = models.ImageField(upload_to='app/', blank=True, null=True) buffer_stock = models.FloatField(help_text="Enter Product Quantity") class Meta: db_table = "product" def __str__(self): return " {} - {} - {} - {} - {} - {} - {} - {} - {} - {} - {}".format( self.name, self.category, self.price, self.sku, self.quantity, self.discription, self.subcategory, self.created_date, self.last_updated, self.image, self.buffer_stock)
class Events(models.Model): org_id = models.CharField(max_length=20) event_name = models.CharField(max_length=50, blank=False) e_date = models.DateField(blank=False) Venue = models.CharField(max_length=20) E_ptime_s = models.TimeField(auto_now=False) E_ptime_e = models.TimeField(auto_now=False) optional = models.BooleanField() slot1 = models.ArrayModelField(model_container=SlotF) slot2 = models.ArrayModelField(model_container=SlotF) Venue_s = models.CharField(max_length=20) rp = models.CharField(max_length=50, blank=False) organi_names = models.ArrayModelField(model_container=OrganiList, null=True) enotes = models.TextField() active_stat = models.BooleanField() objects = models.DjongoManager() def __str__(self): return self.event_name
class neutron_log(models.Model): id = models.IntegerField(primary_key=True) date = models.DateField() time = models.TimeField() host_name = models.TextField() agent_name = models.TextField() priority = models.TextField() agent_details = models.TextField() request_details = models.TextField() remaining_log = models.TextField() def __str__(self): return '%s %s %s %s %s %s %s %s %s' % ( self.id, self.date, self.time, self.host_name, self.agent_name, self.priority, self.agent_details, self.request_details, self.remaining_log)
class horizon_log(models.Model): id = models.IntegerField(primary_key=True) remote_host = models.TextField() date = models.DateField() time = models.TimeField() zone = models.IntegerField() method = models.CharField(max_length=100) browser_path = models.TextField() apache_status = models.IntegerField() data_transfer = models.IntegerField() message = models.TextField() def __str__(self): return '%s %s %s %s %s %s %s %s %s %s' % ( self.id, self.remote_host, self.date, self.time, self.zone, self.method, self.browser_path, self.apache_status, self.data_transfer, self.message)