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