편의점 상품관리
테이블 (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