VendingMachine
Tables (10)
DefaultVMResource (기본자판기자원)
- PK (id) — NOT NULL — Primary key — NOT NULL
- FK (resource_id) — NOT NULL — Foreign key → Resource.PK — NOT NULL
- 이름 (name) — NOT NULL
- 자원양 (quantity) — NOT NULL
LeftChange (현금잔액)
- 100원 (coin100) — NULL
- 500원 (coin500) — NULL
- 1000원 (paper1000) — NULL
- 5000원 (paper5000) — NULL
Orders (주문)
- PK (id) — NOT NULL — Primary key — NOT NULL
- FK (machine_id) — NOT NULL — Foreign key → VendingMachine.PK — NOT NULL
- FK (product_id) — NOT NULL — Foreign key → Product.PK — NOT NULL
- FK (payment_id) — NOT NULL — Foreign key → payment.PK — NOT NULL
- 가격 (price) — NOT NULL
Product (제품)
- PK (id) — NOT NULL — Primary key — NOT NULL
- 제품명 (name) — NOT NULL
- 가격 (price) — NOT NULL
Product (제품V1)
- Key (menu_id) — NOT NULL — Primary key — NOT NULL
- 블랙커피 (BlackCoffee) — NULL
- 믹스커피 (MixCoffee) — NULL
- 설탕커피 (SugarCoffee) — NULL
- 레몬티 (LemonTea) — NULL
- 유자티 (CironTea) — NULL
ProductResource (제품자원)
- PK (id) — NOT NULL — Primary key — NOT NULL
- FK (product_id) — NOT NULL — Foreign key → Product.PK — NOT NULL
- FK (resource_id) — NOT NULL — Foreign key → Resource.PK — NOT NULL
- 양 (amount) — NOT NULL
Resource (자원)
- PK (id) — NOT NULL — Primary key — NOT NULL
- 이름 (name) — NOT NULL
VMResource (자판기자원)
- PK (id) — NOT NULL — Primary key — NOT NULL
- FK (resource_id) — NOT NULL — Foreign key → Resource.PK — NOT NULL
- PK (vm_id) — NOT NULL — Foreign key → VendingMachine.PK — NOT NULL
- 이름 (name) — NOT NULL
- 자원양 (quantity) — NOT NULL
VendingMachine (자판기)
- PK (id) — NOT NULL — Primary key — NOT NULL
- 자판기명 (name) — NOT NULL
- 위치 (location) — NOT NULL
payment (지불방법)
- PK (id) — NOT NULL — Primary key — NOT NULL