편의점 상품관리

테이블 (5)

Untitled (Branch)

  • id — IntergerField — 기본 키 — NOT NULL
  • country — CharField(max_length=50) — NOT NULL
  • address — CharField(max_length=150) — NOT NULL

Untitled (Product)

  • id — IntegerField — 기본 키 — NOT NULL
  • name — CharField(max_length=150) — NOT NULL
  • price — IntegerField — NOT NULL
  • event_id — IntegerField — 외래 키 → Untitled.id — NOT NULL
  • category_id — CharField(max_length=50) — 외래 키 → Untitled.category — NOT NULL

Untitled (Stock)

  • branch_id — IntergerField — 외래 키 → Untitled.id — NOT NULL
  • product_id — IntegerField — 외래 키 → Untitled.id — NOT NULL
  • stock — IntegerField — NOT NULL

Untitled (Event)

  • id — IntegerField — 기본 키 — NOT NULL
  • title — CharField(max_length=100) — NOT NULL
  • startdate — DateTimeField — NOT NULL
  • enddate — DateTimeField
  • detail — TextField
  • product_id — IntegerField — 외래 키 → Untitled.id — NOT NULL

Untitled (ProductCategory)

  • category — CharField(max_length=50) — 기본 키 — NOT NULL