from django.db import models

# Create your models here.
# 订单信息表
class Order(models.Model):
  id = models.BigAutoField(primary_key=True) # 订单ID
  hazardous_waste = models.IntegerField(default=0) # 有害垃圾
  recyclable_waste = models.IntegerField(default=0) # 可回收垃圾
  household_food_waste = models.IntegerField(default=0) # 湿垃圾（厨余垃圾）
  residual_waste = models.IntegerField(default=0) # 干垃圾
  user_id = models.CharField(max_length=100,null=True) # 用户ID
  create_time = models.DateField(auto_now_add=True) # 创建时间
  update_time = models.DateField(auto_now=True) # 更新时间
  end_time = models.DateField(null=True) # 订单完成时间
  start_time = models.DateField(null=True) # 上门时间
  desc = models.TextField(blank=True,null=True) # 备注
  feedback = models.TextField(blank=True,null=True) # 反馈
  score = models.CharField(max_length=100,blank=True,null=True) # 评分
  is_delete = models.IntegerField(default=0) # 是否删除： 0:未删除；1:删除