erd

Tables (3)

CVS (Untitled)

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • store_name — Charfield(max_length=20)
  • address — Charfield(max_length=50)
  • code — IntegerField()
  • phone — CharField(max_length=30)

Products (Untitled2)

  • Key — Primary key — NOT NULL
  • product_name — CharField(max_length=30)
  • brand — Charfield(max_length=20)
  • category — Charfield(max_length=30)
  • price — IntegerField()
  • expire_date — DateTimeField()
  • Key (Key2) — VARCHAR(255) — Foreign key → CVS.Key — NOT NULL
  • Key (Key3) — ManyToManyField(Worker, related_name='managed_products') — Foreign key → Worker.Key — NOT NULL

Worker (Untitled3)

  • Key — Primary key — NOT NULL
  • name — CharField(max_length=30)
  • working_time — IntegerField()
  • work_start — DateTimeField(auto_now=True)
  • work_finish — DateTimeField(auto_now=True)
  • CVS — CVS = models.ForeignKey(CVS, on_delete=models.CASCADE)
  • Key (Key2) — VARCHAR(255) — Foreign key → CVS.Key — NOT NULL