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