Project_EasyOrder

Tables (5)

Untitled (store)

  • Key (store_id) — Long — Primary key — NOT NULL
  • Field (store_name) — String
  • Key (user_id) — string — Foreign key → Untitled.Key — NOT NULL

Untitled (product)

  • Key (product_id) — Long — Primary key — NOT NULL
  • Field (product_name) — String

Untitled (stock)

  • Key (stock_id) — Long — Primary key — NOT NULL
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (stock) — int

Untitled (users)

  • Key (user_id) — string — Primary key — NOT NULL
  • Field (password) — string

sale

  • sale_id — Long — Primary key — NOT NULL
  • sale_date — Date
  • store_number (sale_count) — int
  • Key (store_number) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — Long — Foreign key → Untitled.Key — NOT NULL