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