210330

Tables (6)

Product Branch (product_branch)

  • Product Id (product_id) — INT(11) — Foreign key → product.Product Id — NOT NULL
  • Branch Id (branch_id) — INT(11) — Foreign key → branch.Branch Id — NOT NULL

Product Warehouse (Untitled)

  • Product Id (product_id) — INT(11) — Foreign key → product.Product Id — NOT NULL
  • Warehouse Id (warehouse_id) — INT(11) — Foreign key → warehouse.Warehouse Id — NOT NULL

branch (지점)

  • Branch Id (branch_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Phone (phone) — VARCHAR(20)
  • Location (location) — VARCHAR(50)

category (상품 분류)

  • Category Id (category_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)

product (상품)

  • Product Id (product_id) — INT(11) — Primary key — NOT NULL
  • Price (price) — INT
  • Stock (stock) — INT
  • Name (name) — VARCHAR(50)
  • Category Id (category_id) — INT(11) — Foreign key → category.Category Id — NOT NULL

warehouse (물류 창고)

  • Warehouse Id (warehouse_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Phone (phone) — VARCHAR(20)
  • Location (location) — VARCHAR(50)