class Message(models.Model): sender = models.Foreignkey( User, related_name = "sender_user" ) receiver = models.Foreignkey( User, related_name = "receiver_user" ) message = models.CharField(max_length = 200) received_at = models.DateTimeField(auto_now_add=True)
class Review(models.Model): user = models.Foreignkey('User', on_delete=models.CASCADE, verbose_name="리뷰작성자") sitter = models.Foreignkey('Sitter', on_delete=models.CASCADE, verbose_name="시터") title = models.CharField(max_length=100, verbose_name="게시판제목") contents = models.TextField(max_length=1000, verbose_name="게시판내용") star_score = models.CharField(max_length=1, choices=star_score_choice, verbose_name="별점")
class loggedinUser(models.Model): name = models.CharField(max_length=50) age = models.IntegerField() image = models.ForeignKey(Image, on_delete=models.CASCADE) Bio = models.TextField(max_length=700) dbuser = models.Foreignkey(DBUSER , on_delete= models.CASCADE) mycomment = models.ForeignKey(Comments, on_delete=models.CASCADE) def __str__(self): return self.name, self.image def save_loggedin_user(self): return self.save() @classmethod def search_dbuser_by_name(cls,search): return cls.objects.filter(dbuser__name__icontains=search) @classmethod def update_image(): @classmethod def delete_image(cls, id): return cls.objects.filter(image_id=id) @classmethod def delete_comment(cls, id): return cls.object.filter(mycomment=id)
class PurchaseOrder(models.Model): po_number = modles.Autofield() organization = models.Foreignkey(Organization) shipto = models.ForeignKey(Location) soldby = models.Charfield(max_length=25) lineitem = modles.Foreignkey(PoDetalis) expected_by = models.DateTimefield()
class Company(models.Model): company_name = models.TextField(max_length=255) website = models.URLfield(max_length=255) assigned_to = models.Foreignkey(User, on_delete=models.DO_NOTHING) qfl_relationship = models.TextField(man_length = 100) def __str__(self): return self.first_name + " " + self.last_name
class Webpage(models.Model): topic = models.Foreignkey(Topic, on_delete=models.CASCADE) name = models.CharField(max_length=264, unique=True) url = models.URLField(unique=True) def __str__(self): return self.name
class Page(models.Model): category = models.Foreignkey(Category) titke = models.CharField(max_length=128) url = models.URLField() views = models.IntegerField(default=0) def __unicode__(self): return self.title
class Task(models.Model): id = models.AutoField(primary_key=True) username = models.Foreignkey(Username, on_delete=models.CASCADE) title = models.CharField(max_length=200) description = models.CharField(max_length=1000, blank=True) date_of_creation = models.DateTimeField(auto_now_add=True) priority = models.CharField(max_length=30, choices=PRIORITIES, default=PRIORITIES[0][0]) complete = models.IntegerField(default=0)
class Sitter_schedule(models.Model): sitter = models.Foreignkey('Sitter', on_delete=models.CASCADE, verbose_name="시터") month = models.ChoiceField(max_length=100, choices=month_choice, verbose_name="시터가능달") day = models.ChoiceField(max_length=100, choices=day_choice, verbose_name="시터가능요일")
class Mascota(models.Model): folio = models.CharField(max_length=10, primary_key=True) nombre = models.CharField(max_length=50) sexo = models.CharField(max_length=50) edad_aproximada = models.IntegerField() fecha_rescate = models.DateField() persona = models.Foreignkey(Persona, null=True, blank=True, on_delete=models.CASCADE)
class Testimonial(models.Model): text = models.TextField() person = models.Foreignkey(Person, on_delete=models.CASCADE, related_name='testimonials') class Meta: verbose_name = 'Getuigenis' verbose_name_plural = 'Getuigenissen'
class Customers(models.Model): #learners tip: first Letter stays capital in the name. Customer_id = models.IntegerField(primary_key = True) Customer_name = models.CharField(max_length = 20) Customer_address = models.CharField(max_length = 100) phone_no = models.PhoneNumberField(null=False, blank=False, unique=True) billing_amt = models.IntegerField() people_accompanying = models.IntegerField(max_length = 10) #tbd Timestamp = models.DateTimeField('Entry time') bench_num = models.Foreignkey( 'Bench Number', on_delete=models.CASCADE, ) leave foreign_key for now.
class Comment(models.Model): post = models.Foreignkey(Post, editable=False, related_name='comments') author = models.CharField(max_length=100) likes = models.ManyToManyField(settings.AUTH_USER_MODEL, related_name='likes', blank=True) class Meta: unique_together = ('post') def __str__(self): return self.author
class Fecha(models.Model): ESTADOS = (("A", "Activo"), ("I", "Inactivo"), ("F", "Finalizado"), ("E", "En espera")) promocion_Id = models.Foreignkey('Promocion', on_delete=models.CASCADE) fechaInicio = models.DateField() fechaExpiracion = models.DateField() estado = models.CharField(max_length=2) def __srt__(self): return self.fechaInicio class Meta: db_table = "Fecha"
class Post(models.Model): author = models.Foreignkey('auth.User', on_delete=models.CASCADE) title = models.CharField(max_length=200), text = models.TextField() created_data = models.DataTimeField(default=timezone.now) published_data = models.DataTimeField(blank=True, null=True) def publish(self): self.published_data = timezone.now() self.save() def __str__(self): return self.title
class Board(models.Model): board = models.AutoField(primary_key=True, verbose_name="게시판") user = models.Foreignkey('User', on_delete=models.CASCADE, verbose_name="글쓴이") board_type = models.CharField(max_length=10, choices=board_type_choice, verbose_name="게시판종류") title = models.CharField(max_length=100, verbose_name="게시판제목") contents = models.TextField(max_length=1000, verbose_name="게시판내용") creating_date = models.DateTimeField(auto_now_add=True, verbose_name="게시판작성일") attachments = models.FileField(upload_to='uploads/', verbose_name="첨부파일") hit = models.IntegerField(default=0, verbose_name="게시판조회수")
class post(models.model) author = models.Foreignkey('auth.user') title = models.CharField(max_length=200) text = models.TextField() created_date = models.DateTimeField( default=timezone.now) published_date = models.DateTimeField( blank=True, null=True) def publish(self): delf.published_date = timezone.now() self.save() def_str_(self): return self.title
class Comment(models.Model): post = models.Foreignkey('blog.post', related_name='comments') author = models.CharField(max_length=200) text = models.TextField() create_date = models.DateTimeField(default=timezone.now()) approved_comment = models.BooleanField(default=False) def approve(self): self.approved_comment = True self.save() def get_absolute_url(self): return reverse('post_list') def __str__(self): return self.text
class CustomUrl(models.Model): id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False) created_at = models.DateTimeField(auto_now_add=True) expires_in = models.DurationField(null=True, blank=True) content_type = models.Foreignkey(ContentType, on_delete=models.CASCADE) object_id = models.UUIDField() for_object = GenericForeignKey() url = models.URLField() url_type = models.CharField( max_length=10, choices=(("SHORT", "SHORTENED URL"), ("FRONTEND", "FRONTEND URL")), ) description = models.TextField(default="") class Meta: unique_together = ("content_type", "object_id", "url_type") def __str__(self): return str(self.url)
class Post(models.Model): author = models.Foreignkey('auth.User') title = models.CharField(max_length=200) text = models.TextField() create_date = models.DateTimeField(default=timezone.now()) published_date = models.DateTimeField(blank=True, null=True) def publish(self): self.published_date = timezone.now() self.save() def approve_comments(self): return self.comments.filter(approved_comment=True) def get_absolute_url(self): return reverse("post_detail", kwargs={'pk': self.pk}) def __str__(self): return self.title
class AbstractIPAddress(TimeStampedEditableModel): """ An abstract base class model that provides various details for IPAddress management """ ip_address = models.GenericIPAddressField() description = models.TextField(null=True, blank=True) section = models.ForeignKey(swapper.get_model_name('django_ipam', 'Section')) subnet = models.Foreignkey(swapper.get_model_name('django_ipam', 'Subnet')) ip_status = models.CharField(choices=(('used', 'used'), ('free', 'free'))) gateway = models.GenericIPAddressField() hostname = models.CharField(verbose_name=_('hostname'), max_length=255) netmask = models.GenericIPAddressField() class Meta: abstract = True
class Post(models.Model): STATUS_CHOICES = ( ('draft', 'Draft'), ('published', 'Published'), ) title = models.CharField(max_length=250) slug = models.SlugField(max_length=250, unique_for_date='publish') author = models.Foreignkey(User, on_delete=models.CASCADE, related_name='blog_posts') body = models.TextField() publish = models.DateTimeField(default=timezone.now) created = models.DateTimeField(auto_now_add=True) updated = models.DateTimeField(auto_now=True) status = models.CharField(max_length=10, choices=STATUS_CHOICES, default='draft') class Meta: ordering = ('-publish', ) def __str__(self): return self.title
class Alerta(models.Model): codProduct = models.Foreignkey(ProductAssignment, on_delete=models.CASCADE, verbose_name='codigo del producto asignado')
class stock (models.Model): product=models.Foreignkey(producto) stock=models.Integerfield(held_text='Ingrese la cantidad de platillos:')
class Choice(models.Model): question = models.Foreignkey(Question, on_delete=models.CASCADE) choice_text = modles.Charfield(max_length=200) votes = models.IntegerField(default=0)
class Foo(models.Model): bar = models.CharField(max_length=100) owner = models.Foreignkey(User, related_name='foos')
class MaintenanceItem(models.Models): maintenance = models.Foreignkey(Maintenance) item = JSONField() # 用json來存維修的細項,但這樣的話下面的PartNo class 的意義就不大了。
class Withdraw(models.Model): accountname = models.CharField(max_length=25) accountnumber = models.IntegerField(max_length=10) Money_to_withdraw = models.IntegerField Register = models.Foreignkey(Register, on_delete=models.CASCADE)
class Upload(models.Model): user = models.Foreignkey(UserProfile) image = models.ImageField(upload_to='user_images')
class Product(models.Model): name = models.CharField(max_length=255) price = models.DecimalField() description = models.TextField() release_date = models.DateField() manufacturer = models.Foreignkey(Manufacturer)