편의점_상품_관리

테이블 (7)

CVstore

  • CVstore_id — INT(10) — 기본 키 — NOT NULL
  • location — INT(5)
  • contact — INT(11)
  • Branch name — VARCHAR(255)
  • HQ_id — INT(10) — 외래 키 → Headquater.HQ_id — NOT NULL

Customer order (Untitled)

  • Key — 기본 키 — NOT NULL

Headquater

  • HQ_id — INT(10) — 기본 키 — NOT NULL
  • location — INT(5)
  • contact — INT(11)

Stock_cvstore

  • Stock_cvstore — INT(10) — 기본 키 — NOT NULL
  • CVstore_id — INT(10) — 외래 키 → CVstore.CVstore_id — NOT NULL
  • Name — VARCHAR(255)
  • Category — VARCHAR(255)
  • Quantity — INT(100)
  • Price — INT(100)
  • Expiration date — date
  • Key — 외래 키 → Customer order.Key — NOT NULL

Stock_total

  • Stock_id — INT(10) — 기본 키 — NOT NULL
  • Store_or_ware — INT(10)
  • Name — VARCHAR(255)
  • Category — VARCHAR(255)
  • Quantity — INT(100)
  • Price — INT(100)
  • Expiration date — date
  • Stock_cvstore — INT(10) — 외래 키 → Stock_cvstore.Stock_cvstore — NOT NULL
  • Stock_warehouse — INT(10) — 외래 키 → Stock_warehouse.Stock_warehouse — NOT NULL

Stock_warehouse

  • Stock_warehouse — INT(10) — 기본 키 — NOT NULL
  • Warehouse_id — INT(10) — 외래 키 → Warehouse.Warehouse_id — NOT NULL
  • Name — VARCHAR(255)
  • Category — VARCHAR(255)
  • Quantity — INT(100)
  • Price — INT(100)
  • Expiration date — date
  • Key — 외래 키 → Customer order.Key — NOT NULL

Warehouse

  • Warehouse_id — INT(10) — 기본 키 — NOT NULL
  • HQ_id — INT(10) — 외래 키 → Headquater.HQ_id — NOT NULL
  • location — INT(5)
  • contact — INT(11)