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