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)
