Convini

Tables (3)

Goods (goods)

  • id (Key) — Integer — Primary key — NOT NULL
  • Name (name) — Text
  • Stock (stock) — Integer
  • Company (company) — Text
  • Price (price) — Integer
  • Expiration_date (exp) — Date

Order (order)

  • id (Key) — Integer — Primary key — NOT NULL
  • goods_id (Key2) — Integer — Foreign key → Goods.id — NOT NULL
  • store_id (Key3) — Integer — Foreign key → Store.id — NOT NULL
  • Date (date) — Date
  • quantity — Integer
  • Total_price (total) — Integer

Store (store)

  • id (Key) — Integer — Primary key — NOT NULL
  • Store_name (store_name) — Text
  • address — Text
  • phone_number — Phone_number