편의점

테이블 (5)

Logistics (Untitled)

  • Logistics (Key) — PK — 기본 키 — NOT NULL

Product (Untitled3)

  • Product_ID (Key) — PK — 기본 키 — NOT NULL
  • Category_ID (Key3) — Integer — 외래 키 → Store.Store_ID — NOT NULL
  • Store_ID (Key32) — Integer — 외래 키 → Store.Logistics — NOT NULL
  • Product_Name (Field) — CharField
  • Price (Field2) — Integer

Sales (Untitled4)

  • Sales_ID (Key2) — PK — 기본 키 — NOT NULL
  • Product_ID (Key) — Integer — 외래 키 → Product.Product_ID — NOT NULL
  • Time (Field2) — Integer

Stock (Untitled5)

  • Stock_ID (Key) — PK — 기본 키 — NOT NULL
  • Logistics (Key3) — Integer — 외래 키 → Logistics.Logistics — NOT NULL
  • Product_Name (Field) — CharField
  • Price (Field2) — Integer
  • Stock (Field3) — Integer
  • Category (Field4) — CharField

Store (Untitled2)

  • Store_ID (Key) — PK — 기본 키 — NOT NULL
  • Location_ID — Integer — 외래 키 — NOT NULL
  • Logistics (Key3) — Integer — 외래 키 → Stock.Logistics — NOT NULL
  • Phone (Field2) — Integer
  • Owner (Field3) — CharField