magic_shop
Tables (4)
Customer
- customer_id — int — Primary key — NOT NULL
- type — string
- membership — boolean
- name — string
- age — int
- gender — string
Good
- good_id — int — Primary key — NOT NULL
- type — string
- price — int
Inventory
- inventory_id — Primary key — NOT NULL
- good_id — int — Foreign key → Good.good_id — NOT NULL
- date — date
- stock — int
Order
- order_id — Primary key — NOT NULL
- customer_id — int — Foreign key → Customer.customer_id — NOT NULL
- good_id — int — Foreign key → Good.good_id — NOT NULL
- quantity — int
- date — date