test

Tables (5)

order

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → user.id — NOT NULL
  • time — TIMESTAMP
  • subtotal — INTEGER

order_product

  • id — INTEGER — Primary key — NOT NULL
  • id (order_id) — INTEGER — Foreign key → order.id — NOT NULL
  • id (product_id) — INTEGER — Foreign key → product.id — NOT NULL
  • amount — INTEGER
  • discount_rate — DOUBLE

product

  • id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(40)
  • price — INTEGER
  • discount_rate — DOUBLE

product_history

  • id — INTEGER — Primary key — NOT NULL
  • product_id — VARCHAR
  • discount_rate — DOUBLE

user

  • id — INTEGER — Primary key — NOT NULL
  • username — VARCHAR(16)